Connect Error 12547
Contents |
ORA-12547: TNS:lostcontact Posted by daviewning ⋅ April 10, 2015 ⋅ 2 Comments ORA-15055: unable to connect to ASM instance and ORA-12547: TNS:lost fatal ni connect error 12170 tns-12535 contact After completed to installation of the Oracle RAC,
Fatal Ni Connect Error 12547 Connecting To (local=no)
I got following error when I try restart the database oracle@testdbnode1:>sqlplus "/as sysdba"
Fatal Ni Connect Error 12170 Firewall
SQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 2 14:17:02 2014 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle
Fatal Ni Connect Error 12637
instance. SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+TESTDBDATA1/testdb/spfilerac.ora' ORA-17503: ksfdopn:2 Failed to open file +TESTDBDATA1/testdb/spfilerac.ora ORA-12547: TNS:lost contact Check the alert log file, I found following errors TNS-12547: TNS:lost contact ns secondary err code: 12560 nt main err ns main err code: 12535 code: 517 TNS-00517: Lost contact nt secondary err code: 32 nt OS err code: 0 ERROR: Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oragi/app/grid/11.2.03/grid/bin/oracle)(ARGV0=oracle+ASM1_asmb_rac1)(ENVS='ORACLE_HOME=/oragi/app/grid/11.2.03/grid,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)) Errors in file /oragi/app/oracle/diag/rdbms/rac/rac1/trace/rac1_asmb_31756.trc: ORA-15055: unable to connect to ASM instance ORA-12547: TNS:lost contact Fatal NI connect error 12547, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/opt/rac/11.2.0/grid/bin/oracle)(ARGV0=oracle+ASM1_asmb_rac1)(ENVS='ORACLE_HOME=/opt/rac/11.2.0/grid,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)(CONNECT_DATA=(CID=(PROGRAM=oracle@rac1)(HOST=rac1)(USER=oracle)))) VERSION INFORMATION: TNS for Linux: Version 11.2.0.3.0 - Production Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.3.0 - Production Time: 03-Mar-2014 14:32:35 Tracing not turned on. Tns error struct: ns main err code: 12547 TNS-12547: TNS:lost contact ns secondary err code: 12560 nt main err code: 517 TNS-00517: Lost contact nt secondary err code: 32 nt OS err code: 0 ERROR:Failed to connect with connect string: (DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/oragi/app/grid/11.2.03/grid/bin/oracle)(ARGV0=oracle+ASM1_asmb_rac1)(ENVS='ORACLE_HOME=/oragi/app/grid/11.2.03/grid,ORACLE_SID=+ASM1')(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(enable=setuser)) Fri Mar 02 15:31:18 2014 Starting background process ASMB Fri Sep 02 13:31:18 2011 ASMB started with pid=
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup ora 12547 tns lost contact sqlplus Recovery Security Tuning PLSQL Oracle Applications Papers Administration ORA-HOWTO Web and Mobile ns secondary err code: 12560 SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last month ns secondary err code: 12606 Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All https://daviewning.wordpress.com/2015/04/10/ora-15055-unable-to-connect-to-asm-instance-and-ora-12547-tnslost-contact/ threads | Best last month | No question at this time DBA Top 10 1 M. Cadot 38800 2 F. Diaz 33800 3 J. Schnackenberg 19600 4 B. Vroman 16850 5 A. Kavsek 16650 6 T. Boles 15500 7 P. Wisse 14950 8 M. Hidayathullah ... 11700 9 A. Hudspith 8600 10 A. Khan 4900 About Advertise here Download PLATOThe free http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=35911 tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47776Total active users2124Act. users last 24h21Act. users last hour1Registered user hits last week553Registered user hits last month6861 Go up ORA-12547: TNS:lost contact Next thread: optimize SQL Prev thread: When To Use Shared Server Message Score Author Date hi, when i try to invoke sqlplus here is the err...... prasanna desai Feb 25, 2009, 08:57 Check your listener.log file. If it is too big (2G...... Johan Lorier Feb 25, 2009, 09:14 Check the /etc/hosts file. 127.0.0.1 localho...... Aamir Mughal Feb 25, 2009, 09:54 Hi, Check the /etc/hosts file and see if you ha...... ♔Roberto Queiróz♔ Feb 25, 2009, 13:18 Hi Prasanna, Kindly check the size of the liste...... Sanjay Kosale Feb 25, 2009, 23:26 yeah,i checked out and the i wanted to use is ther...... prasanna desai Feb 26, 2009, 07:03 Follow up by mail Click here Subject: ORA-12547: TNS:lost contact Author: prasanna desai, India Date: Feb 25, 2009, 08:57, 2778 days ago Os info: RHEL 4 Oracle info: ORACLE
SAP on OracleWhere is this place located?All Places SAP on Oracle 5 Replies Latest reply: May 12, 2014 https://scn.sap.com/thread/1531466 9:40 AM by Brian Pinch Tweet TNS-12547: TNS:lost contact https://community.oracle.com/thread/2614609 S M Nov 14, 2009 5:28 PM Currently Being Moderated HiWhen I tried to login to sqlplus prompt, I am not able to login, I get the below error kdqasap2:orakgq 2> sqlplus "/as sysdba" SQL*Plus: Release 9.2.0.4.0 connect error - Production on Sat Nov 14 11:14:57 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. ERROR: ORA-12547: TNS:lost contact Enter user-name: I checked the listener and tnsnames.ora file kdqasap2:orakgq 68> cat listener.ora################Filename......: listener.oraCreated.......: created by SAP AG, R/3 Rel. >= 4.0AName..........:Date..........:################LISTENER = (ADDRESS_LIST = (ADDRESS= fatal ni connect (PROTOCOL=IPC) (KEY= KGQ.WORLD) ) (ADDRESS= (PROTOCOL=IPC) (KEY= KGQ) ) (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = kdqasap2) (PORT = 1527) ) )STARTUP_WAIT_TIME_LISTENER = 0CONNECT_TIMEOUT_LISTENER = 10TRACE_LEVEL_LISTENER = OFFSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SDU = 32768) (SID_NAME = KGQ) (ORACLE_HOME = /oracle/KGQ/920_64) ) )kdqasap2:orakgq 69>TNSkdqasap2:orakgq 70> cat tnsnames.ora################Filename......: tnsnames.oraCreated.......: created by SAP AG, R/3 Rel. >= 4.0AName..........:Date..........:################KGQ.WORLD= (DESCRIPTION = (SDU = 32768) (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = kdqasap2) (PORT = 1527) ) ) (CONNECT_DATA = (SID = KGQ) (GLOBAL_NAME = KGQ.WORLD) ) )kdqasap2:orakgq 71>kdqasap2:orakgq 71> cat sqlnet.ora################Filename......: sqlnet.oraCreated.......: created by SAP AG, R/3 Rel. >= 4.0AName..........:Date..........:################AUTOMATIC_IPC = ONTRACE_LEVEL_CLIENT = OFFSQLNET.EXPIRE_TIME = 0NAMES.DEFAULT_DOMAIN = WORLDNAME.DEFAULT_ZONE = WORLDkdqasap2:orakgq 72>kdqasap2:orakgq 72> cat protocol.oratcp.nodelay = truekdqasap2:orakgq 73>But the sqlnet.log files gives the below error***********************************************************************Fatal NI connect error 12547, connecting to: (DESCRIPTION=(ADDRESS
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 6 Replies Latest reply on Dec 27, 2013 9:00 AM by adi_071 Fatal NI connect error 12547/12170 adi_071 Dec 19, 2013 2:17 PM Hi,I am stakk with connection problem on customer Oracle server. Oracle database is installed on Microsoft Windows Server 2012 Standard. Version of Oracle DB is 11.2.0.4 Standard One Edition.Oracle database works fine on server. I had no problems/errors while installing (as admin). My user is memer of Local Admin Group. I am also able to connect to it with sqlplus (sqlplus username/password@tns_alias) and SQL Developer.Content of tnsnames, listener og sqlnet files are following:tnsnames.oraORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) )SALES = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.9)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sales.company.se)))listener.oraSID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1) (PROGRAM = extproc) (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll") ) )LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = servername.company.se)(PORT = 1521)) (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))))ADR_BASE_LISTENER = D:\oracleINBOUND_CONNECTION_TIMEOUT_LISTENER=180sqlnet.oraSQLNET.AUTHENTICATION_SERVICES= (NONE)SQLNET.INBOUND_CONNECT_TIMEOUT = 180ADR_BASE = D:\oracle\product\11.2.0\dbhome_1\logI am using VPN tunnel to connect to database from my client. I can ping server successfully. TNSPING to database works fine, but I am not able to connect to database. I get an error on client:ORA-12537 connection closed error.Alert log content is following:***********************************************************************Fatal NI connect error 12547, connecting to: (LOCAL=NO) VERSION INFORMATION:TNS for 64-bit Windows: Version 11.2.0.4.0 - ProductionOracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0