The following are common Oracle database connection errors; many of these are caused by typographical errors during initial installation or a problem in the Oracle connection. For more information on Oracle errors, please see the Oracle documentation.
Error Messages
ORA-12154: "TNS:could not resolve service name"
ORA-12198: "TNS:could not find path to destination"
ORA-12203: "TNS:unable to connect destination"
ORA-12224: "TNS:no listener"
ORA-12571: "TNS:packet writer failure"
Solutions
You can do the following to try to resolve these errors:
-
Check that you can connect to the database server and the data database using the following Oracle utilities:
-
tnsping <service name>
-
sqlplus =<data database user>/<password>@<service name>
Replace the strings in italics with the appropriate information for your database.
-
-
Use the Oracle Net Configuration Assistant utility to check and test the <service name>. For more information, see the Oracle documentation.
-
Recycle your Internet Information Services (IIS) application pools on the SmartPlant Foundation application server. If the Oracle server has been recently rebooted, or if the instance used by SmartPlant Foundation has been restarted, IIS connections to the instance need to be reset.