How do I fix error ORA-12505?
There are several methods of correcting error ORA-12505. Your first action to resolve this issue should be to wait a few seconds, then try to re-connect to the database again. If this attempt is unsuccessful, try checking to see which instances are known by the listener.
What is ora12505?
ORA-12505 means that the listener knows about that database, but the listener hasn’t received a notification from the database that the database is up. (If you were trying to connect to the wrong database, using the wrong SID, you would get an ORA-12154 error “TNS: could not resolve the connect identifier specified”.)
How do I find Oracle SID?
The location path of your Oracle Home Registry is as follows:
- HKEY_LOCAL_MACHINE >> SOFTWARE >> ORACLE>>
- Oracle_SID will show your SID.
- Oracle_Home will show the location of your DB Home.
- Oracle_BUNDLE_NAME will show the edition of your Oracle Database.
- Oracle_SVCUSER will show the windows user for your Oracle Database.
How do I start Oracle listener in Windows?
To start Oracle Net Listener, do the following:
- Start the listener with the Listener Control utility.
- Start the database, as follows:
- Confirm that database service registration with the listener has completed using the Listener Control utility using the following command: LSNRCTL> SERVICES [listener_name]
What is Oracle SID?
The system identifier (SID) is a unique name for an Oracle database instance on a specific host. On UNIX and Linux, Oracle Database uses the SID and Oracle home values to create a key to shared memory. Application and Networking Architecture.
Is Oracle SID same as service name?
Oracle SID is the unique name that uniquely identifies your instance/database where as Service name is the TNS alias that you give when you remotely connect to your database and this Service name is recorded in Tnsnames.
How do I find Oracle path in Windows?
Find $ORACLE_HOME on Windows tips
- From your PC, click Start | Run.
- In the Run dialog box, type “regedit” and press Return.
- The registry will now be displayed.
- Expand the folder called [HKEY_LOCAL_MACHINE]\SOFTWARE\ORACLE.
How do I open Oracle database in Windows?
To start or shut down Oracle Database:
- Go to your Oracle Database server.
- Start SQL*Plus at the command prompt: C:\> sqlplus /NOLOG.
- Connect to Oracle Database with username SYSDBA: SQL> CONNECT / AS SYSDBA.
- To start a database, enter: SQL> STARTUP [PFILE=path\filename]
- To stop a database, enter: SQL> SHUTDOWN [mode]
What are three Oracle shutdown modes?
There are several modes for shutting down a database: normal, immediate, transactional, and abort. Some shutdown modes wait for certain events to occur (such as transactions completing or users disconnecting) before actually bringing down the database.
How do I find my Oracle Database name in Windows?
How to Find Out Your Oracle Database Name
- Through V$DATABASE. SQL> select name from V$database; NAME ——— XE.
- Through GLOBAL_NAME. GLOBAL_NAME has the default value of db_name + db_domain.
- Through dbms_utility.get_parameter_value.
- Summary.
How do I find the Oracle Service name in Windows?
Right click on your Connection/Propriety. You should see the name on the left under something like “connection details” and should look like “Connectionname@servicename”, or on the right, under the connection’s details.
How do I install Oracle listener service in Windows?
What does the error ora-12505 mean?
Instead, you connect to a TNS listener, which then connects you to the database. The error ORA-12505 means that the listener was up and you could connect to it, but it couldn’t connect you to the database because it doesn’t know that that database is up. There are two reasons for this:
Does ora-12505 know the Sid given in connect descriptor 0?
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 0 Can’t connect with Oracle sqldeveloper or sqlplus Related 2
What are the TNS listener errors in ora-12505?
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 0 Can’t connect with Oracle sqldeveloper or sqlplus Related 2 TNS Listener error 0 SQLplus client crash from remote machine oracle 11g XE 1 ODP.NET problems with TNS, 32 bits client 64 bits database 2 Can’t connect to Oracle using tns 1
What does ora-12154 error mean?
(If you were trying to connect to the wrong database, using the wrong SID, you would get an ORA-12154 error “TNS: could not resolve the connect identifier specified”.) What Oracle services are running in the Services snap-in?