ORA-12514 with Real Application Cluster
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: ORA-12514 with Real Application Cluster

  1. #1
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Question ORA-12514 with Real Application Cluster

    Hi All,
    I have RAC with 2 nodes which are Oracle 10.2.0.3 on Linux Servers.

    As soon as I reboot one of the instances, I am not able to connect to the database any more and getting error message:

    "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"

    Code:
    RACTEST =
    	(DESCRIPTION =
    		(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.7)(PORT = 1521))
    		(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.40.9)(PORT = 1521))
    		(LOAD_BALANCE = yes)
    		(CONNECT_DATA =
    		(SERVER = DEDICATED)
    		(SERVICE_NAME = orcltest)
    		(FAILOVER_MODE =
    			(TYPE = SELECT)
    			(METHOD = BASIC)
    			(RETRIES = 180)
    			(DELAY = 5)
    		)
    	)
    )
    Please advice,
    Best wishes!
    Dmitri

  2. #2
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340

  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Question

    Thank you for your reply. I treid to restart listener as well, but it did no make any change - only Linux Cluster restart helps to solve the problem - but this can't be a solution. I think that after a instance reboot something start to go wrong ... but in the same time after reboot instance get registered in the listener.
    Best wishes!
    Dmitri

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You need to check your listener.ora file on both the nodes.

    Also check with

    lsnrctl serv

    both nodes should know of the services that are running on each other.

    when the instance comes up they should register itself with the listener this is by default if you use the port 1521 or you should use the local_listener and remote_listener parameter in spfile.

    check this
    http://tardate.blogspot.com/2007/06/...u-run-rac.html

    the ip adresses on the client side 192.168.40.7 should be vip

    regards
    Hrishy
    Last edited by hrishy; 03-11-2008 at 09:13 AM.

  5. #5
    Join Date
    Aug 2007
    Location
    Cyberjaya,kuala lumpur
    Posts
    340
    did u check the networks.The servers are pinging or not ?

  6. #6
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Question

    Thank you for your reply. Please see attached output.
    I am not sure, but I think, SERVICE_NAME = orcltest did not get registered after instance reboot.
    Attached Files Attached Files
    Best wishes!
    Dmitri

  7. #7
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Question

    Quote Originally Posted by hrishy
    Hi

    ................

    check this
    http://tardate.blogspot.com/2007/06/...u-run-rac.html

    the ip adresses on the client side 192.168.40.7 should be vip

    regards
    Hrishy
    Yes, it is VIP, I'll check the article ...
    Best wishes!
    Dmitri

  8. #8
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    How did you create the service.
    Whats the status of the service as reported by the clusterware

    Code:
    srvctl status service -d ORCL -s orcltst
    if the service is not started start it

    Code:
    srvctl start service -d orcl -s RAC
    regards
    Hrishy
    Last edited by hrishy; 03-11-2008 at 09:49 AM.

  9. #9
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684

    Smile

    Thank you Hrishy!
    It did the trick.
    Best wishes!
    Dmitri

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width