Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Errors: "Notice: Can't find home for Oracle SID <SIDname>" and "Error: 15001 - No such dat
설명
Post errors out with messages similar to the following:
Process launched: sp_opst (for oSID1-o.SID2 queue <queuename>) [pid = 5330] Notice: Can't find home for Oracle SID <SIDname> [sp_opst(pdb)/5330] Warning: `[sp_opst(pdb)/5330] Warning: Failed to set ORACLE_SID/ORACLE_HOME [sp_opst(pdb)/5330] Error: 15001 - No such database as "<SIDname>" in /etc/oratab [sp_opst/5330] Process exited sp_opst (for oSID1-o.SID2 queue <queuename>) [pid = 5330] - exit(1)
원인
1. Missing or incorrect entry for Oracle SID in /var/opt/oracle/oratab or /etc/oratab file (as applicable). 2. Missing entry for virtual TNS alias in oratab (in case of RAC only). 3. Incorrect SID specified in config file.
해결 방안
Shareplex looks for Oracle SID in /var/opt/oracle/oratab for Sun servers and in /etc/oratab file for other Unix servers.
1. For cause 1 and 2, edit the oratab file to correct the SID entry.
2. For cause 3:
- correct the SID in config file - shutdown Shareplex on source and target - run ora_cleansp on source and target - activate config on the corrected config file on source
