Unable to connect to database / ORA-12514, after switchover
i configured correctly static listeners, i can connect them. i didnt configured any tnsname. should i configure tnsnames too? how?
thanks
$ cat listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = KKRAC)
(GLOBAL_DBNAME = KKRAC_DGMGRL)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
)
)
*[oracle@kkrac1 admin]$ nmap kkrac1-vip*
Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2011-01-11 10:39 EET
Interesting ports on kkrac1-vip.kentkart.com.tr (10.0.40.110):
Not shown: 1675 closed ports
PORT STATE SERVICE
22/tcp open ssh
111/tcp open rpcbind
945/tcp open unknown
1521/tcp open oracle
2017/tcp open cypress-stat
*[oracle@kkrac1 admin]$ nmap kkrac2-vip*
Starting Nmap 4.11 ( http://www.insecure.org/nmap/ ) at 2011-01-11 10:39 EET
Interesting ports on kkrac2-vip.kentkart.com.tr (10.0.40.111):
Not shown: 1674 closed ports
PORT STATE SERVICE
22/tcp open ssh
111/tcp open rpcbind
942/tcp open unknown
1521/tcp open oracle
1522/tcp open rna-lm
2017/tcp open cypress-stat
DGMGRL> show configuration
Configuration - GUARDCONF
Protection Mode: MaxPerformance
Databases:
kkrac - Primary database
kkgrac - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> switchover to 'kkgrac';
Performing switchover NOW, please wait...
New primary database "kkgrac" is opening...
Operation requires shutdown of instance "kkrac1" on database "kkrac"
Shutting down instance "kkrac1"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "kkrac1" on database "kkrac"
Starting instance "kkrac1"...
Unable to connect to database_
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor_
Failed.
Warning: You are no longer connected to ORACLE.
Please complete the following steps to finish switchover:
start up instance "kkrac1" of database "kkrac"
DGMGRL> quit