oracle 10g asm ogg,询问一个ogg配置问题

GGSCI (rac1) 17> edit param ext1

extract ext1

SETENV (ORACLE_SID="prod1")

USERID gg,PASSWORD gg

tranlogoptions ASMUSER sys@asm1,ASMPASSWORD mult1234

exttrail /oraapp/oracle/product/1120/oggdata/sq

dynamicresolution

DDL &

INCLUDE MAPPED OPTYPE ALTER OBJNAME "scott.dept" &

INCLUDE MAPPED OPTYPE ALTER OBJNAME "scott.emp"

table scott.dept;

table scott.emp;

[oracle@rac1 admin]$ pwd

/oraapp/oracle/product/1120/dbhome_1/network/admin

[oracle@rac1 admin]$ more tnsnames.ora

# tnsnames.ora Network Configuration File: /oraapp/oracle/product/1120/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configuration tools.

PROD =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = rac-cluster-scan)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = prod)

)

)

ASM1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.236)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = +ASM)

(SID_NAME = +ASM1)

)

)

prod1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.236)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = prod)

(INSTANCE_NAME = prod1)

)

)

prod2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.17.237)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = prod)

(INSTANCE_NAME = prod2)

)

)

[oracle@rac1 admin]$

[oracle@rac1 admin]$ sqlplus sys/mult1234@asm1 as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 10 15:43:20 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> quit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

[oracle@rac1 admin]$ sqlplus sys/mult1234@asm1 as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 10 15:43:36 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

SQL> quit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Real Application Clusters and Automatic Storage Management options

[oracle@rac1 admin]$