How to solve the ora 12505 tns listener does not currently know of SID given in connect descriptor?

How to solve the ora 12505 tns listener does not currently know of SID given in connect descriptor?

To resolve this problem, use the listener. ora parameter USE_SID_AS_SERVICE_listener_name. This parameter will tell the listener to use the SID in the connect descriptor as a service name and allow you to connect the client to this particular database.

How do I fix error ora 12505?

Solution: Open Services, and start OracleServiceXE , after that try to connect… 1)The name of the database XE by default.so the url will be”jdbc:oracle:thin:@localhost:1521:XE”. Note that if your are using a SID, then there is a colon (“:”) instead of a slash (“/”) after the host name.

What is Oracle SID?

The Oracle System ID (SID) is used to uniquely identify a particular database on a system. For this reason, one cannot have more than one database with the same SID on a computer system. When using RAC, all instances belonging to the same database must have unique SID’s.

What is the difference between SID and service name in oracle?

Oracle SID is the unique name that uniquely identifies your instance/database, whereas the Service name is the TNS alias that you give when you remotely connect to your database, and this Service name is recorded in tnsnames.

What is Sid in Unix?

The SID is a site identifier. It plus the Oracle_home are hashed together in Unix to create a unique key name for attaching an SGA. If your Oracle_sid or Oracle_home is not set correctly, you’ll get “oracle not available” since we cannot attach to a shared memory segment that is identified by magic key.

Why do I get an ora-12505.tns error?

I get the following error. ORA-12505. TNS: listener does not currently know of SID given in connect descriptor. And same all other credentials work fine. You have to use Service Names to connect to Pluggable Databases in 12c. It’s just one of those things that can trip you up, I guess!

Which is listener does not know Sid given in connect descriptor?

TNS: listener does not currently know of SID given in connect descriptor – Database Administrators Stack Exchange sqldeveloper ORA-12505. TNS: listener does not currently know of SID given in connect descriptor

When does TNS not know of Sid given in connect descriptor?

“ORA-12505: TNS:listener does not currently know of SID given in connect descriptor” when testing database connection ** Troubleshooting ** “Connection failed” “ORA-12505: TNS:listener does not currently know of SID given in connect descriptor” when testing database connection

Why is the database listener unable to resolve the Sid?

The Oracle® database listener was unable to resolve the SID. other service. The connect descriptor received by the listener specified a SID for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener.

https://www.youtube.com/watch?v=ZTMsdH4hyrE