Home » RDBMS Server » Backup & Recovery » ora-12203 TNS unable to connect (Oracle Db 10G, windows 10)
ora-12203 TNS unable to connect [message #686850] Thu, 26 January 2023 06:21 Go to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Dear Respectful Experts,
Unfortunately Oracle DB showing TNS Unable to connect error message when try to connect using username and password, somebody can help how to connect db Please. Thankful
Re: ora-12203 TNS unable to connect [message #686851 is a reply to message #686850] Thu, 26 January 2023 07:46 Go to previous messageGo to next message
Michel Cadot
Messages: 68644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12203: TNS:unable to connect to destination
 *Cause: Invalid address specified or destination is not listening.
 This error can also occur because of underlying network or network
 transport problems.
 *Action: Verify that the net service name you entered was correct.
 Verify that the ADDRESS portion of the connect descriptor which
 corresponds to the net service name is correct.  Ensure that the
 destination process (for example the listener) is running at the
 remote node.
Re: ora-12203 TNS unable to connect [message #686852 is a reply to message #686851] Thu, 26 January 2023 09:55 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Thanks for reply Michel Cadot
Yes services for listener and Orcl stopped and not able to start, showing the error attached in png file format. please guide what to do please?
Thankful
  • Attachment: services.png
    (Size: 135.37KB, Downloaded 1702 times)
Re: ora-12203 TNS unable to connect [message #686853 is a reply to message #686851] Thu, 26 January 2023 09:56 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
Senior Member
I see you are using Windows 10 operating system as I am. You can check the TNS listener status by left clicking on the Windows icon in the lower left of your desktop, then scroll down to windows administrative tools and select services. That should open a window where you can scroll down to something that starts with Oracle and ends with Listener, for example I have OracleOraDB12Home1TNSListener. Then you can see the status and, if you click on it, you can start it. Once the listener is started, then you can do the same with OracleServiceORCL to start the database. The listener must be started before the database. If none of this works, you may at least get some additional error messages that help diagnose the problem. This is not the only way to access things and it can help to know how you are accessing it and whether this is a new installation or an existing one that has suddenly stopped working. Windows frequently has problems where an attempted automated startup times out during the automated process and needs to be started manually this way.
Re: ora-12203 TNS unable to connect [message #686854 is a reply to message #686852] Thu, 26 January 2023 10:03 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
Senior Member
It looks like you and I were posting about the same time and you have already done a lot of what I suggested and answered some questions. It is a little hard to read the second error message, but it says something about timing out. So, the problem may just be that it took too long. There is a box that says that when you start it from there you can specify parameters. Try changing those parameters to allow more time and try again. Also, if there are any things that you can temporarily shut down on your computer to enable it to start the listener more quickly that might help.
Re: ora-12203 TNS unable to connect [message #686855 is a reply to message #686854] Thu, 26 January 2023 10:21 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Thanks Barbara Boehmer for reply,
Yes i have tried to resolve the problem as you already suggested,
It is existing Database suddenly happen this error.
i have followed the following website link to resolve the issue but not able to resolve.

https://appuals.com/how-to-fix-error-1053-the-service-did-not-respond-to-the-start-or-control-request-in-a-timely-fashion/

Re: ora-12203 TNS unable to connect [message #686856 is a reply to message #686855] Thu, 26 January 2023 11:06 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
Senior Member
Is there anything that has been changed recently on the entire system?

Is this a standalone personal computer system or is there a remote connection?
Re: ora-12203 TNS unable to connect [message #686858 is a reply to message #686852] Fri, 27 January 2023 02:39 Go to previous messageGo to next message
John Watson
Messages: 8930
Registered: January 2010
Location: Global Village
Senior Member
It looks as though you have three 10g Oracle Homes and three database listener services. Which home and listener are you trying to use? Usually, you would need to run the db, the listener, and SQL*Plus from the same home. You also need to be aware of which ports are being used for each.
Re: ora-12203 TNS unable to connect [message #686864 is a reply to message #686856] Fri, 27 January 2023 10:16 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Thanks for reply,
Barbara Boehmer
No changes have been made, but i think for long time windows was not shutdown, but even restart again , problem not resolved.
it is standalone computer.
basically we do not have a backup of data which is inside database. if TNS issue not resolved , i can reinstall again oracle db. but the problem is how to take existing data backup from db.
Re: ora-12203 TNS unable to connect [message #686865 is a reply to message #686858] Fri, 27 January 2023 10:21 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Thanks a lot for reply,
John Watson
I agree with you we are using the third one to login user and for all procedure to follow. but no success. it was working fine but all of sudden it happen.
we are worried about the data, which inside the database , we did not take a backup for one month.
Please help in this regards,
Re: ora-12203 TNS unable to connect [message #686866 is a reply to message #686865] Fri, 27 January 2023 11:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If your DB and SQL*Plus are from the same home, you don't need the listener and network alias to connect.

Re: ora-12203 TNS unable to connect [message #686869 is a reply to message #686866] Fri, 27 January 2023 11:43 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Michel Cadot Thanks for reply,
got it, but how to connect db or otherwise how to take backup of data from database because it is not allowed to connect with db?
Re: ora-12203 TNS unable to connect [message #686870 is a reply to message #686869] Fri, 27 January 2023 12:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
E:\>rman target=/

Recovery Manager: Release 11.2.0.4.0 - Production on Ven. Janv. 27 19:15:52 2023

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: MIKB2 (DBID=288523517)
Re: ora-12203 TNS unable to connect [message #686872 is a reply to message #686870] Fri, 27 January 2023 18:04 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
Thanks a lot Michel Cadot
I will follow your instruction, please let me know how to restore after taking rman backup in the database?
Re: ora-12203 TNS unable to connect [message #686873 is a reply to message #686870] Fri, 27 January 2023 19:52 Go to previous messageGo to next message
hissam78
Messages: 193
Registered: August 2011
Location: PAKISTAN
Senior Member
I have tried to run the rman utility but showing the error , attached in .png format for your kind information. please guide
  • Attachment: rman.png
    (Size: 55.89KB, Downloaded 1050 times)
Re: ora-12203 TNS unable to connect [message #686874 is a reply to message #686873] Fri, 27 January 2023 21:14 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9090
Registered: November 2002
Location: California, USA
Senior Member
If you are following Michel's example, then you are missing target.

C:\Windows\System32>rman target system/system@orcl

Recovery Manager: Release 12.1.0.2.0 - Production on Fri Jan 27 19:09:00 2023

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1427110714)

RMAN>

So, yours should be:

C:\WINDOWS\system32>rman target system/oracle78@orcl2

Re: ora-12203 TNS unable to connect [message #686875 is a reply to message #686874] Sat, 28 January 2023 00:29 Go to previous message
Michel Cadot
Messages: 68644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

...and as I said you don't need @orcl2 if you are in the same home than the db, just set ORACLE_SID.

Previous Topic: RMAN backups not registering in repository
Next Topic: Oracle cannot open database
Goto Forum:
  


Current Time: Wed Apr 24 03:25:13 CDT 2024