connect internal

[mooks]

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!

[davey23uk]

RTFM!!!!!!!

internal doesnt exist in 9i

use sqlplus "/ as sysdba" if you want internal

[mooks]

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.

[adewri]

Originally posted by mooks
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.

Check your environment variables, are you setting them in the script.

Check your connect string, which home are you picking your connect string from.

Try running sqlplus and try connecting and see are you connecting to the correct database.

Is the correct database up.

[mooks]

Thanks for all advices Will check the script again.

[Horace]

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

[bazza]

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

[simply_dba]

Well... I think I know the anomaly

connect "sys@sid_name as sysdba" (within qoutes) may prevent you from facing it