ORA-12505: TNS:listener could not resolve SID given in connect descriptor
Posted on 2001-08-17
I encountered a problem with connecting to the Oracle databse. Here is the description of the problem.
Backgroud : I am using Win2K advance server and Oracle 8i Server. To avoid version conflict, i installed my Oracle 8i Server in OraHome01 and Oracle Enterprise Manager in OraHome02. By using 2 different oracle homes in the registry and 2 different physical path, i solve the conflict. Then, i did the following setting in the registry.
ORACLE - SIMPLIFIED CHINESE_CHINA.ZHS16GBK
ID0(OraHome81) - NA
ID1(OraHome80 if available) - American_America.WE8ISO8859P1 (have to, otherwise
cannot start the service, why?)
Home0(OraHome81) - SIMPLIFIED CHINESE_CHINA.ZHS16GBK
Home1(OraHome80 if available) - SIMPLIFIED CHINESE_CHINA.ZHS16GBK
I got the following above error message when trying to connect to the db using Oracle Enterprise Manager's SQLPlus which NLS setting default to American. ("ORA-12505: TNS:listener could not resolve SID given in connect descriptor") This problem is solved temporarily when i reconfigured the database using the Oracle8i's database configuration assistant. But once i restart my computer, the problem resume. I totally cannot connect to the database using Oracle 8i's SQLPlus and got the error message as "ORA-12514: TNS: *****(funny funny characters)****, *** SERVICE_NAME")
A little bit of the background when i did the Oracle 8i's installation. The machine that i did the installation is a new machine and hasn't got any network installation during the 8i installation. The Wireless LAN installation only done after the 8i's installation.
Can anybody help me to resolve the problem?