Monday, June 11, 2012

Oracle 11g TNS:listener does not currently know of SID given in connect descriptor

This Short Oracle 11g Database Troubleshooting try to Solve the Browser Console Manager Error with Message:

TNS:listener does not currently know of SID given in connect descriptor

Try the Proposed Solutions and See if they Solve your Particular Situation...

Linux Penguin Oracle 11g

  1. Check if the Listener is Started
    1. Login a Oracle User
      su oracle
    2. Check if Listener is Started
      lsnrctl status

      Look if a Listener Instance is Started.

      Take Note in Otput of the Path to listener.ora

  2. Restart the Database
    sqlplus '/ as sysdba'
    > shutdown immediate
    > startup
    Wait Until the Database is Opened
    > exit
    Exit
  3. Re-Connect to Database Manager
    https://127.0.0.1:1158/em
    If Prompted for User/Pass Then you are Done!

    Then to Connect Insert:
    User -> SYS
    Password
    Select SYSDBA from Dropdown


If your Problem is Still Not Solved Look this Other Guide2Solve+  Joomla Website Development Oracle 11g Database Backup, Oracle 11g Backup, Linux Install Oracle 11g
Drupal Website Development

No comments:

Post a Comment