AW: connect as sysdba (sqlplus)

AW: connect as sysdba (sqlplus)

 

  

Gloria,

have you set up your password file for remote administration? You will be
needing it when trying to "connect your_name/[Email Address Removed] as
sysdba". Another likely reason could be an outdated client (i.e. 8.0.x).

hth,

gerald

-----Ursprüngliche Nachricht-----
Von: Day Gloria
[mailto:oracledba-ezmlmshield-x86918952.[Email address protected]
Gesendet: Friday, January 28, 2005 6:14 PM
An: LazyDBA Discussion
Betreff: RE: connect as sysdba (sqlplus)


One thing I have noticed is that when we log on as user sys(on the server)
not the sqlplus worksheet we do not have that error message.
Here is what happens:

oracle> sqlplus

SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jan 28 09:19:12 2005

(c) Copyright 2000 Oracle Corporation. All rights reserved.
Enter user-name: sys
Enter password:

Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production
With the Partitioning option
JServer Release 8.1.7.0.0 - 64bit Production

SQL> show user
USER is "SYS"
SQL> connect sys as sysdba
Enter password:
Connected.

-----Original Message-----
From: Stroh Kathleen (DTI)
[mailto:oracledba-ezmlmshield-x64405551.[Email address protected]
Sent: Friday, January 28, 2005 11:56 AM
To: LazyDBA Discussion
Subject: RE: connect as sysdba (sqlplus)


This is very likely due to incorrect password for sys.

Kathy Stroh

-----Original Message-----
From: Day Gloria
[mailto:oracledba-ezmlmshield-x21395491.[Email address protected]
Sent: Friday, January 28, 2005 11:55 AM
To: LazyDBA Discussion
Subject: connect as sysdba (sqlplus)

Hello everybody,

when connecting as Sysdba (Oracle 8.1.7) I get the following error:

Connect sys/****@ptst AS SYSDBA

ERROR:
ORA-01031: insufficient privileges


Thanks for your help,

Gloria


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page