DanBrother的部落格

Solving ORA-12545: Connect failed because target host or object does not exist for Shared Server Mode

-- Node1     (Reset dispatchers)
SQL> alter system set dispatchers='' scope=both sid='*';
SQL> alter system set dispatchers='(address=(protocol=TCP)(host=10.0.1.100))(disp=4)(con=500)(sess=2000)' scope=both sid='RACDB1';

SQL> alter system register;

SQL> sho parameter dispatchers

NAME                                 TYPE                 VALUE
------------------------------------ -------------------- ------------------------------
dispatchers                          string               (address=(protocol=tcp)(host=1
                                                          0.0.1.100))(disp=4)(con=500)(se
                                                          ss=2000)

-- Node2    (Reset dispatchers)
SQL> alter system set dispatchers='(address=(protocol=TCP)(host=10.0.1.101))(disp=4)(con=500)(sess=2000)' scope=both sid='RACDB2';

SQL> alter system register;

SQL> sho parameter dispatchers

NAME                                 TYPE                 VALUE
------------------------------------ -------------------- ------------------------------
dispatchers                          string               (address=(protocol=tcp)(host=1
                                                          0.0.1.101))(disp=4)(con=500)(se
                                                          ss=2000)


-- Restart RAC DB
svrctl stop database -d RACDB
svrctl start database -d RACDB

-- Checking Listener Service Status
lsnrctl service