1ï¼ æ£æ¥Terminal Service,çè¿ç¨æ¡é¢æ¯ä¸æ¯èµ·å
2ï¼ æ£æ¥ç¯å¢åéORACLE_SIDæ¯å¦æ£ç¡®ï¼å
æ¬æ³¨å表ä¸ç设å®(æ£æ¥æ³¨å表HKEY_LOCAL_MACHINE\Software\Oracle\key_oracle
没æ oracle_sid=whoraè¿é¡¹å¼ï¼æè¿é¡¹å¼å¢å è¿å»éæ°è¿ï¼é®é¢å°±è§£å³äº)
3ï¼ æ£æ¥Oracleæå¡æ¯å¦å¯å¨
4ï¼ æ£æ¥LISTENER.ORA,TNSNAME.ORAççæºå¨å(IPå°å)æè
æå¡åæ¯å¦æ£ç¡®
5ï¼ Netstat âaæ£æ¥ç«¯å£æ¯å¦è¢«å ç¨
6ï¼ æ£æ¥æ³¨å表HKEY_LOCAL_MACHINE\Software\Oracle\Home0æ°å¢å符串USE_SHARED_SOCKET=TRUE, éæ°å¯å¨æå¡
对äºè¿è¡å¨Windowsä¸çOracle 8iè¿å¯è½æ¯å¦ä¸æ
åµï¼
1ï¼ å¨Serveræ¬æºæ§è¡SvrmgrlæSqlplusæ¶æ¥è¯¥é误ï¼æ¤æ¶éæ£æ¥ORACLE_SID设置æ¯å¦æ£ç¡®ï¼å
æ¬æ³¨å表ä¸ç设å®ï¼å¹¶æ£æ¥Serviceæ¯å¦è¿è¡
2ï¼ å¦æSID设置æ£ç¡®ä¸æå¡ä¹å·²ç»è¿è¡ï¼å¦æè¿æ¶è¿æ¥è¯¥é误ï¼ååºè¯¥æ£æ¥SID NAMEæ¯å¦å
å«äºéåæ¯å符ï¼å¯¹äºWindowsä¸çOracle
8iï¼SID NAMEä¸å
许å
å«éåæ¯å符ï¼æ¯å¦ä¸å线æ横线
3ï¼ å¦æåºç°é¡½åºæ§çORA-12560é误ï¼å¯èèèªå·±åORACLEå¯å¨åå
³éèæ¬ï¼å 为Windowsçoracle serviceèªå¨å¯å¨ä¸æ¯å¾å®å
å
¶ä»æ
åµè¦å
·ä½åæï¼æ¯å¦æå¯è½æ¯è¿æ¥æ°è¿å¤é æå
åæ¶èæ®å°½ï¼ä¹ä¼é æora-12560é误ã
åèææ¡£ï¼
Note 1070749.6,73399.1
Note 1016454.102 TNS 12560 DB CREATE VIA INSTALLATION OR CONFIGURATION ASSISTANT FAILS
Bug 948671 ORADIM SUCCSSFULLY CREATES AN UNUSABLE SID WITH NON-ALPHANUMERIC CHARACTER
Bug 892253 ORA-12560 CREATING DATABASE WITH DB CONFIGURATION ASSISTANT IF SID HAS NON-ALPHA
温馨提示:答案为网友推荐,仅供参考