Oracle RAC的ORA-12545 Connect failed because target host or object does not exist問題
aix5.3系統上的oracle 10.2.0.3 RAC,連線資料庫的時候經常報如下錯誤:
ORA-12545: Connect failed because target host or object does not exist |
這個問題可以透過設定rac資料庫各個節點的local_listener引數來解決,有兩種方式:
[@more@]方式1
在RAC的每個節點上編輯$ORACLE_HOME/network/admin/tnsnames.ora,增加local_listener_rac= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST= ) |
在rac的任意一個節點上修改資料庫引數,設定local_listener為local_listener_rac
$ sqlplus / as sysdba SQL> alter system set local_listener='local_listener_rac' scope=spfile; |
重新啟動各個節點上的資料庫例項
方式2
也可以按照metallink上id為364855.1的文件使用如下方法修改在rac的每個節點上執行如下語句設定local_listener引數
sql>alter system set LOCAL_LISTENER="(ADDRESS=(PROTOCOL=TCP)(HOST= |
其中
instance_name對應當前節點的例項名,如rac1、rac2等,即每次只修改當前例項的引數
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22049049/viewspace-1029681/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-12545: Connect failed because target host or object does not existAIObject
- 記一次ORA-12545: Connect failed because target host or object does not existAIObject
- 【故障處理】ORA-12545: Connect failed because target hostAI
- ORA-12545 TNS: Host or Object Does not ExistObject
- 【Oracle】-【許可權-ORA-04043】- object does not existOracleObject
- Laravel Class env does not exist 問題排查Laravel
- ORA-04043: object DBA_DATA_FILES does not existObject
- ORA-24756: transaction does not exist問題解決
- RAC連線的問題ORA-12545
- RAC Connection Redirected To Wrong Host/IP ORA-12545
- RAC連線的問題ORA-12545(二)
- asmcmd does not exist in directoryASM
- ORACLE RAC中連線ScanIP報錯ORA-12545的問題解決Oracle
- ubuntu gedit出錯:Failed to connect to the session manager的問題UbuntuAISession
- RAC Connection Redirected To Wrong Host/IP ORA-12545 [ID 364855.1]
- javax.media does not existJava
- ORACLE 11G RAC 訪問SCANIP ORA-12545Oracle
- Hadoop的mapreduce出現問題,報錯The auxService:mapreduce_shuffle does not existHadoopUX
- git中出現”the requested upstream branch ‘origin/master‘ does not exist“問題的解決GitAST
- 解決Spark讀取Hive分割槽表出現Input path does not exist的問題SparkHive
- oracle for linux安裝報錯 file /home/oracle/.Xauthority does not existOracleLinux
- Property [title] does not exist on this collection instance
- Waring: /dev/centos/swap does not existdevCentOS
- PatchObject constructor:Input file does not existObjectStruct
- 【MySQL】Host is blocked because of many connection errorsMySqlBloCError
- Doris建立表報錯Failed to find enough host with storage medium問題解決AI
- PSQLexception: ERROR : type "signed" does not existSQLExceptionError
- SNMP TABLE ERROR : Requested table is empty or does not existError
- ORA-00942: table or view does not existView
- FAQ:Field DATABASE does not exist; see long textDatabase
- The specified JRE installation does not exist m2eclipse build Maven專案報錯的問題EclipseUIMaven
- 【Mysql】MySql Host is blocked because of many connection errors;MySqlBloCError
- 靜默安裝Oracle建庫時報Template General Purpose does not existOracle
- Oracle ORA - 01720 grant option does not exist for..報錯解決Oracle
- SSH Host key verification failedAI
- connect by 的排序問題排序
- because it is a JDK dynamic proxy that implements 問題JDK
- Oracle ADG Heartbeat failed to connect to standby故障案例OracleAI