I don't think this is your problem, but I recently had a similar problem
where I could connect locally [ connect system/pass as sysdba ] but the
application I was configuring required using the connect string [
connect system/[Email Address Removed] as sysdba ].
I had to create a password file [using orapw] and grant sysdba to
system.
| 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: tpepling
[mailto:oracledba-ezmlmshield-x81497283.[Email address protected]
Sent: Tuesday, September 14, 2004 6:32 AM
To: LazyDBA Discussion
Subject: RE: Connecting to database- 2 sec question!
In case no one replied:
From OS-command prompt:
sqlplus 'scott/[Email Address Removed] as sysdba'
or
sqlplus '/ as sysdba'
From SQL*Plus:
conn / as sysdba
or
conn scott/[Email Address Removed] as sysdba
-----Original Message-----
From: Malik Rafia
[mailto:oracledba-ezmlmshield-x20101813.[Email address protected]
Sent: Tuesday, September 14, 2004 5:29 AM
To: LazyDBA Discussion
Subject: Connecting to database- 2 sec question!
Hi guys,
I am having trouble connecting to my database using
SQL> conn sys/'passwd'@instance as sysdba
ERROR:
ORA-01301: insufficient privileges
I can issue conn / as sysdba fine, and that is what I have always
used...it's just an oracle patch needs to be run with the connect
string.
I can issue: conn sys/'passwd' as sysdba fine
Help! I'm sure this a 2 sec thing for a guru out there.
--------
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
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any
review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete the material from any
computer.
--------
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