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
Printable View
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
Do you think the two commands above will differ in PATH? or HOME?Quote:
Originally Posted by Thomasps
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 :)