-
connect internal
Hi
I am using 9i database and I need to connect to the database in a script without the password. When I use connect internal, I am being prompted to enter password, can i login without password? Thanks!
-
RTFM!!!!!!!
internal doesnt exist in 9i
use sqlplus "/ as sysdba" if you want internal
-
Thanks! But I tried to login as sysdba in a script, i got the following error...
ERROR at line 1:
ORA-01034: ORACLE not available
My database is up and I have no problem connecting manually.
-
-
Thanks for all advices Will check the script again.
-
I've encountered an 'anomaly' in certain versions of 9i that manifests itself as such.......
----------------------------------------
connect sys@sid_name as sysdba
gives you an unexpected error
----------------------------------------
Try
At command prompt - SET ORACLE_SID=SID_NAME
Where SID_NAME is the instance identifier
Then SQLPLUS /NOLOG
Then CONNECT SYS AS SYSDBA
You never know, it might just work goddamit!!
-
[QUOTE]Originally posted by Horace
[B]I've encountered an 'anomaly' in certain versions of 9i that manifests itself as such.......
----------------------------------------
connect sys@sid_name as sysdba
gives you an unexpected error
----------------------------------------
What versions of oracle? what error?
-
Well... I think I know the anomaly
connect "sys@sid_name as sysdba" (within qoutes) may prevent you from facing it
There are three kinds of lies: Lies, damned lies, and benchmarks...
Unix is user friendly. It's just very particular about who it's friends are.
Oracle DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|