Why I am getting this error: ORA-01031
Our database is on hp_ux.
If I do setenv ORACLE_SID mydb
then
sqlplus sys/passwd as sysdba will let me connected
but
sqlplus sys/passwd@mydb as sysdba
will get ORA-01031
Similarly, if I run: rman target sys/passwd@mydb, I will get ORA-01031
but if I run: rman target sys/passwd, I will connect to the db (ORACLE_SID is set).
On host2, also hpux, I can run tnsping mydb to find the db on host1, but when I setenv ORACLE_SID mydb
and then sqlplus sys/passwd@mydb as sysdba, I get ORA-01031,
however if I run: sqlplus sys/passwd as sysdba, I got a connection to an idle instance, aparently not the mydb on host2, which is running.
then
sqlplus sys/passwd as sysdba will let me connected
but
sqlplus sys/passwd@mydb as sysdba
will get ORA-01031
Similarly, if I run: rman target sys/passwd@mydb, I will get ORA-01031
but if I run: rman target sys/passwd, I will connect to the db (ORACLE_SID is set).
On host2, also hpux, I can run tnsping mydb to find the db on host1, but when I setenv ORACLE_SID mydb
and then sqlplus sys/passwd@mydb as sysdba, I get ORA-01031,
however if I run: sqlplus sys/passwd as sysdba, I got a connection to an idle instance, aparently not the mydb on host2, which is running.
0