sqlplus "/ as sysdba"

Hi Friends,

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

But in windows 2k ora 9i it runs too :confused:

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

Thanks a lot

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

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

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

I reinstall it and the same error :confused:

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

What is wrong with it

Quote:

---

Originally Posted by Thomasps

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

---

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

you havent once put the error you are receiving

not allowed as sysdba

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

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

then you arent in the right group or you have messed with your sqlnet.ora file

im in the dba group dear....but i dont have sqlnet.ora, what do I put
there? :confused: i thought its not needed