ORA-12154 : "TNS:could not resolve service name"
Cause : oracle Net Services cannot locate the connect descriptor specified in the tnsnames.ora configuration .
>> verify the tnsnames.ora files exists and that accessible .
>>verify that tnsnames.ora file in the location by the TNS_ADMIN environment variable.
ORA-12198: "TNS: could not find path to destination "
ORA-12203: "TNS: unable to connect the destination "
>> verify that you have correctly enter the service name of the database that you want to connect.
>> verify that service name address ADDRESS parameter in the connect descriptor of your tnsname.ora file are correct .
>> verify that you tnsname.ora file stored in the directory defined in the TNS_ADMIN environment Variable
Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav
Cause : oracle Net Services cannot locate the connect descriptor specified in the tnsnames.ora configuration .
>> verify the tnsnames.ora files exists and that accessible .
>>verify that tnsnames.ora file in the location by the TNS_ADMIN environment variable.
ORA-12198: "TNS: could not find path to destination "
ORA-12203: "TNS: unable to connect the destination "
>> verify that you have correctly enter the service name of the database that you want to connect.
>> verify that service name address ADDRESS parameter in the connect descriptor of your tnsname.ora file are correct .
>> verify that you tnsname.ora file stored in the directory defined in the TNS_ADMIN environment Variable
Looking forward for your suggestions.. please feel free to write to me.. Your help would definitely help to improve our blog. Chetan Yadav
No comments:
Post a Comment