TNS-12547: TNS: Lost contact problem solution!

Source: Internet
Author: User

The just-installed RAC one node suddenly fails to connect to the database.

Check the CRS status:

[Grid @ Linux ~] $ Srvctl status database-D orcl
Database is not running.
[Grid @ Linux ~] $ Crs_stat-T
Name type target State host
------------------------------------------------------------
Ora. data1.dg ora... Up. type online Linux
Ora... er. lsnr ora... er. type online Linux
Ora... r1.lsnr ora... er. type online unknown Linux
Ora. ASM ora. ASM. type online Linux
Ora.css D. type online Linux
Ora. diskmon ora... on. type online Linux
Ora. orcl. DB ora... se. type online offline
Ora... RCL. SVC ora... ce. type online offline

The following error is reported in the database log:

Fatal Ni connect error 12547, connecting:
(Description = (address = (Protocol = beq) (program =/Oracle/APP/GRID/product/11.2.0/bin/Oracle) (argv0 = Oracle + asm_o001_orcl) (envs = 'oracle _ home =/Oracle/APP/GRID/product/11.2.0, oracle_sid = + ASM ') (ARGs =' (description = (local = yes) (address = (Protocol = beq) ') (enable = setuser) (CONNECT_DATA = (cid = (program = Oracle @ Linux) (host = Linux) (user = Oracle ))))

Version Information:
TNS for Linux: Version 11.2.0.1.0-Production
Oracle bequeath nt protocol adapter for Linux: Version 11.2.0.1.0-Production
Time: 16-apr-2012 06:18:20
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

It is suspected that a permission error occurs. Ref:TNS-12518 can not connect to RAC 11gr2 database [ID 1088754.1].

View the permissions of + ASM as a grid user and find the following results:

 

-Rwsr-s -- X 1 Oracle oinstall 176 m APR 1507:53 Oracle

Modify permissions:

[Grid @ Linux bin] $ chown grid: oinstall Oracle
Chown: changing ownership of 'oracle ': operation not permitted
[Grid @ Linux bin] $ su Root
Password:
[Root @ Linux bin] # chown grid: oinstall Oracle
[Root @ Linux bin] # ls-lrth Oracle
-Rwxr-X -- X 1 grid oinstall 176 m APR 1507:53 Oracle
[Root @ Linux bin] # chmod 6751 Oracle
[Root @ Linux bin] # ls-lrth Oracle
-Rwsr-s -- X 1 grid oinstall 176 m APR 1507:53 Oracle
[Root @ Linux bin] # exit
Exit
[Grid @ Linux bin] $ ID
Uid = 501 (GRID) gid = 501 (oinstall) groups = 501 (oinstall), 502 (DBA), 503 (region), 504 (ASMA
Dmin), 505 (asmoper), 506 (asmdba)
[Grid @ Linux bin] $ sqlplus/As sysdba

SQL * Plus: Release 11.2.0.1.0 production on Mon Apr 16 06:33:28 2012

Copyright (c) 1982,200 9, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
Oracle instance started.

Total system global area 1068937216 bytes
Fixed size 2220200 bytes
Variable Size 297799512 bytes
Database buffers 763363328 bytes
Redo buffers 5554176 bytes

Database mounted.
Database opened.
SQL> exit

 

The database returns to normal!

Why did the original normal Database become abnormal? It is not clear yet!

[Oracle @ Linux ~] $ Sqlplus/As sysdba

SQL * Plus: Release 11.2.0.1.0 production on Mon Apr 16 06:34:02 2012

Copyright (c) 1982,200 9, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
Oracle instance started.

Total system global area 1068937216 bytes
Fixed size 2220200 bytes
Variable Size 297799512 bytes
Database buffers 763363328 bytes
Redo buffers 5554176 bytes

Database mounted.
Database opened.
SQL> exit

 

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.