12 Replies Latest reply on May 15, 2014 10:37 PM by jgarry

    How to connect oracle database from different OS user.

    AK_AppsDBA

      Hi experts,

       

      I have installed oracle 11g on Linux.

      --> oracle is user and dba is group having ownership on oracle software.

       

      Can we give permission to another OS user to create and access the databases.


      Steps did:

      I have created another OS user with name test, assigned dba group sets the bash_profile.

       

      when m creating or connecting to existing database this gives me error:

       

       

      [test@server1 ~]$ export ORACLE_SID=prod

      [test@server1 ~]$ sqlplus / as sysdba

       

      SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 19 02:02:47 2014

      Copyright (c) 1982, 2009, Oracle.  All rights reserved.

       

      ERROR:

      ORA-12547: TNS:lost contact

       

      Enter user-name: