Release 2 (9.2.0.3) for Linux Intel
Part No. B10925-01
 Contents |
 Index |
|
Oracle9 Database Certified Configuration Installation Guide
Release 2 (9.2.0.3) for Linux Intel Part No. B10925-01 |
|
This appendix contains single-instance and Real Application Clusters sample output. The following samples are included:
Hardware and Software Compliance with Oracle9i Database Certified Configuration for Single-instance
Oracle9i Database Certified Configuration Single-instance Prior to Image Restoration
Oracle9i Database Certified Configuration Real Application Clusters Prior to Image Restoration
Oracle9i Database Certified Configuration Single-instance after Reconfiguration
Oracle9i Database Certified Configuration Real Application Clusters after Reconfiguration
Oracle9i Database Certified Configuration Single-instance Cloning Log
Oracle9i Database Certified Configuration Real Application Clusters Cloning Log
Oracle9i Database Certified Configuration Convex Utility Output
This section includes sample output from the ocheck tool for a single-instance using the following command. The command is run by the user to verify the suitability of the system hardware and operating system for installation of Oracle products.
ocheck -product rdbms -system
The following is the output from the command:
ocheck 3.7b (library C313b/L35a) 18-Mar-2003 14:31:23 PST system: lnxdell3 (ORCL) RDBMS "system" check Check Value Expected Status Processors and Memory CPU count 4 >= 2 pass Processor speed (minimum) 699 MHz >= 700 MHz pass Processor power factor 2796 >= 1400 pass Physical memory 2010 MB >= 1920 MB pass Operating System and Software Configuration OS kernel version 2.4.9-e.12smp == 2.4.9 pass OS version Redhat 2.1 AS == Redhat 2.1 AS pass Required OS patches (none) == (none) pass Filesystem size: / 9071 MB >= 8294 MB pass Filesystem size: /boot 121 MB >= 115 MB pass Filesystem size: /oem 2015 MB >= 921 MB pass Filesystem size: /admin 10076 MB >= 3686 MB pass Total swap space 4094 MB >= 4000 MB pass Executable "/bin/ksh" installed == installed pass Executable "bc" installed == installed pass Package "gcc" version 2.96 == 2.96 pass Package "gcc" release 108.1 == 108.1 pass Network Number of network interfaces 3 >= 2 pass End of Report
This section includes sample log for the ocheck tool using the following command. This command is run by the user to verify the suitability of the system hardware and operating system for installation of Oracle products.
ocheck -product rac -system
The following is the output from the command:
ocheck 3.7b (library C313b/L35a) 18-Mar-2003 14:31:59 PST system: lnxdell3 (ORCL) RAC "system" check Check Value Expected Status Processors and Memory CPU count 4 >= 2 pass Processor speed (minimum) 699 MHz >= 700 MHz pass Processor power factor 2796 >= 1400 pass Physical memory 2010 MB >= 1920 MB pass Operating System and Software Configuration OS kernel version 2.4.9-e.12smp == 2.4.9 pass OS version Redhat 2.1 AS == Redhat 2.1 AS pass Required OS patches (none) == (none) pass Filesystem size: / 9071 MB >= 8294 MB pass Filesystem size: /boot 121 MB >= 115 MB pass Filesystem size: /oem 2015 MB >= 921 MB pass Filesystem size: /admin 10076 MB >= 3686 MB pass Total swap space 4094 MB >= 4000 MB pass Executable "/bin/ksh" installed == installed pass Executable "bc" installed == installed pass Package "gcc" version 2.96 == 2.96 pass Package "gcc" release 108.1 == 108.1 pass Network Number of network interfaces 3 >= 2 pass End of Report
This section includes sample output from the ocheck tool for a single-instance using the following command. This command is run by the dbcc_install_image.sh script prior to an image restoration.
ocheck -product rdbms -preimage -dbname DGOLD
The following is the output from the command:
ocheck 3.7b (library C313b/L35a) 14-Mar-2003 14:00:11 PST system: lnxdell3 (DGOLD) RDBMS "preimg" check Check Value Expected Status Processors and Memory CPU count 4 >= 2 pass Processor speed (minimum) 699 MHz >= 700 MHz pass Processor power factor 2796 >= 1400 pass Physical memory 2010 MB >= 1920 MB pass Operating System and Software Configuration OS kernel version 2.4.9-e.12smp == 2.4.9 pass OS version Redhat 2.1 AS == Redhat 2.1 AS pass Required OS patches (none) == (none) pass Filesystem size: / 9071 MB >= 8294 MB pass Filesystem size: /boot 121 MB >= 115 MB pass Filesystem size: /oem 2015 MB >= 921 MB pass Filesystem size: /admin 9071 MB >= 3686 MB pass Filesystem size: /dgold/oracle 9071 MB >= 8294 MB pass Free disk space in /dgold/oracle 5625 MB >= 5120 MB pass Total swap space 4094 MB >= 4000 MB pass Executable "/bin/ksh" installed == installed pass Executable "bc" installed == installed pass Package "gcc" version 2.96 == 2.96 pass Package "gcc" release 108.1 == 108.1 pass Accounts and Groups Group "dbdgold" configured == configured pass User account "ordgold" configured == configured pass Home directory for "ordgold" configured == configured pass User "ordgold" groups configured == configured pass Network Number of network interfaces 3 >= 2 pass Ethernet network UP == UP pass Data Storage Filesystem size: /dgold/oradata 24465 MB >= 8294 MB pass Filesystem opts: /dgold/oradata configured == configured pass End of Report
This section includes sample log from the ocheck tool for a Real Application Clusters using the following command:
ocheck -product rac -preimage -dbname DGOLD
The following is the output from the command:
ocheck 3.7b (library C313b/L35a) 14-Mar-2003 13:52:31 PST system: lnxdell3 (DGOLD) RAC "preimg" check Check Value Expected Status Processors and Memory CPU count 4 >= 2 pass Processor speed (minimum) 699 MHz >= 700 MHz pass Processor power factor 2796 >= 1400 pass Physical memory 2010 MB >= 1920 MB pass Operating System and Software Configuration OS kernel version 2.4.9-e.12smp == 2.4.9 pass OS version Redhat 2.1 AS == Redhat 2.1 AS pass Required OS patches (none) == (none) pass Filesystem size: / 9071 MB >= 8294 MB pass Filesystem size: /boot 121 MB >= 115 MB pass Filesystem size: /oem 2015 MB >= 921 MB pass Filesystem size: /admin 9071 MB >= 3686 MB pass Filesystem size: /dgold/oracle 9071 MB >= 8294 MB pass Free disk space in /dgold/oracle 5625 MB >= 5120 MB pass Total swap space 4094 MB >= 4000 MB pass Executable "/bin/ksh" installed == installed pass Executable "bc" installed == installed pass Package "gcc" version 2.96 == 2.96 pass Package "gcc" release 108.1 == 108.1 pass Accounts and Groups Group "dbdgold" configured == configured pass User account "ordgold" configured == configured pass Home directory for "ordgold" configured == configured pass User "ordgold" groups configured == configured pass Network Number of network interfaces 3 >= 2 pass Ethernet network UP == UP pass Data Storage Filesystem size: /dgold/oradata 24465 MB >= 8294 MB pass Filesystem opts: /dgold/oradata configured == configured pass Remote Access Remote shell access accessible == accessible pass Node time synchronization synchronized == synchronized pass End of Report
This section includes sample log from the ocheck tool for a single-instance using the following command:
ocheck -product rdbms -postconfig -dbname DGOLD
The following is the output from the command:
ocheck 3.7b (library C313b/L35a) 26-Mar-2003 10:02:29 PST system: lnxdell3 (DGOLD) RDBMS "postconf" check Check Value Expected Status Oracle services ORACLE_HOME variable set set pass -- ORACLE_HOME = /dgold/oracle/product/920 ORACLE_SID variable set set pass -- ORACLE_SID = DGOLD Valid ORACLE_HOME configured configured pass Oracle Listener running running pass TNS ping (DGOLD) succeeded succeeded pass SQLPlus connection succeeded succeeded pass Oracle SNMP Agent running running pass End of Report
This section includes sample log from the ocheck tool for a Real Application Clusters using the following command:
ocheck -product rac -postconfig -dbname DGOLD
The following is the output from the command:
ocheck 3.7b (library C313b/L35a) 26-Mar-2003 10:12:08 PST system: lnxdell3 (DGOLD) RAC "postconf" check Check Value Expected Status Oracle services ORACLE_HOME variable set set pass -- ORACLE_HOME = /dgold/oracle/product/920 ORACLE_SID variable set set pass -- ORACLE_SID = DGOLD Valid ORACLE_HOME configured configured pass Oracle Listener running running pass TNS ping (DGOLD) succeeded succeeded pass SQLPlus connection succeeded succeeded pass Oracle SNMP Agent running running pass RAC GSD Daemon Running running running pass Active intance check rac enabled (2) rac enabled pass End of Report
This section includes a sample log after successfully running the reconfig.sh script for a cold backup.
ocheck 3.7b (library C313b/L35a) 12-Mar-2003 18:02:44 PST
system: unbreakable (GE) RDBMS "reconf" check
Check Value Expected Status
Processors and Memory
CPU count 1 >= 2 fail
Processor speed (minimum) 731 MHz >= 700 MHz pass
Processor power factor 731 >= 1400 fail
Physical memory 1507 MB >= 1920 MB fail
Operating System and Software Configuration
OS kernel version 2.4.9-e.3 == 2.4.9 pass
OS version Redhat 2.1 AS == Redhat 2.1 AS pass
Required OS patches (none) == (none) pass
Total swap space 2047 MB 4000 MB fail
Max shared memory: SHMMAX 4096 MB == 1507 MB pass
Shared memory parameter: SHMNNI 4096 >= 100 pass
Semaphore parameter: SEMMSL 250 >= 100 pass
Semaphore parameter: SEMMNS 32000 >= 256 pass
Semaphore parameter: SEMOPM 100 >= 100 pass
Semaphore parameter: SEMMNI 128 >= 100 pass
Shared memory and semaphores correct == correct pass
Executable "/bin/ksh" installed == installed pass
Executable "bc" installed == installed pass
Package "gcc" version 2.96 == 2.96 pass
Package "gcc" release 108.1 == 108.1 pass
Accounts and Groups
Group "dbge" configured == configured pass
User account "orge" configured == configured pass
Home directory for "orge" configured == configured pass
User "orge" groups configured == configured pass
Network
Number of network interfaces 2 >= 2 pass
Ethernet network UP == UP pass
Installer error log no errors == no errors pass
Executable "oracle" installed == installed pass
SQL*Plus login succeeded == succeeded pass
End of Report
reconfig.sh: info: Converted .trc to .sql for control file creation.
reconfig.sh: info: New initGE.ora file was generated.
reconfig.sh: info: spfile spfileGE exists.
reconfig.sh: info: spfile spfileGE deleted.
reconfig.sh: info: Running Modified SQL to recreate control files...
SQL*Plus: Release 9.2.0.2.0 - Production on Wed Mar 12 18:02:46 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> SQL> SQL> STARTUP NOMOUNT
ORACLE instance started.
Total System Global Area 235999364 bytes
Fixed Size 450692 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
SQL> CREATE CONTROLFILE SET DATABASE "GE" RESETLOGS ARCHIVELOG
2 -- SET STANDBY TO MAXIMIZE PERFORMANCE
3 MAXLOGFILES 5
4 MAXLOGMEMBERS 3
5 MAXDATAFILES 100
6 MAXINSTANCES 1
7 MAXLOGHISTORY 226
8 LOGFILE
9 GROUP 1 (
10 '/ge/oradata/data03/log_1_1.rdo',
11 '/ge/oradata/data03/log_1_2.rdo'
12 ) SIZE 100M,
13 GROUP 2 (
14 '/ge/oradata/data03/log_2_1.rdo',
15 '/ge/oradata/data03/log_2_2.rdo'
16 ) SIZE 100M,
17 GROUP 3 (
18 '/ge/oradata/data03/log_3_1.rdo',
19 '/ge/oradata/data03/log_3_2.rdo'
20 ) SIZE 100M,
21 GROUP 4 (
22 '/ge/oradata/data03/log_4_1.rdo',
23 '/ge/oradata/data03/log_4_2.rdo'
24 ) SIZE 100M
25 -- STANDBY LOGFILE
26 DATAFILE
27 '/ge/oradata/data02/system01.dbf',
28 '/ge/oradata/data01/undotbs1.dbf',
29 '/ge/oradata/data01/cwmlite01.dbf',
30 '/ge/oradata/data01/drsys01.dbf',
31 '/ge/oradata/data01/example01.dbf',
32 '/ge/oradata/data01/indx01.dbf',
33 '/ge/oradata/data01/odm01.dbf',
34 '/ge/oradata/data01/tools01.dbf',
35 '/ge/oradata/data01/users01.dbf',
36 '/ge/oradata/data01/xdb01.dbf'
37 CHARACTER SET UTF8
38 ;
Control file created.
SQL> ALTER DATABASE OPEN RESETLOGS;
Database altered.
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/ge/oradata/data02/temp01.dbf'
2 ;
Tablespace altered.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -Production
JServer Release 9.2.0.2.0 - Production
reconfig.sh: info: Recreating controlfile sql finished.
SQL*Plus: Release 9.2.0.2.0 - Production on Wed Mar 12 18:03:06 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
JServer Release 9.2.0.2.0 - Production
SQL> SQL>
Database altered.
SQL>
File created.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -Production
JServer Release 9.2.0.2.0 - Production
reconfig.sh: info: Finished running modified SQL to recreate control files.
Cold database reconfiguration successful.
mod_services.sh: HOME=/ge/oracle
mod_services.sh: ORACLE_HOME=/ge/oracle/product/920
mod_services.sh: script_dir=.
mod_services.sh: script_dir=.
Current directory is /admin/dbcc/3.1.0/ref_config
warning: old Q file were found, and were moved to $ORACLE
_HOME/network/agent/oldQfiles.DGOLD directory.
warning: Jobs and Events may be need to be resubmitted on this node, as reconfig
doesnot support cloning of jobs and events submitted.
Updated $ORACLE_HOME/network/admin/listener.ora file.
Updated $ORACLE_HOME/network/admin/tnsnames.ora file.
Updated /ge/oracle/.profile.oradb file.
mod_services.sh: info: oraparam.ini modified.
Starting Oracle9i Database Services...
LSNRCTL for Linux: Version 9.2.0.2.0 - Production on 12-MAR-2003 18:03:21
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /ge/oracle/product/920/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.2.0 - Production
System parameter file is /ge/oracle/product/920/network/admin/listener.ora
Log messages written to /ge/oracle/product/920/network/log/listener_ge.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=GE)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=unbreakable)(PORT=10650)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=GE)))
STATUS of the LISTENER
------------------------
Alias LISTENER_GE
Version TNSLSNR for Linux: Version 9.2.0.2.0 - Production
Start Date 12-MAR-2003 18:03:21
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /ge/oracle/product/920/network/admin/listener.ora
Listener Log File /ge/oracle/product/920/network/log/listener_ge.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=GE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=unbreakable)(PORT=10650)))
Services Summary...
Service "GE.US.ORACLE.COM" has 1 instance(s).
Instance "GE", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
SQL*Plus: Release 9.2.0.2.0 - Production on Wed Mar 12 18:03:21 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 235999364 bytes
Fixed Size 450692 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -
Production
JServer Release 9.2.0.2.0 - Production
Completed starting all Oracle9i Services.
ocheck 3.7b (library C313b/L35a) 12-Mar-2003 18:03:36 PST
system: unbreakable (GE) RDBMS "postconf" check
Check Value Expected Status
Oracle services
ORACLE_HOME variable set set pass
-- ORACLE_HOME = /ge/oracle/product/920
ORACLE_SID variable set set pass
-- ORACLE_SID = GE
Valid ORACLE_HOME configured configured pass
Oracle Listener running running pass
TNS ping (GE) succeeded succeeded pass
SQL*Plus connection succeeded succeeded pass
Oracle SNMP Agent running running pass
End of Report
Critical Oracle Services are responding.
Reconfiguration Completed Successfully.
This section includes a sample log after successfully cloning a Real Application Clusters database using the reconfig.sh -rac script.
reconfig.sh Mon Mar 17 14:34:49 PST 2003
ocheck 3.7b (library C313b/L35a) 17-Mar-2003 14:34:49 PST
system: lnxdell4 (RACDB) RAC "reconf" check
Check Value Expected Status Processors and Memory
CPU count 4 >= 2 pass
Processor speed (minimum) 699 MHz >= 700 MHz pass
Processor power factor 2796 >= 1400 pass
Physical memory 2010 MB >= 1920 MB pass
Operating System and Software Configuration
OS kernel version 2.4.9-e.12smp == 2.4.9 pass
OS version Redhat 2.1 AS == Redhat 2.1 AS pass
Required OS patches (none) == (none) pass
Total swap space 4094 MB >= 4000 MB pass
Max shared memory: SHMMAX 6144 MB == 2010 MB pass
Shared memory parameter: SHMNNI 4096 >= 100 pass
Semaphore parameter: SEMMSL 1000 >= 100 pass
Semaphore parameter: SEMMNS 32000 >= 256 pass
Semaphore parameter: SEMOPM 100 >= 100 pass
Semaphore parameter: SEMMNI 128 >= 100 pass
Shared memory and semaphores correct == correct pass
Executable "/bin/ksh" installed == installed pass
Executable "bc" installed == installed pass
Package "gcc" version 2.96 == 2.96 pass
Package "gcc" release 108.1 == 108.1 pass
Accounts and Groups
Group "dbracdb" configured == configured pass
User account "orracdb" configured == configured pass
Home directory for "orracdb" configured == configured pass
User "orracdb" groups configured == configured pass
Network
Number of network interfaces 3 >= 2 pass
Ethernet network UP == UP pass
Filesystem opts: /racdb/oradata/ configured == configured pass
Remote Access
Remote shell access (as orracdb) accessible == accessible pass
Volume Manager and Clusterware
Kernel module "hangcheck-timer" loaded == loaded pass
Installer error log no errors == no errors pass
Executable "oracle" installed == installed pass
SQL*Plus login succeeded == succeeded pass
Oracle CM running running (2) == running pass
End of Report
reconfig.sh: info: Converted .trc to .sql for control file creation.
SQL*Plus: Release 9.2.0.2.0 - Production on Mon Mar 17 14:34:59 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected.
SQL> SQL>
File created.
SQL> Disconnected
reconfig.sh: info: New initRACDB.ora file was generated.
SQL*Plus: Release 9.2.0.2.0 - Production on Mon Mar 17 14:34:59 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected.
SQL> SQL>
File created.
SQL> Disconnected
Cold database reconfiguration successful.
Generated Listener: $ORACLE_HOME/network/admin/listener.ora on node: lnxdell4
Generated Service Name file: $ORACLE_HOME/network/admin/tnsnames.ora on node:
lnxdell4
Configuring sqlnet.ora
Generated Listener: $ORACLE_HOME/network/admin/listener.ora on node: lnxdell3
Generated Service Name file: $ORACLE_HOME/network/admin/tnsnames.ora on node:
lnxdell3
Configuring sqlnet.ora
reconfig.sh: info: spfile spfileRACDB exists.
reconfig.sh: info: spfile spfileRACDB deleted.
reconfig.sh: info: Running Modified SQL to recreate control files...
SQL*Plus: Release 9.2.0.2.0 - Production on Mon Mar 17 14:38:14 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> SQL> SQL> STARTUP NOMOUNT
ORACLE instance started.
Total System Global Area 252776600 bytes
Fixed Size 450712 bytes
Variable Size 218103808 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
SQL> CREATE CONTROLFILE SET DATABASE "RACDB" RESETLOGS NOARCHIVELOG
2 -- SET STANDBY TO MAXIMIZE PERFORMANCE
3 MAXLOGFILES 192
4 MAXLOGMEMBERS 3
5 MAXDATAFILES 1024
6 MAXINSTANCES 32
7 MAXLOGHISTORY 3403
8 LOGFILE
9 GROUP 1 (
10 '/racdb/oradata/data03/log1_1_1.rdo',
11 '/racdb/oradata/data03/log1_1_2.rdo'
12 ) SIZE 100M,
13 GROUP 2 (
14 '/racdb/oradata/data03/log1_2_1.rdo',
15 '/racdb/oradata/data03/log1_2_2.rdo'
16 ) SIZE 100M,
17 GROUP 3 (
18 '/racdb/oradata/data03/log1_3_1.rdo',
19 '/racdb/oradata/data03/log1_3_2.rdo'
20 ) SIZE 100M,
21 GROUP 4 (
22 '/racdb/oradata/data03/log1_4_1.rdo',
23 '/racdb/oradata/data03/log1_4_2.rdo'
24 ) SIZE 100M
25 -- STANDBY LOGFILE
26 DATAFILE
27 '/racdb/oradata/data02/system01.dbf',
28 '/racdb/oradata/data01/undotbs1.dbf',
29 '/racdb/oradata/data01/users01.dbf',
30 '/racdb/oradata/data01/example01.dbf',
31 '/racdb/oradata/data01/cwmlite01.dbf',
32 '/racdb/oradata/data01/indx01.dbf',
33 '/racdb/oradata/data01/odm01.dbf',
34 '/racdb/oradata/data01/tools01.dbf',
35 '/racdb/oradata/data01/drsys01.dbf',
36 '/racdb/oradata/data01/xdb01.dbf',
37 '/racdb/oradata/data01/undotbs2.dbf'
38 CHARACTER SET UTF8
39 ;
Control file created.
SQL> ALTER DATABASE OPEN RESETLOGS;
Database altered.
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/racdb/oradata/data02/temp01.dbf'
REUSE;
Tablespace altered.
SQL> ;
1* ALTER TABLESPACE TEMP ADD TEMPFILE '/racdb/oradata/data02/temp01.dbf' REUSE
SQL> ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 5 ('/racdb/oradata/data03/log2_5
_1.rdo', '/racdb/oradata/data03/log2_5_2.rdo') SIZE 102400K REUSE;
Database altered.
SQL> ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 6 ('/racdb/oradata/data03/log2_6
_1.rdo', '/racdb/oradata/data03/log2_6_2.rdo') SIZE 102400K REUSE;
Database altered.
SQL> ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 7 ('/racdb/oradata/data03/log2_7
_1.rdo', '/racdb/oradata/data03/log2_7_2.rdo') SIZE 102400K REUSE;
Database altered.
SQL> ALTER DATABASE ADD LOGFILE THREAD 2 GROUP 8 ('/racdb/oradata/data03/log2_8
_1.rdo', '/racdb/oradata/data03/log2_8_2.rdo') SIZE 102400K REUSE;
Database altered.
SQL> ALTER DATABASE ENABLE PUBLIC THREAD 2;
Database altered.
SQL> ;
1* ALTER DATABASE ENABLE PUBLIC THREAD 2
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -
Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining
options
JServer Release 9.2.0.2.0 - Production
reconfig.sh: info: Recreating controlfile sql finished.
SQL*Plus: Release 9.2.0.2.0 - Production on Mon Mar 17 14:41:17 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining
options
JServer Release 9.2.0.2.0 - Production
SQL> SQL>
Database altered.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -
Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining
options
JServer Release 9.2.0.2.0 - Production
reconfig.sh: info: Finished running modified SQL to recreate control files.
Cold database reconfiguration successful.
Generated Listener: $ORACLE_HOME/network/admin/listener.ora on node: lnxdell4
Generated Service Name file: $ORACLE_HOME/network/admin/tnsnames.ora on node:
lnxdell4
Configuring sqlnet.ora
Starting Oracle9i Database Services...
LSNRCTL for Linux: Version 9.2.0.2.0 - Production on 17-MAR-2003 14:41:32
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /racdb/oracle/product/920/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.2.0 - Production
System parameter file is /racdb/oracle/product/920/network/admin/listener.ora
Log messages written to /racdb/oracle/product/920/network/log/listener
_racdb1.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=RACDB)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lnxdell4.us.oracle.com)(PORT=2483)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=RACDB)))
STATUS of the LISTENER
------------------------
Alias LISTENER_RACDB1
Version TNSLSNR for Linux: Version 9.2.0.2.0 - Production
Start Date 17-MAR-2003 14:41:32
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /racdb/oracle/product/920/network/admin/listener.ora
Listener Log File /racdb/oracle/product/920/network/log/listener
_racdb1.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=RACDB)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lnxdell4.us.oracle.com)(PORT=2483)))
Services Summary...
Service "RACDB.US.ORACLE.COM" has 1 instance(s).
Instance "RACDB1", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
SQL*Plus: Release 9.2.0.2.0 - Production on Mon Mar 17 14:41:32 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 252776600 bytes
Fixed Size 450712 bytes
Variable Size 218103808 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -
Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining
options
JServer Release 9.2.0.2.0 - Production
Completed starting all Oracle9i Services.
Generated Listener: $ORACLE_HOME/network/admin/listener.ora on node: lnxdell3
Generated Service Name file: $ORACLE_HOME/network/admin/tnsnames.ora on node:
lnxdell3
Configuring sqlnet.ora
Starting Oracle9i Database Services...
LSNRCTL for Linux: Version 9.2.0.2.0 - Production on 17-MAR-2003 14:44:19
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /racdb/oracle/product/920/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.2.0 - Production
System parameter file is /racdb/oracle/product/920/network/admin/listener.ora
Log messages written to /racdb/oracle/product/920/network/log/listener
_racdb2.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=RACDB)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lnxdell3.us.oracle.com)(PORT=2483)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=RACDB)))
STATUS of the LISTENER
------------------------
Alias LISTENER_RACDB2
Version TNSLSNR for Linux: Version 9.2.0.2.0 - Production
Start Date 17-MAR-2003 14:44:20
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /racdb/oracle/product/920/network/admin/listener.ora
Listener Log File /racdb/oracle/product/920/network/log/listener
_racdb2.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=RACDB)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lnxdell3.us.oracle.com)(PORT=2483)))
Services Summary...
Service "RACDB.US.ORACLE.COM" has 1 instance(s).
Instance "RACDB2", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
SQL*Plus: Release 9.2.0.2.0 - Production on Mon Mar 17 14:44:20 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 252776600 bytes
Fixed Size 450712 bytes
Variable Size 218103808 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -
Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining
options
JServer Release 9.2.0.2.0 - Production
Completed starting all Oracle9i Services.
ocheck 3.7b (library C313b/L35a) 17-Mar-2003 14:42:42 PST
system: lnxdell4 (RACDB) RAC "postconf" check
Check Value Expected Status
Oracle services
ORACLE_HOME variable set set pass
-- ORACLE_HOME = /racdb/oracle/product/920
ORACLE_SID variable set set pass
-- ORACLE_SID = RACDB1
Valid ORACLE_HOME configured configured pass
Oracle Listener running running pass
TNS ping (RACDB) succeeded succeeded pass
SQL*Plus connection succeeded succeeded pass
Oracle SNMP Agent running running pass
Global Services Daemon (GSD) running running pass
Active instance check rac enabled (2) rac enabled pass
-- instances: (lnxdell4:RACDB1 lnxdell3:RACDB2)
End of Report
Critical Oracle Services are responding.
Reconfiguration Completed Successfully.
The following is a sample log after successfully running the convex utility.
Welcome to CONVEX 3.1.0 (An Single Instance Converter and Multi-Node RAC Expander)
Please enter the Database Name in the database which you want to convert: dgold
OCC_DB_NAME=DGOLD
variable: OCC_ORACLE_HOME
default: "/dgold/oracle/product/920"
comment: Directory to be used for ORACLE_HOME.
Enter directory name:
variable: OCC_CM_ORACLE_HOME
default: "/dgold/oracle/product/920"
comment: Directory to be used for Cluster Manager ORACLE_HOME.
Enter directory name:
variable: OCC_LISTENER_PORT
default: "10650"
comment: Port number that the Oracle Listener will use.
Enter number:
variable: OCC_RAC_NODES
default: "lnxcom3 lnxcom4"
comment: List of nodes in this RAC cluster.
Specify cluster-private node names.
Enter node name(s), separated by spaces:
variable: OCC_DATA_FILESYSTEM
default: "/dgold/oradata/data01"
comment: Filesystem that will be used to hold Oracle data files.
Enter directory name:
variable: OCC_DB_LOG_FILESYSTEM
default: "/dgold/oradata/data03"
comment: Filesystem that will be used to hold Oracle log files.
Enter directory name:
variable: OCC_SYSTEM_TEMP_FILESYSTEM
default: "/dgold/oradata/data02"
comment: Filesystem that will be used to hold Oracle system and temp files.
Enter directory name:
OCC_RAC_INSTALL_YN: yes
OCC_NAS_INSTALL_YN: yes
OCC_ORACLE_HOME: /dgold/oracle/product/920
OCC_CM_ORACLE_HOME: /dgold/oracle/product/920
OCC_LISTENER_PORT: 10650
OCC_RAC_NODES: lnxcom3 lnxcom4
OCC_DATA_FILESYSTEM: /dgold/oradata/data01
OCC_DB_LOG_FILESYSTEM: /dgold/oradata/data03
OCC_SYSTEM_TEMP_FILESYSTEM: /dgold/oradata/data02
Checking connection to system lnxcom3 ...
Checking connection to system lnxcom4 ...
CONVEX info: Detecting Cluster Manager already started.
/dgold/oracle/product/920/dbs/initDGOLD.ora
OCC_ORACLE_BASE=/dgold/oracle
ORACLE_BASE=/dgold/oracle
OCC_CM_ORACLE_BASE=/oracm/oracle
OCC_ORACLE_HOME=/dgold/oracle/product/920
ORACLE_HOME=/dgold/oracle/product/920
OCC_CM_ORACLE_HOME=/dgold/oracle/product/920
OCC_ORACLE_OWNER_USER=ordgold
OCC_ORACLE_BASE_GIT=/dgold
OCC_ORACLE_DBA_USER_HOME=/home/ordgold
ORACLE_DOC=/dgold/oracle/product/920/doc
OCC_ORACLE_OWNER_GROUP=dbdgold
ORACLE_SID=DGOLD
OCC_ORACLE_DBA_GROUP=dbdgold
OCC_ORACLE_DBA_USER=ordgold
SQL*Plus: Release 9.2.0.2.0 - Production on Fri Feb 28 16:53:30 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> SQL>
File created.
SQL> Disconnected
user_dump_dest=/dgold/oracle/admin/udump
Control file : /dgold/oracle/admin/udump/dgold_ora_23171.trc
CONVEX info: Collecting database info ...
===========================================
CONVEX info: Database info (before conversion):
===========================================
Use undo tablespace.
Number of log groups per thread: 4
Total Number of log groups in the database: 4
Number of log members per group: 2
Log size : 100M
Total number of threads: 1
==============================
Creating all cluster database specific views ...
SQL*Plus: Release 9.2.0.2.0 - Production on Fri Feb 28 16:54:12 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Real Application Clusters option
JServer Release 9.2.0.2.0 - Production
SQL> SQL> SQL> SQL> SQL> SQL> Disconnected from Oracle9i Enterprise Edition
Release 9.2.0.2.0 - Production
With the Real Application Clusters option
JServer Release 9.2.0.2.0 - Production
CONVEX info: srvctl to configure RAC information ......
Detecting GSD daemon is running.
Adding DGOLD1(lnxcom3) to RAC Configuration ...
Adding DGOLD2(lnxcom4) to RAC Configuration ...
OCC_ORACLE_BASE=/dgold/oracle
ORACLE_BASE=/dgold/oracle
OCC_CM_ORACLE_BASE=/oracm/oracle
OCC_ORACLE_HOME=/dgold/oracle/product/920
ORACLE_HOME=/dgold/oracle/product/920
OCC_CM_ORACLE_HOME=/dgold/oracle/product/920
OCC_ORACLE_OWNER_USER=ordgold
OCC_ORACLE_BASE_GIT=/dgold
OCC_ORACLE_DBA_USER_HOME=/home/ordgold
ORACLE_DOC=/dgold/oracle/product/920/doc
OCC_ORACLE_OWNER_GROUP=dbdgold
ORACLE_SID=DGOLD
OCC_ORACLE_DBA_GROUP=dbdgold
OCC_ORACLE_DBA_USER=ordgold
Recreating the control file ...
Adding redo thread ...
Creating more undo tablespace ...
SQL*Plus: Release 9.2.0.2.0 - Production on Fri Feb 28 16:56:00 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Real Application Clusters option
JServer Release 9.2.0.2.0 - Production
SQL> SQL>
File created.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -
Production
With the Real Application Clusters option
JServer Release 9.2.0.2.0 - Production
Copying configuration files ....
CONVEX info: Collecting database info ...
===========================================
CONVEX info: Database info (after conversion):
===========================================
Use undo tablespace.
Number of log groups per thread: 4
Total Number of log groups in the database: 8
Number of log members per group: 2
Log size : 100M
Total number of threads: 2
==============================
CONVEX info:Starting after-conversion test .......................
OCC_ORACLE_BASE=/dgold/oracle
ORACLE_BASE=/dgold/oracle
OCC_CM_ORACLE_BASE=/oracm/oracle
OCC_ORACLE_HOME=/dgold/oracle/product/920
ORACLE_HOME=/dgold/oracle/product/920
OCC_CM_ORACLE_HOME=/dgold/oracle/product/920
OCC_ORACLE_OWNER_USER=ordgold
OCC_ORACLE_BASE_GIT=/dgold
OCC_ORACLE_DBA_USER_HOME=/home/ordgold
ORACLE_DOC=/dgold/oracle/product/920/doc
OCC_ORACLE_OWNER_GROUP=dbdgold
ORACLE_SID=DGOLD
OCC_ORACLE_DBA_GROUP=dbdgold
OCC_ORACLE_DBA_USER=ordgold
SQL*Plus: Release 9.2.0.2.0 - Production on Fri Feb 28 16:56:36 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Real Application Clusters option
JServer Release 9.2.0.2.0 - Production
SQL> Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -
Production
With the Real Application Clusters option
JServer Release 9.2.0.2.0 - Production
\nStarting up the database (DGOLD1) on lnxcom3.us.oracle.com ...
SQL*Plus: Release 9.2.0.2.0 - Production on Fri Feb 28 15:55:03 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 252776600 bytes
Fixed Size 450712 bytes
Variable Size 218103808 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -
Production
With the Real Application Clusters option
JServer Release 9.2.0.2.0 - Production
Starting up listener (LISTENER_DGOLD) on lnxcom3.us.oracle.com ...
LSNRCTL for Linux: Version 9.2.0.2.0 - Production on 28-FEB-2003 16:00:39
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /dgold/oracle/product/920/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.2.0 - Production
System parameter file is /dgold/oracle/product/920/network/admin/listener.ora
Log messages written to /dgold/oracle/product/920/network/log/listener_dgold.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lnxcom3.us.oracle.com)(PORT=10650)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER_DGOLD
Version TNSLSNR for Linux: Version 9.2.0.2.0 - Production
Start Date 28-FEB-2003 16:00:41
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /dgold/oracle/product/920/network/admin/listener.ora
Listener Log File /dgold/oracle/product/920/network/log/listener
_dgold.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lnxcom3.us.oracle.com)(PORT=10650)))
Services Summary...
Service "DGOLD.us.oracle.com" has 3 instance(s).
Instance "DGOLD", status UNKNOWN, has 1 handler(s) for this service...
Instance "DGOLD1", status UNKNOWN, has 1 handler(s) for this service...
Instance "DGOLD2", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
---------------------------------------------------------------
ordgold 11336 1 0 15:55 ? 00:00:00 ora_pmon_DGOLD1
ordgold 11338 1 0 15:55 ? 00:00:00 ora_diag_DGOLD1
ordgold 11342 1 0 15:55 ? 00:00:00 ora_lmon_DGOLD1
ordgold 11344 1 0 15:55 ? 00:00:00 ora_lmd0_DGOLD1
ordgold 11346 1 0 15:55 ? 00:00:00 ora_lms0_DGOLD1
ordgold 11348 1 0 15:55 ? 00:00:00 ora_lms1_DGOLD1
ordgold 11350 1 0 15:55 ? 00:00:00 ora_dbw0_DGOLD1
ordgold 11352 1 0 15:55 ? 00:00:00 ora_lgwr_DGOLD1
ordgold 11354 1 0 15:55 ? 00:00:00 ora_ckpt_DGOLD1
ordgold 11356 1 0 15:55 ? 00:00:00 ora_smon_DGOLD1
ordgold 11358 1 0 15:55 ? 00:00:00 ora_reco_DGOLD1
ordgold 11360 1 0 15:55 ? 00:00:00 ora_cjq0_DGOLD1
ordgold 11364 1 0 15:55 ? 00:00:00 ora_s000_DGOLD1
ordgold 11366 1 0 15:55 ? 00:00:00 ora_d000_DGOLD1
ordgold 11368 1 0 15:55 ? 00:00:00 ora_arc0_DGOLD1
ordgold 11370 1 0 15:55 ? 00:00:00 ora_arc1_DGOLD1
ordgold 11403 1 0 15:59 ? 00:00:00 ora_lck0_DGOLD1
---------------------------------------------------------------
\nStarting up the database (DGOLD2) on lnxcom4.us.oracle.com ...
SQL*Plus: Release 9.2.0.2.0 - Production on Fri Feb 28 17:02:52 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to an idle instance.
SQL> ORACLE instance started.
Total System Global Area 252776600 bytes
Fixed Size 450712 bytes
Variable Size 218103808 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -
Production
With the Real Application Clusters option
JServer Release 9.2.0.2.0 - Production
Starting up listener (LISTENER_DGOLD) on lnxcom4.us.oracle.com ...
LSNRCTL for Linux: Version 9.2.0.2.0 - Production on 28-FEB-2003 17:05:01
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Starting /dgold/oracle/product/920/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 9.2.0.2.0 - Production
System parameter file is /dgold/oracle/product/920/network/admin/listener.ora
Log messages written to /dgold/oracle/product/920/network/log/listener_dgold.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lnxcom4.us.oracle.com)(PORT=10650)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER_DGOLD
Version TNSLSNR for Linux: Version 9.2.0.2.0 - Production
Start Date 28-FEB-2003 17:05:01
Uptime 0 days 0 hr. 0 min. 5 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /dgold/oracle/product/920/network/admin/listener.ora
Listener Log File /dgold/oracle/product/920/network/log/listener
_dgold.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=lnxcom4.us.oracle.com)(PORT=10650)))
Services Summary...
Service "DGOLD.us.oracle.com" has 3 instance(s).
Instance "DGOLD", status UNKNOWN, has 1 handler(s) for this service...
Instance "DGOLD1", status UNKNOWN, has 1 handler(s) for this service...
Instance "DGOLD2", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
---------------------------------------------------------------
oracle 26586 26482 0 15:26 pts/8 00:00:00 vi initDGOLD2.ora
ordgold 26142 1 0 17:02 ? 00:00:00 ora_pmon_DGOLD2
ordgold 26144 1 0 17:02 ? 00:00:00 ora_diag_DGOLD2
ordgold 26148 1 0 17:02 ? 00:00:00 ora_lmon_DGOLD2
ordgold 26150 1 0 17:02 ? 00:00:00 ora_lmd0_DGOLD2
ordgold 26152 1 0 17:02 ? 00:00:00 ora_lms0_DGOLD2
ordgold 26154 1 0 17:02 ? 00:00:00 ora_lms1_DGOLD2
ordgold 26156 1 0 17:02 ? 00:00:00 ora_dbw0_DGOLD2
ordgold 26158 1 0 17:02 ? 00:00:00 ora_lgwr_DGOLD2
ordgold 26160 1 0 17:02 ? 00:00:00 ora_ckpt_DGOLD2
ordgold 26162 1 0 17:02 ? 00:00:00 ora_smon_DGOLD2
ordgold 26164 1 0 17:02 ? 00:00:00 ora_reco_DGOLD2
ordgold 26166 1 0 17:02 ? 00:00:00 ora_cjq0_DGOLD2
ordgold 26170 1 0 17:02 ? 00:00:00 ora_s000_DGOLD2
ordgold 26172 1 0 17:02 ? 00:00:00 ora_d000_DGOLD2
ordgold 26174 1 0 17:02 ? 00:00:00 ora_arc0_DGOLD2
ordgold 26176 1 0 17:02 ? 00:00:00 ora_arc1_DGOLD2
ordgold 26195 1 0 17:03 ? 00:00:00 ora_lck0_DGOLD2
---------------------------------------------------------------
tnsping DGOLD1 on lnxcom4.us.oracle.com ...
TNS Ping Utility for Linux: Version 9.2.0.2.0 - Production on 28-FEB-2003
17:05:21
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/dgold/oracle/product/920/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=lnxcom3)(PORT=10650)) (CONNECT_DATA=(SID=DGOLD1)))
OK (0 msec)
tnsping DGOLD2 on lnxcom4.us.oracle.com ...
TNS Ping Utility for Linux: Version 9.2.0.2.0 - Production on 28-FEB-2003
17:05:21
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Used parameter files:
/dgold/oracle/product/920/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=lnxcom4)(PORT=10650)) (CONNECT_DATA=(SID=DGOLD2)))
OK (10 msec)
ocheck: info: executing "postconf" check (RAC)
ocheck 3.7b (library C313b/L35a) 28-Feb-2003 17:05:31 PST
system: lnxcom4.us.oracle.com (DGOLD) RAC "postconf" check
Check Value Expected Status
Oracle services
ORACLE_HOME variable set set pass
-- ORACLE_HOME = /dgold/oracle/product/920
ORACLE_SID variable set set pass
-- ORACLE_SID = DGOLD2
Valid ORACLE_HOME configured configured pass
Oracle Listener running running pass
TNS ping (DGOLD) succeeded succeeded pass
SQL*Plus connection succeeded succeeded pass
Global Services Daemon (GSD) running running pass
Active instance check rac enabled (2) rac enabled pass
-- instances: (lnxcom3.us.oracle.com:DGOLD1 lnxcom4.us.oracle.com:DGOLD2)
End of Report
ocheck: info: completed RAC "postconf" check
\nShutting down the database (DGOLD1) on lnxcom3.us.oracle.com ...
SQL*Plus: Release 9.2.0.2.0 - Production on Fri Feb 28 16:04:06 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Real Application Clusters option
JServer Release 9.2.0.2.0 - Production
SQL> Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -
Production
With the Real Application Clusters option
JServer Release 9.2.0.2.0 - Production
Stopping listener (LISTENER_DGOLD) on lnxcom3.us.oracle.com ...
LSNRCTL for Linux: Version 9.2.0.2.0 - Production on 28-FEB-2003 16:05:35
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
The command completed successfully
\nShutting down the database (DGOLD2) on lnxcom4.us.oracle.com ...
SQL*Plus: Release 9.2.0.2.0 - Production on Fri Feb 28 17:07:22 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.2.0 - Production
With the Real Application Clusters option
JServer Release 9.2.0.2.0 - Production
SQL> Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 -
Production
With the Real Application Clusters option
JServer Release 9.2.0.2.0 - Production
Stopping listener (LISTENER_DGOLD) on lnxcom4.us.oracle.com ...
LSNRCTL for Linux: Version 9.2.0.2.0 - Production on 28-FEB-2003 17:07:28
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
The command completed successfully
Database Instances in the Cluster Configuration :
lnxcom3.us.oracle.com DGOLD1 /dgold/oracle/product/920
lnxcom4.us.oracle.com DGOLD2 /dgold/oracle/product/920
CONVEX: info: Database DGOLD successfully verified for conversion
-------------------------------------------------
The followings are added to your RAC database :
Control file:
MAXINSTANCES=63
MAXLOGMEMBERS=5
MAXLOGFILES=255
MAXDATAFILES=200
RAC Configuration (srvctl):
Database: DGOLD
Instance: DGOLD1 Node: lnxcom3
Instance: DGOLD2 Node: lnxcom4
Log file:
Thread: 2 Log Group: 5 Members: 2
Thread: 2 Log Group: 6 Members: 2
Thread: 2 Log Group: 7 Members: 2
Thread: 2 Log Group: 8 Members: 2
undo tablespace UNDOTS1 :
Location: /dgold/oradata/data01
Datafiles: UNDOTS_1_0
Size: 419430400 bytes
undo tablespace UNDOTS2 :
Location: /dgold/oradata/data01
Datafiles: UNDOTS_2_0
Size: 419430400 bytes
Listener Name (listener.ora): LISTENER_DGOLD
Services (tnsnames.ora): DGOLD and DGOLD[1-2]
-------------------------------------------------
CONVEX scripts: /dgold/oracle/admin/convex_scripts/DGOLD
The log for CONVEX can be found at /var/tmp/convexlog/convex.log
|
 Copyright © 2002, 2003 Oracle Corporation All rights reserved |
|