8i - svrmgrl

[sweetleaf]

Hi,

I have personal 8i on my pc.

when i try to log in i get ORACLE NOT AVAILABLE.

When I open up cmd prompt and do the following:

>svrmgrl
>startup

I get Insufficient privileges (even if I connect / as sysdba)..

anyone know how i can start up my database?

thanks.

 

[SantaMufasa]

Sweet,

There are a couple of issues to look at on your PC:
1) Why is your Oracle instance not starting automatically on your PC (as it sounds like you want)?

2) Why are you not able to run "svrmgrl"?

So, let's deal with issue 1:
Check the "Startup Type" of your Oracle service:

Start..Settings..Control Panel..Administrative Tools (on some Windows versions)..Services: scroll down to service, "OracleService<SID>"; confirm that "Startup Type" is "Automatic". If it is not, then make it so.

Issue 2:
To run "svrmgrl", you must be a member of the Windows group, "ORA_DBA". To confirm your membership in that group (cliks may differ depending upon Windows version...Windows 2000 clicks are these:

Start..Settings..Control Panel..Users and Passwords. Under the "Users" tab, locate your Windows login name, then confirm that "ORA_DBA" is at least one of the groups of which you are a member. If you are not a member, then someone with "Administrator" privileges must add you to that group.

Once you are a member of the ORA_DBA group, you should be able to run "svrmgrl" without a password when you "connect internal" or "connect / as sysdba".

Let us know your findings.

Mufasa
(aka Dave of Sandy, Utah, USA @ 00:05 (20Oct04) UTC (aka "GMT" and "Zulu"), 17:05 (19Oct04) Mountain Time)

 

[sweetleaf]

Hi Mufasa,

Thanks.

1) the oracle services on my laptop are stuck on "starting" - odd i know

2) you're absolutely correct. i used "connect internal" and all is well.



Cheers,
Mark

 

[SantaMufasa]

Mark,

If the services are stuck on starting, then check your alert log in your "background_dump_dest" directory for any messages that account for the incomplete startup.

Mufasa
(aka Dave of Sandy, Utah, USA)
@ 04:46 (21Oct04) UTC (aka "GMT" and "Zulu"),
@ 21:46 (20Oct04) Mountain Time