oracle 10g 远程连接asm
发布时间:2020-12-12 13:31:39 所属栏目:百科 来源:网络整理
导读:asm远程连接可能会遇到以下报错: ORA-12505 TNS:listener could not resolve SID given in connect descriptorORA-12541: TNS:no listenerORA-15000: command disallowed by current instance typeORA-12528: TNS:listener: all appropriate instances are
asm远程连接可能会遇到以下报错:
ORA-12505 TNS:listener could not resolve SID given in connect descriptor ORA-12541: TNS:no listener ORA-15000: command disallowed by current instance type ORA-12528: TNS:listener: all appropriate instances are blocking new connections ORA-1031: insufficient privileges asm远程连接配置如下: remote_login_passwordfile = exclusive ... for stand alone ASM setups remote_login_passwordfile = shared ... for ASM setups that also use Real Application Cluster (RAC) 节点1: [[email?protected] admin]$ cat listener.ora SID_LIST_LISTENER_prodb1 = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) (PROGRAM = extproc) (SID_DESC = (SID_NAME = +ASM1) (GLOBAL_DBNAME = +ASM) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) ) ) LISTENER_prodb1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = prodb1-vip)(PORT = 1521)(IP = FIRST)) (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.101)(PORT = 1521)(IP = FIRST)) ) ) 节点2: [[email?protected] admin]$ cat listener.ora SID_LIST_LISTENER_prodb2 = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) (PROGRAM = extproc) (SID_DESC = (SID_NAME = +ASM2) (GLOBAL_DBNAME = +ASM) (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1) ) ) LISTENER_prodb2 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = prodb2-vip)(PORT = 1521)(IP = FIRST)) (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.102)(PORT = 1521)(IP = FIRST)) ) ) 客户端tnsname.ora: ASM1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.101)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = +ASM) (UR=A) ) ) ASM2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.102)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = +ASM) (UR=A) ) ) ASM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.102)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.101)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = +ASM) (UR=A) ) ) 关键部分为 $ sqlplus sys/[email?protected] as sysdba SQL*Plus: Release 10.2.0.5.0 - Production on чǚ? 7? 5 21:44:30 2018 Copyright (c) 1982,2010,Oracle. All Rights Reserved. ERROR: ORA-12528: TNS:listener: all appropriate instances are blocking new connections UR=A选项通常用来连接使用nomount,mount或restricted模式启动数据库。 数据库启动到nomount,监听状态为BLOCKED;
(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |