I'm trying to connect to the database and receiving "ORA-01031: insufficient privileges". Database version is 11.2.0.3 (standalone) on Linux.
[oracle@dbserv admin]$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0.3/db1
[oracle@dbserv admin]$
[oracle@dbserv admin]$ which sqlplus
/u01/app/oracle/product/11.2.0.3/db1/bin/sqlplus
[oracle@dbserv dbs]$ sqlplus sys/oracle@newdb as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 26 20:38:13 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
Password File has been created and is at $ORACLE_HOME/dbs location.
[oracle@dbserv dbs]$ pwd
/u01/app/oracle/product/11.2.0.3/db1/dbs
[oracle@dbserv dbs]$ ls -lrt *orapw*
-rw-r----- 1 oracle oinstall 1536 Aug 26 20:38 orapwnewdb
To be more clear, there is a GI version of 11.2.0.2 already installed along with 11.2.0.2 version of RDBMS on the same server (Standalone).
In addition to this, 11.2.0.3 has been installed on the same machine and a new listener has been created on 11.2.0.3 home for the databases residing on this home.
Here are the details:
[oracle@dbserv dbs]$ ps -ef | grep tns
oracle 4226 1 0 20:20 ? 00:00:00 /u01/app/oracle/product/11.2.0.2/grid/bin/tnslsnr LISTENER -inherit
oracle 4239 1 0 20:20 ? 00:00:00 /u01/app/oracle/product/11.2.0.3/db1/bin/tnslsnr LISTENER_NEWDB -inherit
oracle 4599 3734 0 20:44 pts/2 00:00:00 grep tns
[oracle@dbserv dbs]$ lsnrctl status LISTENER_NEWDB
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 26-AUG-2015 20:44:32
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=dbserv.mydomain)(PORT=1526)))
STATUS of the LISTENER
------------------------
Alias LISTENER_NEWDB
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 26-AUG-2015 20:20:11
Uptime 0 days 0 hr. 24 min. 21 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0.3/db1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/dbserv/listener_newdb/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dbserv.mydomain)(PORT=1526)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1526)))
Services Summary...
Service "NEWDB" has 1 instance(s).
Instance "NEWDB", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully