RE: connect as sysdba (sqlplus)

RE: connect as sysdba (sqlplus)

 

  

Henry,

It worked! Thank you very much,

Gloria

-----Original Message-----
From: henry Wollman
[mailto:oracledba-ezmlmshield-x56256270.[Email address protected]
Sent: Friday, January 28, 2005 12:27 PM
To: LazyDBA Discussion
Subject: RE: connect as sysdba (sqlplus)


It may be a remote login issue. When you login locally (on the server) it is
not an issue. But if you login from a remote server, then you may need a
password file.

add this line to your init.ora
remote_login_passwordfile = exclusive

then create a password file using the command:
orapwd file=orapw password=sys's_password entries=20

Then in sqlplus, grant sysdba to 'user'
where user is any user other than sys that you want to be able to logon as
sysdba remotely.

I must add though, that in spite of having all this set up and working in
other areas, if I try to login as sysdba from my appstier, I still get
insufficient privileges.


| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________
-----Original Message-----
From: Day Gloria
[mailto:oracledba-ezmlmshield-x86918952.[Email address protected]
Sent: Friday, January 28, 2005 11:14 AM
To: LazyDBA Discussion
Subject: 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



--------
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