Tuesday, March 22, 2011

ora-12154 error while patchup

a quick glance on the same error i have mentioned in my earlier post
ora-12154: tns could not resolve the connect identifier specifier .
This can also be caused when you are adding a patchset to a earlier version . once the patch is applied( you need to stop all the services before proceding with the patch apply) . you need to upgrade the databases that are present in the previous versions . be cautious to take database backup before you try to upgrade (the database backup can be done while you can upgrade the database by enabling the database backup option) . after upgrade start the DBconsole and listerner and try to login into database using dba privilages to start the database ........ :)

if still the error existing check your listener.ora and tnsnames.ora files . please follow the requried documents from OTN for upgrading a database

No comments:

Post a Comment