sqlplus "/ as sysdba"

[yxez]

Hi Friends,

OS = AIX 5L
Why does my > sqlplus "/ as sysdba" runs on 10g but will not in 9i

But in windows 2k ora 9i it runs too

How can i make it run please......

Thanks a lot

[pareshjavkar]

Hi,

$ ORACLE_SID=
$ export ORACLE_SID
$ sqlplus "/ as sysdba"

Try it.

Hard code ORACLE_SID in your oracle user profile and export in that profile itself.

Test if it has applied by

$ echo $ORACLE_SID

[Thomasps]

echo $ORACLE_HOME and $PATH see where it is pointing to.

[yxez]

thanks dear ....i try it later coz i reinstalled the DB.. it thought
i was a bug

[yxez]

I reinstall it and the same error

I cant run sqlplus "/ as sysdba"
But it will run> sqlplus "sys/sys as sysdba"

What is wrong with it

[yxez]

echo $ORACLE_HOME and $PATH see where it is pointing to.

Do you think the two commands above will differ in PATH? or HOME?

[davey23uk]

you havent once put the error you are receiving

[yxez]

not allowed as sysdba

[davey23uk]

thats not an oracle error, put a full copy and paste from your session showing eactly what you did and the error

[yxez]

hi davey...its the stubborn error ora-1031 : insufficient privilege