Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to connect to database / ORA-12514, after switchover

donniedarkoJan 11 2011 — edited Mar 28 2011
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2011
Added on Jan 11 2011
3 comments
589 views