• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 539
  • Last Modified:

tns protocol error

I have two different databases
orcl123 and company
I cannot connect company database
it shows error
This is the what is happening when I connect two diffent database.
set oracle_sid=orcl123
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.

Total System Global Area  535662592 bytes                                      
Fixed Size                  1334380 bytes                                      
Variable Size             255853460 bytes                                      
Database Buffers          272629760 bytes                                      
Redo Buffers                5844992 bytes                                      
Database mounted.
SQL> alter database open;

Database altered.

SQL> select name from v$database;

NAME                                                                            
---------                                                                      
ORCL123                                                                        

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> spool off

set oracle_sid=company
sqlplus /nolog
SQL> conn / as sysdba
ERROR:
ORA-12560: TNS:protocol adapter error

Could you please help me why company database could not connect.
My oracle version is oracle 11g.
Thanks in advance

0
nobleit
Asked:
nobleit
  • 2
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
The windows service for the database isn't running.
0
 
nobleitAuthor Commented:
how to services in windows xp. could you help..?
0
 
slightwv (䄆 Netminder) Commented:
From control panel. I think under administrative tools.

I'm on mobile right now so I can't look it up for you.

If you still can't find it, Google should provide links on how to startup windows services.

The one you are looking for stars with Oracle and has the Sid, company, in it.
0
 
nobleitAuthor Commented:
everthing is working fine. I tried with services.msc
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now