OraFAQ Forum: Backup & Recovery » ora-12203 TNS unable to connect

Home » RDBMS Server » Backup & Recovery » ora-12203 TNS unable to connect (Oracle Db 10G, windows 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-12203 TNS unable to connect [message #686850]

Thu, 26 January 2023 06:21

hissam78
Messages: 189
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

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686851 is a reply to message #686850]

Thu, 26 January 2023 07:46

Michel Cadot
Messages: 68511
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.

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686852 is a reply to message #686851]

Thu, 26 January 2023 09:55

hissam78
Messages: 189
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 858 times)

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686853 is a reply to message #686851]

Thu, 26 January 2023 09:56

Barbara Boehmer
Messages: 9063
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.

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686854 is a reply to message #686852]

Thu, 26 January 2023 10:03

Barbara Boehmer
Messages: 9063
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.

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686855 is a reply to message #686854]

Thu, 26 January 2023 10:21

hissam78
Messages: 189
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/

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686856 is a reply to message #686855]

Thu, 26 January 2023 11:06

Barbara Boehmer
Messages: 9063
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?

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686858 is a reply to message #686852]

Fri, 27 January 2023 02:39

John Watson
Messages: 8880
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.

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686864 is a reply to message #686856]

Fri, 27 January 2023 10:16

hissam78
Messages: 189
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.

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686865 is a reply to message #686858]

Fri, 27 January 2023 10:21

hissam78
Messages: 189
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,

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686866 is a reply to message #686865]

Fri, 27 January 2023 11:04

Michel Cadot
Messages: 68511
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.

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686869 is a reply to message #686866]

Fri, 27 January 2023 11:43

hissam78
Messages: 189
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?

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686870 is a reply to message #686869]

Fri, 27 January 2023 12:16

Michel Cadot
Messages: 68511
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)

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686872 is a reply to message #686870]

Fri, 27 January 2023 18:04

hissam78
Messages: 189
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?

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686873 is a reply to message #686870]

Fri, 27 January 2023 19:52

hissam78
Messages: 189
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 337 times)

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686874 is a reply to message #686873]

Fri, 27 January 2023 21:14

Barbara Boehmer
Messages: 9063
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

Report message to a moderator

Re: ora-12203 TNS unable to connect [message #686875 is a reply to message #686874]

Sat, 28 January 2023 00:29

Michel Cadot
Messages: 68511
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 04 12:14:39 CDT 2023