Rebooting windows after ORACLE installation

[Eitan Mizrahi]

Hello,

I have a question about Oracle-Server installation.

I log on to the database via sql-plus at the first time (before rebooting).

After rebooting and launching sql-plus, and log on, I get some errors :

ERROR: ORA-01034: ORACLE not available

ORA-27101: shared memory realm does not exist

In the sqlnet.log file I get a message :

TNS-12640 Authentication adapter initialization failed.

I do:

svrmgrl

connect internal

shutdown abort

startup

... and I can log on via sql-plus properly,

but I need to do so after each reboot of windows-2000 system (and still, the
log file has a new tns-12640 error).

What may be the problem , and how to solve it (oracle 8.1.7) ?

Thanks :o)

[John Pierce]

Eitan Mizrahi wrote:

At a guess, your Oracle services are not configured for automatic startup.

John Pierce

[De...@mabex.co.yu_no_spam_]

find in oracle cilent directory (version ?) net80/admin dir and file
tnslister. I think u don't configure properly ora client.

"Eitan Mizrahi" <eit...@e-ntouch.com> wrote in message
news:3b389820_2@dnews...

[Peter Laursen]

Eitan Mizrahi skrev i meddelelsen <3b389820_2@dnews>...

>
>ERROR: ORA-01034: ORACLE not available
>
>ORA-27101: shared memory realm does not exist
>
>In the sqlnet.log file I get a message :
>
>TNS-12640 Authentication adapter initialization failed.
>

Hi Eitan,

Check that the registry key ORA_sid_AUTOSTART is enabled.
Check that the startmode of the service is set to automatic.
Just setting the startmode of the service, either by
oradim -edit or in the control might not solve your problem.

Deleting the service and recreating it solved it for me.
Someting like (from memory):
Stop service
oradim -delete -sid <sid>
oradim -new -sid <sid> -startmode auto -pfile <full path>

Try to set authentication_services = (none) in your
sqlnet.ora

Peter Laursen