在做oracle standby時,出現ORA-12557錯誤.

在做oracle standby時,出現ORA-12557錯誤.

 

1 確定你的環境變數,%ORACLE_HOME%\bin配置正確.

   windows: c:\> echo $ORACLE_HOME    檢視

2 確定你的$ORACLE_HOME\network\admin\listener.ora  是否監聽 你目前的instance.

    在$ORACLE_HOME\network\admin目錄下是否有sqlnet.ora檔案.

 

轉網上的解決方法:

ORA-12557的解決過程

ORA-12557:	TNS:protocol adapter not loadable
Cause:	On some platforms (such as OS/2) protocol adapters are loaded at run-time. If the shared library (or DLL) for the protocol adapter is missing or one of its supporting libraries is missing then this error is returned.
Action:	For further details, turn on tracing and reexecute the operation. The trace file will include the name of the shared library (or DLL) that could not be loaded.

1. Make sure the %ORACLE_HOME%/bin directory is in your PATH.
2. Make sure the protocol is typed/specified correctly in your
tnsnames.ora file or whatever source you're using to resolve service
names.
3. TCP is the default protocol and is installed by default. If
you're using something different (like SPX) make sure you installed the
protocol adapter.
4. Make sure TOAD is using the correct oracle home if you have
multiple homes installed