[oracle@node1 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 03-OCT-2016 09:41:13
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 03-OCT-2016 09:32:55
Uptime 0 days 0 hr. 8 min. 18 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /data01/app/11.2.0.4/grid_11204/network/admin/listener.ora
Listener Log File /data01/app/grid/diag/tnslsnr/node1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1.localdomain)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@node1 ~]$ clear
cd
[oracle@node1 ~]$ cat /data01/app/oracle/product/11.2.0.4/db_1/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /data01/app/oracle/product/11.2.0.4/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
[oracle@node1 ~]$ cat /data01/app/11.2.0.4/grid_11204/network/admin/listener.ora
# listener.ora Network Configuration File: /data01/app/11.2.0.4/grid_11204/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node1.localdomain)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /data01/app/grid
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
1) Add Static Listener Entry in UAT :
[grid@node2 ~]$ cat /data01/app/11.2.0/grid_11204/network/admin/listener.ora
# listener.ora Network Configuration File: /data01/app/11.2.0/grid_11204/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = UAT)
(ORACLE_HOME = /data01/app/oracle/product/11.2.0.4/db_1)
(SID_NAME = UAT)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2.localdomain)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /data01/app/grid
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
2. Reload listener and confirm the UAT service in listener :
[grid@node2 ~]$ lsnrctl reload
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 03-OCT-2016 10:08:23
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
[grid@node2 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 03-OCT-2016 10:08:32
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 03-OCT-2016 09:12:26
Uptime 0 days 0 hr. 56 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /data01/app/11.2.0/grid_11204/network/admin/listener.ora
Listener Log File /data01/app/grid/diag/tnslsnr/node2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node2.localdomain)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "UAT" has 1 instance(s).
Instance "UAT", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[grid@node2 ~]$ lsnrctl services
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 03-OCT-2016 10:09:27
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "UAT" has 1 instance(s).
Instance "UAT", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
3) Add TNS entry for UAT in ORCL ,
[oracle@node2 admin]$ cat tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
UAT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = UAT)
)
)
[oracle@node2 admin]$ tnsping orcl
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 03-OCT-2016 10:11:55
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = node1.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (40 msec)
[oracle@node2 admin]$ tnsping UAT
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 03-OCT-2016 10:11:58
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = node2.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = UAT)))
OK (40 msec)
4) Copy Password File from ORCL to UAT :
[oracle@node1 dbs]$ scp orapworcl oracle@node2:$ORACLE_HOME/dbs/orapwUAT
orapworcl 100% 1536 1.5KB/s 00:00
[oracle@node1 dbs]$
5.) Verify TNS Connectivity to UAT from orcl :
Make sure the servive name is listener is matching with the name of password file orapw$SERVICE_NAME . It is case sensitive , otherwise you will get
invalid login password error .
[oracle@node1 dbs]$ sqlplus sys/sys@UAT as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 3 10:21:37 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
6) Create Directory Structures for UAT
Create directory to support audit_file_dest
[oracle@node2 dbs]$ mkdir -p /data01/app/oracle/admin/UAT/adump
7) Start UAT (auxiliary) instance in NOMOUNT mode :
[oracle@node2 dbs]$ cat initUAT.ora
*.db_name='UAT'
SQL> startup nomount ;
ORACLE instance started.
Total System Global Area 217157632 bytes
Fixed Size 2251816 bytes
Variable Size 159384536 bytes
Database Buffers 50331648 bytes
Redo Buffers 5189632 bytes
[oracle@node2 dbs]$ export NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"
[oracle@node2 dbs]$ rman target sys/sys@ORCL auxiliary sys/sys@UAT
Recovery Manager: Release 11.2.0.4.0 - Production on Mon Oct 3 13:04:52 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1451945373)
connected to auxiliary database: UAT (not mounted)
RMAN> set echo on
echo set on
RMAN> @rman_dup.cmd
@rman_dup.cmd
RMAN> run {
allocate channel prm1 type disk ;
allocate channel prm2 type disk ;
allocate auxiliary channel stdby type disk ;
DUPLICATE TARGET DATABASE TO UAT FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT 'orcl','uat' , 'ORCL' , 'UAT'
set control_files='+DATA','+DG2'
set db_file_name_convert='+DATA','+DG2'
set log_file_name_convert='+DATA','+DG3'
SET DIAGNOSTIC_DEST='/data01/app/oracle'
set audit_file_dest='/data01/app/oracle/admin/UAT/adump'
LOGFILE
GROUP 1 ('+DG3','+DG2') SIZE 50M ,
GROUP 2 ('+DG3','+DG2') SIZE 50M ,
GROUP 3 ('+DG3','+DG2') SIZE 50M ;
}
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 03-OCT-2016 09:41:13
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 03-OCT-2016 09:32:55
Uptime 0 days 0 hr. 8 min. 18 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /data01/app/11.2.0.4/grid_11204/network/admin/listener.ora
Listener Log File /data01/app/grid/diag/tnslsnr/node1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1.localdomain)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@node1 ~]$ clear
cd
[oracle@node1 ~]$ cat /data01/app/oracle/product/11.2.0.4/db_1/network/admin/tnsnames.ora
# tnsnames.ora Network Configuration File: /data01/app/oracle/product/11.2.0.4/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
[oracle@node1 ~]$ cat /data01/app/11.2.0.4/grid_11204/network/admin/listener.ora
# listener.ora Network Configuration File: /data01/app/11.2.0.4/grid_11204/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node1.localdomain)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /data01/app/grid
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
1) Add Static Listener Entry in UAT :
[grid@node2 ~]$ cat /data01/app/11.2.0/grid_11204/network/admin/listener.ora
# listener.ora Network Configuration File: /data01/app/11.2.0/grid_11204/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = UAT)
(ORACLE_HOME = /data01/app/oracle/product/11.2.0.4/db_1)
(SID_NAME = UAT)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node2.localdomain)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /data01/app/grid
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
2. Reload listener and confirm the UAT service in listener :
[grid@node2 ~]$ lsnrctl reload
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 03-OCT-2016 10:08:23
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
The command completed successfully
[grid@node2 ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 03-OCT-2016 10:08:32
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 03-OCT-2016 09:12:26
Uptime 0 days 0 hr. 56 min. 7 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /data01/app/11.2.0/grid_11204/network/admin/listener.ora
Listener Log File /data01/app/grid/diag/tnslsnr/node2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node2.localdomain)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Service "UAT" has 1 instance(s).
Instance "UAT", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[grid@node2 ~]$ lsnrctl services
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 03-OCT-2016 10:09:27
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "UAT" has 1 instance(s).
Instance "UAT", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully
3) Add TNS entry for UAT in ORCL ,
[oracle@node2 admin]$ cat tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
UAT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = node2.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = UAT)
)
)
[oracle@node2 admin]$ tnsping orcl
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 03-OCT-2016 10:11:55
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = node1.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
OK (40 msec)
[oracle@node2 admin]$ tnsping UAT
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 03-OCT-2016 10:11:58
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = node2.localdomain)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = UAT)))
OK (40 msec)
4) Copy Password File from ORCL to UAT :
[oracle@node1 dbs]$ scp orapworcl oracle@node2:$ORACLE_HOME/dbs/orapwUAT
orapworcl 100% 1536 1.5KB/s 00:00
[oracle@node1 dbs]$
5.) Verify TNS Connectivity to UAT from orcl :
Make sure the servive name is listener is matching with the name of password file orapw$SERVICE_NAME . It is case sensitive , otherwise you will get
invalid login password error .
[oracle@node1 dbs]$ sqlplus sys/sys@UAT as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Oct 3 10:21:37 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
6) Create Directory Structures for UAT
Create directory to support audit_file_dest
[oracle@node2 dbs]$ mkdir -p /data01/app/oracle/admin/UAT/adump
7) Start UAT (auxiliary) instance in NOMOUNT mode :
[oracle@node2 dbs]$ cat initUAT.ora
*.db_name='UAT'
SQL> startup nomount ;
ORACLE instance started.
Total System Global Area 217157632 bytes
Fixed Size 2251816 bytes
Variable Size 159384536 bytes
Database Buffers 50331648 bytes
Redo Buffers 5189632 bytes
[oracle@node2 dbs]$ export NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS"
[oracle@node2 dbs]$ rman target sys/sys@ORCL auxiliary sys/sys@UAT
Recovery Manager: Release 11.2.0.4.0 - Production on Mon Oct 3 13:04:52 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1451945373)
connected to auxiliary database: UAT (not mounted)
RMAN> set echo on
echo set on
RMAN> @rman_dup.cmd
@rman_dup.cmd
RMAN> run {
allocate channel prm1 type disk ;
allocate channel prm2 type disk ;
allocate auxiliary channel stdby type disk ;
DUPLICATE TARGET DATABASE TO UAT FROM ACTIVE DATABASE
SPFILE
PARAMETER_VALUE_CONVERT 'orcl','uat' , 'ORCL' , 'UAT'
set control_files='+DATA','+DG2'
set db_file_name_convert='+DATA','+DG2'
set log_file_name_convert='+DATA','+DG3'
SET DIAGNOSTIC_DEST='/data01/app/oracle'
set audit_file_dest='/data01/app/oracle/admin/UAT/adump'
LOGFILE
GROUP 1 ('+DG3','+DG2') SIZE 50M ,
GROUP 2 ('+DG3','+DG2') SIZE 50M ,
GROUP 3 ('+DG3','+DG2') SIZE 50M ;
}
Or if you have backup location you can use below :
run {
DUPLICATE DATABASE TO UAT
SPFILE
SET CONTROL_FILES='+DG2'
SET DB_FILE_NAME_CONVERT='+DATA','+DG2'
SET LOG_FILE_NAME_CONVERT='+DATA','+DG3'
SET DB_CREATE_ONLINE_LOG_DEST_1='+DG3'
SET DB_CREATE_ONLINE_LOG_DEST_2='+DG3'
SET DB_RECOVERY_FILE_DEST='+DG3'
BACKUP LOCATION '/data01/BACKUP'
SET DIAGNOSTIC_DEST='/data01/app/oracle'
set audit_file_dest='/data01/app/oracle/admin/UAT/adump'
NOFILENAMECHECK;
}
DUPLICATE DATABASE TO UAT
SPFILE
SET CONTROL_FILES='+DG2'
SET DB_FILE_NAME_CONVERT='+DATA','+DG2'
SET LOG_FILE_NAME_CONVERT='+DATA','+DG3'
SET DB_CREATE_ONLINE_LOG_DEST_1='+DG3'
SET DB_CREATE_ONLINE_LOG_DEST_2='+DG3'
SET DB_RECOVERY_FILE_DEST='+DG3'
BACKUP LOCATION '/data01/BACKUP'
SET DIAGNOSTIC_DEST='/data01/app/oracle'
set audit_file_dest='/data01/app/oracle/admin/UAT/adump'
NOFILENAMECHECK;
}
Jadwal Sabung Ayam Online SV388 11 Februari 2019 - Senin, 11 Februari 2019 – Pada Hari Tersebut Akan Di Laksanakan Berbagai Pertandingan Sabung Ayam Secara Live di Arena Sabung Ayam Thailand.
ReplyDeleteSitus Judi Sabung Ayam Online SV388 Merupakan Situs Judi Asal Thailand Yang Sangat Terkenal Dengan Permainan Sabung Ayam Yang Fair dan Menghibur Para Penonton Judi Sabung Ayam.
Untuk Info Lebih Lanjut Bisa Hub kami Di :
wechat : bolavita
line : cs_bolavita
whatsapp : +628122222995
BBM: BOLAVITA