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]$