Startup problem

[Database Administrator]

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

[Database Administrator]

On Nov 14, 1:55 pm, "QDL" wrote:
> > 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

Does the database actually open? Did you examine the alert log?
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.
The database registers itself when it opens.
Alternatively, if you change service_name= in sid= in
tnsnames.ora, which error do you get?

--
Sybrand Bakker
Senior Oracle DBA

[Database Administrator]

On Nov 14, 1:55 pm, "QDL" wrote:
> > 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

Does the database actually open? Did you examine the alert log?
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.
The database registers itself when it opens.
Alternatively, if you change service_name= in sid= in
tnsnames.ora, which error do you get?

--
Sybrand Bakker
Senior Oracle DBA

[Database Administrator]

> 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

[Database Administrator]

> 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

[Database Administrator]

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

[Database Administrator]

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

[Database Administrator]

On Nov 14, 3:21 pm, "QDL" wrote:
> > 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 DBAThanx again
> Paolo



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.
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.
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)?

--
Sybrand Bakker
Senior Oracle DBA

[Database Administrator]

On Nov 14, 3:21 pm, "QDL" wrote:
> > 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 DBAThanx again
> Paolo



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.
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.
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)?

--
Sybrand Bakker
Senior Oracle DBA

[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