Home » RDBMS Server » Server Administration » SYS Permissions
icon9.gif  SYS Permissions [message #126742] Wed, 06 July 2005 07:55 Go to next message
SJDewar
Messages: 15
Registered: July 2005
Junior Member
Hi,

I have an Oracle8 database on a Windows2000 server. I can connect to the database as the SYS user using SqlPlus but when I type in the command: 'shutdown immediate' I get the message... unknown command beginning "shutdown i..." - rest of line ignored.

When I type in: 'show user' it displays the message... User is SYS.

I thought I should be able to shutdown the database.

I didn't setup the database and there is no support available, I'm also new to Oracle DB Admin.

Any ideas?

Thanks in advance,

S.
Re: SYS Permissions [message #126752 is a reply to message #126742] Wed, 06 July 2005 08:32 Go to previous messageGo to next message
Frank Naude
Messages: 4587
Registered: April 1998
Senior Member
You need to use svrmgrl instead of sqlplus for Oracle8:

svrmgr> connect internal
svrmgr> shutdown immediate
svrmgr> exit


Best regards.

Frank
Re: SYS Permissions [message #126766 is a reply to message #126752] Wed, 06 July 2005 09:30 Go to previous message
SJDewar
Messages: 15
Registered: July 2005
Junior Member
Thanks Frank, much appreciated.
Previous Topic: ORA-03113
Next Topic: Instance created
Goto Forum:
  


Current Time: Fri Jan 10 07:48:43 CST 2025