Re: Startup problem

From: QDL <qdl_at_qdl.qdl>
Date: Wed, 15 Nov 2006 08:50:11 +0100
Message-ID: <455ac719$0$3204$4fafbaef@reader2.news.tin.it>

Hello,

> 1 I meant the alert log of Oracle, probably something like alert_xe.log
> If this is a default install, it should be in the directory
> %ORACLE_HOME%\database.
> There should be a file called oradim.log in the same directory. This
> tracks down service problems.

In oradim.log there is one error for every startup: ORA-12560: TNS: error in protocol adapter

> 2 Oracle is implemented as a service. You have a service called
> OracleService<SID> on your system. SID can be anything, but for Oracle
> Express it is always XE.

Ok, thanks

> 3 If you fire up a DOS box, and issuse
> set ORACLE_SID=XE
> sqlplus /nolog
> connect / as sysdba
> what happens (right after rebooting, that is)?
The same error...

Thanx for your support, I learnt a lot of things on Oracle structure Paolo Received on Wed Nov 15 2006 - 01:50:11 CST