Home » RDBMS Server » Server Administration » sys : insufficient privileges
sys : insufficient privileges [message #60579] Tue, 17 February 2004 09:30 Go to next message
Susan
Messages: 102
Registered: October 2001
Senior Member
hello

i am trying to connect thru sqlplus to database as sys but giving insufficient privilege
sys/password@connectstring
i am using same software different copy oralce(same version) in different system but i am able to connect thru that db ordinary user i given sysdba to that user again trying thru my machine its giving insufficient priviliges bit curious.The thing i am using same version of oracle
but same software with different copy in different host. host string is correct pls hlp whether we need connect as sys to use full funtioning in OEM
pls help
susan

Report message to a moderator

Re: sys : insufficient privileges [message #60595 is a reply to message #60579] Wed, 18 February 2004 09:47 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
On the server where the DB is which you can't connect as SYS to, create a password file or try granting SYSDBA to SYS.

Search for "orapdw"

Report message to a moderator

Previous Topic: alter table table_name MOVE TABLESPACE tbs_name
Next Topic: Clone Database requires recovery
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:24:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.