Connect As Sysdba Tns Protocol Adapter Error
Contents |
Last updated: April 22, 2016 - 4:40 am UTC Category: SQL*Plus – Version: 9.2.0 Latest Followup You Asked i'm running oracle on standalone computer at home.it connect as sysdba ora-12560 tns protocol adapter error used to work properly but from couple of days i'm getting error
Ora-12560 Tns Protocol Adapter Error Sqlplus
stating "ORA-12560: TNS:protocol adapter error " what should i do? please help.. (scott/tiger) and we said... sounds ora-12560 tns protocol adapter error sqlplus 11g like the database is not up. you probably restarted your machine and the instance is not set to autostart C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production
Ora-12560 Tns Protocol Adapter Error Windows Oracle 11g
on Thu Sep 6 15:43:55 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options C:\Documents and sql tns protocol adapter error Settings\tkyte>net stop oracleserviceora10gr1 The OracleServiceORA10GR1 service is stopping......... The OracleServiceORA10GR1 service was stopped successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:44:35 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: ERROR: ORA-12560: TNS:protocol adapter error SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus C:\Documents and Settings\tkyte>net start oracleserviceora10gr1 The OracleServiceORA10GR1 service is starting.......... The OracleServiceORA10GR1 service was started successfully. C:\Documents and Settings\tkyte>sqlplus scott/tiger SQL*Plus: Release 10.1.0.4.0 - Production on Thu Sep 6 15:45:12 2007 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production With the Partitioning, OLAP and Data Mining options scott%ORA10GR1> in the above ora10gr1 is my oracle sid, you can use control panel instead - control panel -> services -> look for the services starting with Oracle. Reviews Write a Review Another method September 10, 2007 - 3:15 am UTC Reviewer: Aranga
friend ORA-12560: TNS:protocol adapter error [message #575165] Sun, 20 January 2013 16:36 ganesh_gvn Messages: 33Registered: February 2012 Location: PUNE
Sqlplus Ora-12560 Tns Protocol Adapter Error Windows
Member Dear All, I have installed Oracle 11gR2 on Window
Tns Protocol Adapter Error 11g Client
7 (Home Basic). Now I am trying to access my database with named 'TEST', from tns adaptor error in oracle 11g cmd, but I am getting "TNS:protocol adapter error" Below is the error : ============================================================================================= Microsoft Windows [Version 6.1.7601] Copyright (c) 2009 Microsoft Corporation. All rights https://asktom.oracle.com/pls/asktom/f?p=100:11:0::NO::P11_QUESTION_ID:431775600346873836 reserved. C:\Users\Home>sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Mon Jan 21 03:59:55 2013 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-name: sys as sysdba Enter password: ERROR: ORA-12560: TNS:protocol adapter error Enter user-name: / as sysdba ERROR: ORA-12560: TNS:protocol adapter error ================================================================================================== When I start the service name 'OracleServiceTest', http://www.orafaq.com/forum/t/185824/ then I am not getting the error. But It won't allow me to 'startup' the database instead database get started with 'OracleServiceTest' service start. I am doing this as ADMINISTRATOR. I am not understanding where I am wrong. How this can be solved. Please suggest me. Thanks in advance. Ganesh [Updated on: Mon, 21 January 2013 13:51] by ModeratorReport message to a moderator Re: ORA-12560: TNS:protocol adapter error [message #575174 is a reply to message #575165] Sun, 20 January 2013 22:19 rishwinger Messages: 132Registered: November 2011 Senior Member Ganesh I hope you googled about this error and tried everything I am not sure this would work for you but I resolved this error by fixing my environment variables Edit environment variable tns_admin and point it to your tnsnames.ora file location Report message to a moderator Re: ORA-12560: TNS:protocol adapter error [message #57517
as sysdba If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register http://www.dbasupport.com/forums/showthread.php?35454-connect-as-sysdba link above to proceed. To start viewing messages, select the forum that you want https://scn.sap.com/thread/3220642 to visit from the selection below. Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 12 Thread: connect as sysdba Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-14-2003,11:37 PM #1 a128 tns protocol View Profile View Forum Posts Senior Member Join Date Apr 2001 Posts 257 connect as sysdba If I have two databases on the same server, how do I connect / as sysdba in SQL*Plus? ---------- C:\>set ORACLE_SID=SIL C:\>SQLPLUS /NOLOG SQL*Plus: Release 8.1.7.0.0 - Production on Mon Apr 14 20:34:24 2003 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL> CONNECT / AS SYSDBA ERROR: ORA-12560: TNSrotocol adapter error tns protocol adapter ---------- I know I can do CONNECT INTERNAL@SIL just fine but what's the equivalent in CONNECT / AS SYSDBA? Thanks, Reply With Quote 04-15-2003,12:03 AM #2 adewri View Profile View Forum Posts Visit Homepage Oracle Monk Join Date Nov 2002 Location New Delhi, INDIA Posts 1,796 Make sure your OracleSerciveSil is running before connecting... Amar "There is a difference between knowing the path and walking the path." Reply With Quote 04-15-2003,12:06 AM #3 a128 View Profile View Forum Posts Senior Member Join Date Apr 2001 Posts 257 I am sure the service is running because I can do CONNECT INTERNAL@SIL in SQL*Plus. Reply With Quote 04-15-2003,12:52 AM #4 akhadar View Profile View Forum Posts Advisor Join Date May 2001 Posts 736 If the user is created with external identification then he can't be granted with sysdba privileges.But if the user is created with password then he can connect as sysdba and can use '/'. SQL> create user ops$abc identified by abc; User created. SVRMGR> grant sysdba to ops$abc; Statement processed. SVRMGR> connect / as sysdba; Connected. SVRMGR> connect / ORA-01045: user OPS$abc lacks CREATE SESSION privilege; logon denied SVRMGR> connect internal Connected. SVRMGR> grant create session to ops$abc; Statemen
SAP on OracleWhere is this place located?All Places SAP on Oracle 14 Replies Latest reply: Aug 10, 2012 2:20 PM by Orkun Gedik Tweet Oracle Database connection error -- ORA-12560: TNS:protocol adapter error kunal kulkarni Aug 10, 2012 9:26 AM Currently Being Moderated Hi,I am unable to connect to Oracle 8i database getting the following errorCause:SAP system to be migrated from Windows 2000 NT to Windows 2003 Operating systemSAP Installatoin Version 4.6 C with Oracle Database 8.1.7 installed on New serverOffline database backup restored successfully using BR commands Error while connecting to the database on new serversqlplus /nologSQL*Plus: Release 8.1.7.0.0 - Production on Fri Aug 10 11:44:43 2012(c) Copyright 2000 Oracle Corporation. All rights reserved.SQL> conn /as sysdbaERROR:ORA-12560: TNS:protocol adapter errorSteps followed :Listener services checked and testedTNS files checked Environment variables checked TNS ping to SID possibleOraacle SID env setAttaching herewith the network filesThanks in advance Regards,Kunal Kulkarni tnsnames.ora.zip (465 bytes) sqlnet.ora.zip (320 bytes) listener.ora.zip (445 bytes) 12594Views Re: Oracle Database connection error -- ORA-12560: TNS:protocol adapter error Ratnajit Dey Aug 10, 2012 10:14 AM (in response to kunal kulkarni) Currently Being Moderated Can you please paste the output of the command set executed in the same login where you are trying to connect.RegardsRatnajit Alert Moderator Like (0) Re: Oracle Database connection error -- ORA-12560: TNS:protocol adapter error kunal kulkarni Aug 10, 2012 10:29 AM (in response to Ratnajit Dey) Currently Being Moderated Hi Ratanjit,Please find below the commands executedC:\Documents and Settings\d11adm.MUMSERVER>set oracle_sid=D11C:\Documents and Settings\d11adm.MUMSERVER>sqlplus /nologSQL*Plus: Release 8.1.7.0.0 - Pr