Diane Joyner

How do I fix protocol adapter error in Sqlplus?

Articles

How do I fix protocol adapter error in Sqlplus?

How to Fix ORA-12560: TNS: Protocol Adapter Error

  1. Make sure the windows service is up and running.
  2. Make sure your ORACLE_SID is set to the instance name you’re trying to connect to. If either one or two are not correct you will get the error as seen below.

How do I remove SQL Plus from Windows 10?

To remove components on a Windows computer with Oracle Universal Installer:

  1. Ensure that you first follow the instructions in “Stopping Oracle Services on Windows”.
  2. Start Oracle Universal Installer.
  3. Click the Deinstall Products button.
  4. Select the Oracle home you wish to remove.
  5. Check the boxes of components to remove.

Where is the Tnsnames Ora file located?

ORACLE_HOME/network/admin directory
By default, the tnsnames. ora file is located in the ORACLE_HOME/network/admin directory.

How do I fix ORA 12560 TNS protocol adapter error?

Set the Oracle system ID (SID) to C:>set oracle_sid=ORCL. Next, run the Net Start command (C:>net start oracleserviceORCL). This should resolve the ORA-12560 error in this situation.

How do I fix TNS listener error?

First check the tnsnames. ora file and ensure that it points to the correct server and port. If the Forms server is on another machine, test the TNS resolve with tnsping from the command prompt. Finally, check the listener.

How do I uninstall Oracle SQL Developer in Windows 10?

To remove it from system do following:

  1. Delete base directory, where you unziped it (where you run it).
  2. Delete your user connection data – folder C:\Users\\AppData\Roaming\SQL developer.
  3. If you don’t have any other oracle software, delete your user configuration data – folder C:\Users\\Oracle.

How do I remove Oracle services from Windows 10?

Choose Start > Programs > Oracle – HOME_NAME > Database Administration > Database Configuration Assistant. Oracle Database Configuration Assistant starts. Select Delete a database and click Next. Follow the remaining windows to deinstall the Oracle8i database.

Where is Tnsnames Ora in Windows 10?

tnsnames. ora is located in the ORACLE_HOME\network\admin directory on Windows. Oracle home path is usually C:\app\oracle_account\product\12.1. 0\dbhome_1 in windows.

How do I find Tnsnames Ora in CMD?

Do the following:

  1. Log on to the host where the Oracle database resides.
  2. Change to the following directory: Solaris: Oracle_HOME/bin. Windows: Oracle_HOME\bin.
  3. To start the listener service, type the following command: Solaris: lsnrctl START. Windows: LSNRCTL.
  4. Repeat step 3 to verify that the TNS listener is running.

What is meant by TNS in Oracle?

Transparent Network Substrate (TNS), a proprietary Oracle computer-networking technology, supports homogeneous peer-to-peer connectivity on top of other networking technologies such as TCP/IP, SDP and named pipes. TNS operates mainly for connection to Oracle databases.

How do I install Oracle SQL Developer on Windows 10?

Step 1: Browse to this link.

  1. Step 2: Click on download.
  2. Step 3: Login in Oracle account or create a new account.
  3. Step 4: Extract the downloaded zip file.
  4. Step 5: Open your computer C drive & program files.
  5. Step 6: Open the folder.
  6. Step 7: Then open sqldeveloper folder.
  7. Step 8: Find the sqldeveloper exe file there.

How do you solve status failure failed IO error the network adapter could not establish the connection?

Restart it with the “lsnrctl start” command or on a Windows OS by starting the listener service. Ensure the correct hostname is specified in listner. ora. Add the hostname and IP address in the hosts file located under C:\Windows\System32\drivers\etc folder.

How do I completely uninstall Oracle?

How do I uninstall Oracle ODBC drivers?

Delete any key that starts with Oracle or ORCL. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE. Delete the ORACLE key. Delete the Oracle ODBC Driver key under HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.

Where is Tnsnames Ora on Windows 10?

By default, the tnsnames. ora file is located in the ORACLE_HOME/network/admin directory.

How do I connect to Oracle database in Windows?

To connect to Oracle Database from SQL Developer:

  1. Access the menu from which you can select SQL Developer:
  2. Select Oracle – ORACLE_HOME.
  3. Select Application Development.
  4. Select SQL Developer.
  5. In the navigation frame of the window, click Connections.
  6. In the Connections pane, click the icon New Connection.