Re: Newbie seeking help on performance tuning - Oracle 7.3 Server, NT4, Dual PPro 180, 64Meg

Startup, shutdown and other dba commands are only available in servermanager as of 7.3. Enterprise managers' instance manager can also be used.

You need to connect as internal to startup/shutdown. It also sounds like the parameter file you want to use is not being found. You can specify exactly where to find it using STARTUP PFILE='path+filename' .

The default parameter file on NT machines is found in ORANT\DATABASE and must have a name of init<SID>.ora, where "<SID>" = the name of the database instance. The default SID for the default oracle database is ORCL which would make the startup parameter file initORCL.ora.

I have found you must be careful to specify the database instance you want to work with in SVRMGR (really any DBA tool) if you are running multiple instances.

-- 
Pete Beer
beer_at_foresight-sys.com

WPL <lao2_at_total.net> wrote in article <33772c55.1727053_at_news.total.net>...


> Thanks, people, for helping.

> 

> I have determined that my SGA is only 7Megs.  With the 20meg database,

> it's not enough.  I played with the instance manager and try to change

> the startup parameters, but oracle doesn't seem to like it.  Here is

> what I did.

> 

> I first tried to login sys or system as SYSDBA or SYSOPER, but

> according to instance manager i didn't have the right to

> shutdown/startup.  Some people have suggested to me to use INTERNAL to

> login.  It worked, for shutdown.  But when I tried to use instance

> manager to startup.. it complained about insufficient privilege again.

> I was able to startup the DB again, by either rebooting the system, or

> from SVRMGR using STARTUP command without any parameter.

> 

> Rebooting the computer did not change the running value, even if the

> startup value has been changed.  STARTUP command used the default

> parameters, therefore ignores the init.ora

> 

> thanks again!

>