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;


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

set oracle_sid=company
sqlplus /nolog
SQL> conn / as sysdba
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

Who is Participating?
slightwv (䄆 Netminder)Connect With a Mentor Commented:
The windows service for the database isn't running.
nobleitAuthor Commented:
how to services in windows xp. could you help..?
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.
nobleitAuthor Commented:
everthing is working fine. I tried with services.msc
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.

All Courses

From novice to tech pro — start learning today.