ORA-12560: TNS: protocol adapter error

DBA Geral (instalação, configuração do banco, scripts do Sql*Plus, shell scripts, batch scripts, etc...)
Post Reply
stohlirck
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 15
Joined: Tue, 09 Oct 2007 10:37 am
Location: Porto Alegre - RS
Tiago Stöhlirck

Personal,
several times I have come across this error in Windows when you try to start a database:
ORA-12560: TNS: Protocol Adapter Error
MS-DOS ..
Set Oracle_HOME = C: \ Oracle \ Product \ 10.2.0 \ dB_1
Set Oracle_SID = DBR
CD% Oracle_Home% \ bin
SQLPLUS / SYSDBA

Error:
ORA-12560: TNS: Protocol Adapter Error

What can be happening ??
Is there any step?

Environment information:
* Oracle version: Oracle Database 10g R2
* Operating System: Windows XP Professional Service Pack 2
Zion WG
Rank: Estagiário Sênior
Rank: Estagiário Sênior
Posts: 10
Joined: Wed, 15 Aug 2007 7:28 pm
Location: São Paulo

STOHLIRCK,

Have you ever been able to open this database before? How was it installed?

The service generated by the Oradim was executed?

Hugs!
Zion WG
stohlirck
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 15
Joined: Tue, 09 Oct 2007 10:37 am
Location: Porto Alegre - RS
Tiago Stöhlirck

It was created with DBCA, I already opened it several times.
If I go through the Windows services and start listener and OracleService .. it works normally, but what I want is to put it in the air by the command prompt.
stohlirck
Rank: Programador Júnior
Rank: Programador Júnior
Posts: 15
Joined: Tue, 09 Oct 2007 10:37 am
Location: Porto Alegre - RS
Tiago Stöhlirck

Guys, I found the answer.

follows the link: http://boomslaang.wordpress.com/2008/05/02/24/
Hugs
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest