0 Replies Latest reply: May 7, 2012 2:19 AM by user10648897 RSS

    Login problem in 11g Ent. by Linux OS user in multi SID environment

    user10648897
      Dear All,

      I have 11g Ent. Database having 3 SID. I need to login SQL plus by Linux 5.5 OS user but it giving error.

      but when i tried it by Oracle user it smoothly loged in.

      we have used export ORACLE_SID=C014BANR

      Error:

      003)rscbdc.com:/home/fnsonlc>sqlplus testr

      SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 9 12:39:08 2011

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

      Enter password:
      ERROR:
      ORA-12505: TNS:listener does not currently know of SID given in connect
      descriptor


      Enter user-name:


      *****************************
      tnsnames.ora


      $ cat tnsnames.ora_6may2012
      # tnsnames.ora Network Configuration File: /oracle/oracle11g/app/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
      # Generated by Oracle configuration tools.

      C014BANR =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rscbdc.com)(PORT = 1523))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = c014banr)
      )
      )

      C013BANS =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rscbdc.com)(PORT = 1522))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = c013bans)
      )
      )

      C012BAND =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rscbdc.com)(PORT = 1521))
      (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = c012band)
      )
      )

      *************************************
      listener.ora

      # listener.ora Network Configuration File: /oracle/oracle11g/app/product/11.2.0/dbhome_1/network/admin/listener.ora
      # Generated by Oracle configuration tools.

      #ADR_BASE_LISTENER_C014BANR = /oracle/oracle11g/app

      #ADR_BASE_LISTENER_C013BANS = /oracle/oracle11g/app

      LISTENER_C012BAND =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rscbdc.com)(PORT = 1521))
      )
      )

      #ADR_BASE_LISTENER = /oracle/oracle11g/app
      #ADR_BASE_LISTENER_C012BAND = /oracle/oracle11g/app
      LISTENER_C014BANR =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rscbdc.com)(PORT = 1523))
      )
      )

      LISTENER_C013BANS =
      (DESCRIPTION_LIST =
      (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = rscbdc.com)(PORT = 1522))
      )
      )

      Thanks in advance..!