Solution to Oracle 10g RAC connection error ORA-12545

ORA-12545 Errors often occur when a remote client connects to the RAC database over a uniform service name. SQL code SQL> CONN NDMAIN @ nuagerac enter the password ****** connected. SQL> CONN NDMAIN @ nuagerac enter password: ***** ERROR: ORA-12545: connection failure warning because the target host or object does not exist: you no longer connect to ORACLE. SQL> CONN NDMAIN @ nuagerac enter the password ***** connected. SQL> CONN NDMAIN @ nuagerac enter the password ***** connected. SQL> CONN NDMAIN @ nuagerac enter password: ***** ERROR: ORA-12545: connection failure warning because the target host or object does not exist: you no longer connect to ORACLE. Configuration of the local database TNSNAMES: Tnsnames code nuagerac = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.127) (PORT = 1521) (ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.128) (PORT = 1521) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = nuagerac) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5) Oracle in the document Note: 364855.1: RAC Connection Redirected Wrong Host/IP ORA-12545 is described accordingly. Solution: Modify the database initialization parameter LOCAL_LISTENER: SQL code SQL> CONN SYS @ nuage1 AS SYSDBA and enter the password ***** connected. SQL> ALTER SYSTEM SET LOCAL_LISTENER = '(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.127) (PORT = 1521)' SID = 'nuage1 '; the SYSTEM has changed. SQL> CONN SYS @ nuage2 AS SYSDBA enter the password ***** connected. SQL> ALTER SYSTEM SET LOCAL_LISTENER = '(ADDRESS = (PROTOCOL = TCP) (HOST = 192.168.1.128) (PORT = 1521)' SID = 'nuage2'; the SYSTEM has changed. After setting, try to connect to the database again: SQL code SQL> CONN NDMAIN @ nuagerac enter the password: ****** connected. SQL> CONN NDMAIN @ nuagerac enter the password ***** connected. SQL> CONN NDMAIN @ nuagerac enter the password ***** connected. SQL> CONN NDMAIN @ nuagerac enter the password ***** connected. SQL> CONN NDMAIN @ nuagerac enter the password ***** connected. SQL> CONN NDMAIN @ nuagerac enter the password ***** connected. SQL> CONN NDMAIN @ nuagerac enter the password ***** connected. SQL> CONN NDMAIN @ nuagerac enter the password ***** connected. After the modification, so far there is no error message for the ORA-12545, But Oracle does not think this is a bug, just think it is PROBLEM. Author pengranxiang