ORA-12545 error connecting scanip

Source: Internet
Author: User
GRID and database version: 11.2.0.1OS: Solaris5.10 symptom: Error sqlplussystemOracle@210.10.4.5: 1521 pdptO reported when the client is connected to scanip

GRID and database version: 11.2.0.1 OS: Solaris 5.10 symptom: sqlplus system/Oracle@210.10.4.5: 1521/pdpt O error reported when client connection scan ip

GRID and database version: 11.2.0.1

OS: Solaris 5.10

Symptom: an error is reported when the client connects to the scan ip address.

Sqlplus system/Oracle@210.10.4.5: 1521/pdpt

ORA-12545: the connection failed because the target host or object does not exist

However, the scan ip address can be connected between two database servers.

# Cat/etc/hosts

: 1 localhost

127.0.0.1 localhost

210.10.4.5 taian-pt-d1 loghost

Taian-pt-d2 210.10.4.6

Taian-pt-d1-vip 210.10.4.9

Taian-pt-d2-vip 210.10.4.10

210.10.4.7 pdpt-cluster-scan

192.168.2.1 taian-pt-d1-priv.

192.168.2.2 taian-pt-d2-priv.


After checking that the scan ip listener is normal, the client can ping the scan ip Address

-Bash-3.2 $ crs_stat-trac resource service is normal

Name Type Target State Host

------------------------------------------------------------

Ora. ARCHDG. dg ora... up. type ONLINE taian-pt-d1

Ora. DATADG. dg ora... up. type ONLINE taian-pt-d1

Ora... ER. lsnr ora... er. type ONLINE taian-pt-d1

Ora... N1.lsnr ora... er. type ONLINE taian-pt-d2

Ora. OCRVT. dg ora... up. type ONLINE taian-pt-d1

Ora. asm ora. asm. type ONLINE taian-pt-d1

Ora. eons ora. eons. type ONLINE taian-pt-d1

Ora. gsd ora. gsd. type OFFLINE

Ora... network ora... rk. type ONLINE taian-pt-d1

Ora. Solaris ora. productname. type OFFLINE

Ora. ons ora. ons. type ONLINE taian-pt-d1

Ora. pdpt. db ora... se. type ONLINE taian-pt-d1

Ora. scan1.vip ora... ip. type ONLINE taian-pt-d2

Ora... SM1.asm application ONLINE taian-pt-d1

Ora... D1.lsnr application ONLINE taian-pt-d1

Ora...-d1.gsd application OFFLINE

Ora...-d1.ons application ONLINE taian-pt-d1

Ora...-d1.vip ora... t1.type ONLINE taian-pt-d1

Ora... SM2.asm application ONLINE taian-pt-d2

Ora... D2.lsnr application ONLINE taian-pt-d2

Ora...-d2.gsd application OFFLINE

Ora...-d2.ons application ONLINE taian-pt-d2

Ora...-d2.vip ora... t1.type ONLINE taian-pt-d2


-Bash-3.2 $ lsnrctl status LISTENER_SCAN1scan IP listener normal

LSNRCTL for Solaris: Version 11.2.0.1.0-Production on 06-MAR-2012 09:36:50

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

Connecting to (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = LISTENER_SCAN1 )))

STATUS of the LISTENER

------------------------

Alias LISTENER_SCAN1

Version TNSLSNR for Solaris: Version 11.2.0.1.0-Production

Start Date 29-FEB-2012 13:42:48

Uptime 5 days 19 hr. 54 min. 1 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File/home/app/grid_home/network/admin/listener. ora

Listener Log File/home/app/grid_home/log/diag/tnslsnr/taian-pt-d2/listener_scan1/alert/log. xml

Listening Endpoints Summary...

(DESCRIPTION = (ADDRESS = (PROTOCOL = ipc) (KEY = LISTENER_SCAN1 )))

(DESCRIPTION = (ADDRESS = (PROTOCOL = tcp) (HOST = 210.10.4.7) (PORT = 1521 )))

Services Summary...

Service "PDPT" has 2 instance (s ).

Instance "PDPT1", status READY, has 1 handler (s) for this service...

Instance "PDPT2", status READY, has 1 handler (s) for this service...

The command completed successfully


SQL> the local_listener parameter of the show parameter listener database instance is the vip host name.

NAME TYPE VALUE

-----------------------------------------------------------------------------

Listener_networks string

Local_listener string (DESCRIPTION = (ADDRESS_LIST = (AD

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.