But if …The cause of an ORA-12560 error is the occurrence of a generic protocol adapter mistake. In SQL Plus, if I connect with no login, and execute 'conn sys/ :port/sid as sysdba', connection is established successfully. Locate OracleService (here OracleServiceORCL) and click on Start to start the oracle database service (if not already running) Once it is up and running, from the command prompt run the following: tnsping ( tnsalias entry you can find it in tnsnames.ora file)see the commands here Listener and service are up and running. Nous rappelons que ce problème est survenu sur une machine de dépannage avec un système d'exploitation Windows serveur 2016 sur laquelle Oracle 11gR2.0.04 a été.Go to Start -> Run -> Services.msc in Windows. This meant I could use tnsnames.ora and simply use Driver= Dbq=tnsnames_entry Uid=username Pwd=password as the connection string.Il est possible de rencontrer ce message en pleine journée ou le matin à l'arrivé au bureau. ORA-12560: TNS:protocol adapter error Oracle 11gR2 on Window 7 (Home Basic)This problem was fixed by adding values for TNS_ADMIN and TNS_HOME as environment variables and HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE that point to the \NETWORK\ADMIN directory of the Oracle installation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |