This discussion is archived
5 Replies Latest reply: Feb 19, 2013 7:37 PM by 989658 RSS

ora-12505

989658 Newbie
Currently Being Moderated
Hi Guys,

I am working in an environment where we we have oracle 11g working on server and have its own tnsname.ora file. In order to check some of dba features i have installed oracle 11g express addition as independent database on my client machine where i could access dba based operations. When i am trying to create a new schema within 11g express edition by using following commands, after creation when i am trying to access database then getting ora-12505 erro, listener does not know of SID given:
create user abc identified by ghi;

grnat connect, resource, dba to abc;
after creating new schema, when try to connect even to system or sys it gives me above error mentioned, how would i be able to overcome this issue,

Thanks in advance.

Zaid
  • 1. Re: ora-12505
    asahide Expert
    Currently Being Moderated
    Hi,

    Check your listener with follow command..
    $ lsnrctl status
    Regards,
  • 2. Re: ora-12505
    989658 Newbie
    Currently Being Moderated
    Hi,

    i am sending copy of my listener.ora and tnsnames.ora, hopefully you could guide me to fix this issue
    listener.ora
    
    SID_LIST_LISTENER =
      (SID_LIST =
        (SID_DESC =
          (SID_NAME = PLSExtProc)
          (ORACLE_HOME = G:\oracle\app\oracle\product\11.2.0\server)
          (PROGRAM = extproc)
        )
        (SID_DESC =
          (SID_NAME = CLRExtProc)
          (ORACLE_HOME = G:\oracle\app\oracle\product\11.2.0\server)
          (PROGRAM = extproc)
        )
      )
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
          (ADDRESS = (PROTOCOL = TCP)(HOST = D125595.corp.org.local)(PORT = 1521))
        )
      )
    
    DEFAULT_SERVICE_LISTENER = (XE)
    
    tnsnames.ora
    
    XE =
      (DESCRIPTION =
        (ADDRESS = (PROTOCOL = TCP)(HOST = D125595.corp.org.local)(PORT = 1521))
        (CONNECT_DATA =
          (SERVER = DEDICATED)
          (SERVICE_NAME = XE)
        )
      )
    
    EXTPROC_CONNECTION_DATA =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
        )
        (CONNECT_DATA =
          (SID = PLSExtProc)
          (PRESENTATION = RO)
        )
      )
    
    ORACLR_CONNECTION_DATA = 
      (DESCRIPTION = 
        (ADDRESS_LIST = 
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) 
        ) 
        (CONNECT_DATA = 
          (SID = CLRExtProc) 
          (PRESENTATION = RO) 
        ) 
      ) 
  • 3. Re: ora-12505
    asahide Expert
    Currently Being Moderated
    Hi,
    $ ps -elf | grep tnslsnr
    $ lsnrctl start
    $ lsnrctl status
    Regards,
  • 4. Re: ora-12505
    yoonas Expert
    Currently Being Moderated
    Hi,

    Do you have more than one oracle products installed?
    Please post the way you connect and following message from sqlplus

    Whats the output
    sqlplus <username>/<password>@xe
    Regards
    Yoonas
  • 5. Re: ora-12505
    989658 Newbie
    Currently Being Moderated
    Hi Thank, its resolved.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points