Startup problem

[Database Administrator]

QDL wrote:
> [CUT]
> > Alternatively, if you change service_name= in sid= in
> > tnsnames.ora, which error do you get?
> [CUT]
>
> Get the same error, thanx.
>
> >
> > --
> > Sybrand Bakker
> > Senior Oracle DBA
> >

It is possible the listener service is starting *after* the database
service starts due, in part, to the service naming; you may want to set
both services to Manual and write a .bat file to start them in the
proper sequence using the 'net start' command syntax:

net start
net start

As an example the startdb.bat file would be (presuming your Oracle home
is named OracleXE_home):

net start OracleXE_homeTNSListener
net start OracleServiceXE

Doing this will start the listener first, then start the database,
which will allow the db to register with the listener. As it appears
your system is probably starting the OracleServiceXE first, then
starting the OracleXE_homeTNSListener, causing the database to not
register automatically, and this is why you can stop and restart the
database service and all works as expected.

You might also be able to put these commands into your autoexec.bat
file (usually found in the root directory of the C drive) so everything
will start automatically. (I'm presuming that is an option even with
the more recent releases of Windows.)



David Fitzjarrell

[Database Administrator]

"QDL" schreef in bericht
news:4559bd38$0$19240$4fafbaef@reader4.news.tin.it ...
> >
>> Does your server have a fixed IP address? (I hope so...)
>
> Thanx for answering, yes I have a fixed IP address... And I'm still
> clueless...
>
> Thanx
> Paolo
>
>
>

Didi you install application server BEFORE or AFTER XE ?

[Database Administrator]

"QDL" schreef in bericht
news:4559bd38$0$19240$4fafbaef@reader4.news.tin.it ...
> >
>> Does your server have a fixed IP address? (I hope so...)
>
> Thanx for answering, yes I have a fixed IP address... And I'm still
> clueless...
>
> Thanx
> Paolo
>
>
>

Didi you install application server BEFORE or AFTER XE ?

[Database Administrator]

"QDL" schreef in bericht
news:4559d149$0$3207$4fafbaef@reader2.news.tin.it. ..
>> Does the database actually open?
> I'm a *real* beginner with Oracle... How can I check this?
>
>> Did you examine the alert log?
> No... You mean the Windows log or Oracle's
>
>> There have been many cases in the past the service does start, but the
>> database didn't open, usually because there was a mismatch between the
>> SYS password and the password of the password file.
> I used the standard installer and I keyed in the password for SYS and
> SYSTEM there, so I guess this is not the problem. Also if I stop and
> restart the DB it works.
>
>> The database registers itself when it opens.
>> Alternatively, if you change service_name= in sid= in
>> tnsnames.ora, which error do you get?
> How can I retrieve the SID... I told you I'm a real beginner...
>
> I think this problem is about some other service starting very slow
> (Network?) and Oracle not being able to start propertly. As I told before,
> after booting if I stop and restart Oracle DB, it start working ok...
>
> I forgot to mention I have also Oracle Application Server installed on the
> same machine...
>
>> --
>> Sybrand Bakker
>> Senior Oracle DBA
>>
>
> Thanx again
> Paolo
>

Tried the same configuration, XE and IAS on same machine, and I get THE SAME
ERROR when I start SQLPLUS from the ias/bin directory,
which seems to be default if no path is specified.
Can you try to start sqlplus from the XE-bin directory (start a dos-box, cd
until you're there and start sqlplus)?

[Database Administrator]

"QDL" schreef in bericht
news:4559d149$0$3207$4fafbaef@reader2.news.tin.it. ..
>> Does the database actually open?
> I'm a *real* beginner with Oracle... How can I check this?
>
>> Did you examine the alert log?
> No... You mean the Windows log or Oracle's
>
>> There have been many cases in the past the service does start, but the
>> database didn't open, usually because there was a mismatch between the
>> SYS password and the password of the password file.
> I used the standard installer and I keyed in the password for SYS and
> SYSTEM there, so I guess this is not the problem. Also if I stop and
> restart the DB it works.
>
>> The database registers itself when it opens.
>> Alternatively, if you change service_name= in sid= in
>> tnsnames.ora, which error do you get?
> How can I retrieve the SID... I told you I'm a real beginner...
>
> I think this problem is about some other service starting very slow
> (Network?) and Oracle not being able to start propertly. As I told before,
> after booting if I stop and restart Oracle DB, it start working ok...
>
> I forgot to mention I have also Oracle Application Server installed on the
> same machine...
>
>> --
>> Sybrand Bakker
>> Senior Oracle DBA
>>
>
> Thanx again
> Paolo
>

Tried the same configuration, XE and IAS on same machine, and I get THE SAME
ERROR when I start SQLPLUS from the ias/bin directory,
which seems to be default if no path is specified.
Can you try to start sqlplus from the XE-bin directory (start a dos-box, cd
until you're there and start sqlplus)?

[Database Administrator]

RECALL PREVIOUS POST< DIFFERENT ERROR!!!!!!!!!! (ORA-12154)
"What's in a namespace" schreef in bericht
news:4559f4c5$0$322$e4fe514c@news.xs4all.nl...
>
> "QDL" schreef in bericht
> news:4559d149$0$3207$4fafbaef@reader2.news.tin.it. ..
>>> Does the database actually open?
>> I'm a *real* beginner with Oracle... How can I check this?
>>
>>> Did you examine the alert log?
>> No... You mean the Windows log or Oracle's
>>
>>> There have been many cases in the past the service does start, but the
>>> database didn't open, usually because there was a mismatch between the
>>> SYS password and the password of the password file.
>> I used the standard installer and I keyed in the password for SYS and
>> SYSTEM there, so I guess this is not the problem. Also if I stop and
>> restart the DB it works.
>>
>>> The database registers itself when it opens.
>>> Alternatively, if you change service_name= in sid= in
>>> tnsnames.ora, which error do you get?
>> How can I retrieve the SID... I told you I'm a real beginner...
>>
>> I think this problem is about some other service starting very slow
>> (Network?) and Oracle not being able to start propertly. As I told
>> before, after booting if I stop and restart Oracle DB, it start working
>> ok...
>>
>> I forgot to mention I have also Oracle Application Server installed on
>> the same machine...
>>
>>> --
>>> Sybrand Bakker
>>> Senior Oracle DBA
>>>
>>
>> Thanx again
>> Paolo
>>
>
> Tried the same configuration, XE and IAS on same machine, and I get THE
> SAME ERROR when I start SQLPLUS from the ias/bin directory,
> which seems to be default if no path is specified.
> Can you try to start sqlplus from the XE-bin directory (start a dos-box,
> cd until you're there and start sqlplus)?
>
>
>

[Database Administrator]

RECALL PREVIOUS POST< DIFFERENT ERROR!!!!!!!!!! (ORA-12154)
"What's in a namespace" schreef in bericht
news:4559f4c5$0$322$e4fe514c@news.xs4all.nl...
>
> "QDL" schreef in bericht
> news:4559d149$0$3207$4fafbaef@reader2.news.tin.it. ..
>>> Does the database actually open?
>> I'm a *real* beginner with Oracle... How can I check this?
>>
>>> Did you examine the alert log?
>> No... You mean the Windows log or Oracle's
>>
>>> There have been many cases in the past the service does start, but the
>>> database didn't open, usually because there was a mismatch between the
>>> SYS password and the password of the password file.
>> I used the standard installer and I keyed in the password for SYS and
>> SYSTEM there, so I guess this is not the problem. Also if I stop and
>> restart the DB it works.
>>
>>> The database registers itself when it opens.
>>> Alternatively, if you change service_name= in sid= in
>>> tnsnames.ora, which error do you get?
>> How can I retrieve the SID... I told you I'm a real beginner...
>>
>> I think this problem is about some other service starting very slow
>> (Network?) and Oracle not being able to start propertly. As I told
>> before, after booting if I stop and restart Oracle DB, it start working
>> ok...
>>
>> I forgot to mention I have also Oracle Application Server installed on
>> the same machine...
>>
>>> --
>>> Sybrand Bakker
>>> Senior Oracle DBA
>>>
>>
>> Thanx again
>> Paolo
>>
>
> Tried the same configuration, XE and IAS on same machine, and I get THE
> SAME ERROR when I start SQLPLUS from the ias/bin directory,
> which seems to be default if no path is specified.
> Can you try to start sqlplus from the XE-bin directory (start a dos-box,
> cd until you're there and start sqlplus)?
>
>
>

[Database Administrator]

>
> Didi you install application server BEFORE or AFTER XE ?

Installed Application Server after Express.

Thanx
Paolo

[Database Administrator]

>
> Didi you install application server BEFORE or AFTER XE ?

Installed Application Server after Express.

Thanx
Paolo

[Database Administrator]

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 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