ora-12154和ora-12560

ora-12154和ora-12560 经常前后出现，我们经常在oracle8i中见到，这个一般是oracle的tnsnames.ora里的配置有问题，当然也不排除系统的问题，在oracle 8.1.7中，最好使用“服务名配置向导”来配置服务名，手工编写的经常有问题。

$ oerr ora 12154
12154, 00000, "TNS:could not resolve service name"
// *Cause: The service name specified is not defined correctly in the
// TNSNAMES.ORA file.
// *Action: Make the following checks and correct the error:
// - Verify that a TNSNAMES.ORA file exists and is in the proper
// place and accessible. See the operating system specific manual
// for details on the required name and location.
// - Check to see that the service name exists in one of the
// TNSNAMES.ORA files and add it if necessary.
// - Make sure there are no syntax errors anywhere in the file.
// Particularly look for unmatched parentheses or stray characters.
// Any error in a TNSNAMES.ORA file makes it unusable. See
// Chapter 4 in the SQL*Net V2 Administrator's Guide. If
// possible, regenerate the configuration files using the Oracle
// Network Manager.

$ oerr ora 12560
12560, 00000, "TNS:protocol adapter error"
// *Cause: A generic protocol adapter error occurred.
// *Action: Check addresses used for proper protocol specification. Before
// reporting this error, look at the error stack and check for lower level
// transport errors.For further details, turn on tracing and reexecute the
// operation. Turn off tracing when the operation is complete.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267897/viewspace-906233/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267897/viewspace-906233/