troubleshooting Question

Error while connecting to idle instance

Avatar of f_o_o_k_y
f_o_o_k_yFlag for Poland asked on
Oracle Database
4 Comments1 Solution472 ViewsLast Modified:
Hello,
I need your help.
I've installed oracle 10g r2 database and apply patch 10.2.0.3
Than created database.
And I've managed to use dbconsole so everything was working (earlier i configured listener and tns)
Than I wanted to shutdown database and all services.
After that I started listener:
 lsnrctl start
then:
sqlplus /nolog
conn sys/ as sysdba
enter password
ORA-12560: TNS: protocol adapter error occurred

And I cannot connect to idle instance.
Why? and how to fix that?

I was looking for solution and I also looked for my listener.ora and tnsnames.ora files to check if there is a difference with my working database but there is not.
Best Regards
FooKy

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros