[root@soul01 ~]# /oracle/app/oracle/db_1/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /oracle/app/oracle/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The contents of "dbhome" have not changed. No need to overwrite.

The contents of "oraenv" have not changed. No need to overwrite.

The contents of "coraenv" have not changed. No need to overwrite.

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root script.

Now product-specific root actions will be performed.

Finished product-specific root actions.

[root@soul01 ~]#

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 536870912 bytes

Fixed Size 2097696 bytes

Variable Size 155192800 bytes

Database Buffers 373293056 bytes

Redo Buffers 6287360 bytes

Database mounted.

SQL> alter database noarchivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> archive log list;

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination +DATA

Oldest online log sequence 116

Current log sequence 117

SQL>

[Thread-246] [ 2013-12-12 14:50:11.402 CST ] [SQLPlusEngine.getCmmdParams:223] version > 112 true

[Thread-246] [ 2013-12-12 14:50:11.402 CST ] [SQLEngine.getEnvParams:555] Default NLS_LANG: AMERICAN_AMERICA.AL32UTF8

[Thread-246] [ 2013-12-12 14:50:11.402 CST ] [SQLEngine.getEnvParams:565] NLS_LANG: AMERICAN_AMERICA.AL32UTF8

[Thread-246] [ 2013-12-12 14:50:11.403 CST ] [SQLEngine.initialize:325] Execing SQLPLUS/SVRMGR process...

[Thread-246] [ 2013-12-12 14:50:11.419 CST ] [SQLEngine.initialize:362] m_bReaderStarted: false

[Thread-246] [ 2013-12-12 14:50:11.419 CST ] [SQLEngine.initialize:366] Starting Reader Thread...

[Thread-246] [ 2013-12-12 14:50:11.421 CST ] [SQLEngine.initialize:415] Waiting for m_bReaderStarted to be true

[Thread-786] [ 2013-12-12 14:50:11.497 CST ] [BasicStep.handleNonIgnorableError:430] oracle.sysman.assistants.util.UIMessageHandler@505fa26:messageHandler

[Thread-786] [ 2013-12-12 14:50:11.497 CST ] [BasicStep.handleNonIgnorableError:431] ORA-00823: Specified value of sga_target greater than sga_max_size

ORA-01078: failure in processing system parameters

:msg

[oracle@soul02 dbs]$ ls

hc_xysoul2.dat init.ora initxysoul.ora orapwxysoul2

[oracle@soul02 dbs]$ cat initxysoul.ora | grep sga

sga_max_size=734003200

sga_target=209715200

[oracle@soul02 dbs]$ cat initxysoul.ora | grep sga

sga_max_size=734003200

sga_target=624951296

[oracle@soul02 dbs]$

[oracle@soul01 dbs]$ crs_stat –t

Name Type Target State Host

------------------------------------------------------------

ora.CRS.dg ora....up.type ONLINE ONLINE soul01

ora.DATA.dg ora....up.type ONLINE ONLINE soul01

ora....ER.lsnr ora....er.type ONLINE ONLINE soul01

ora....N1.lsnr ora....er.type ONLINE ONLINE soul01

ora.asm ora.asm.type ONLINE ONLINE soul01

ora.cvu ora.cvu.type ONLINE ONLINE soul01

ora.gsd ora.gsd.type OFFLINE OFFLINE

ora....network ora....rk.type ONLINE ONLINE soul01

ora.oc4j ora.oc4j.type ONLINE ONLINE soul01

ora.ons ora.ons.type ONLINE ONLINE soul01

ora....ry.acfs ora....fs.type ONLINE ONLINE soul01

ora.scan1.vip ora....ip.type ONLINE ONLINE soul01

ora....SM1.asm application ONLINE ONLINE soul01

ora....01.lsnr application ONLINE ONLINE soul01

ora.soul01.gsd application OFFLINE OFFLINE

ora.soul01.ons application ONLINE ONLINE soul01

ora.soul01.vip ora....t1.type ONLINE ONLINE soul01

ora....SM2.asm application ONLINE ONLINE soul02

ora....02.lsnr application ONLINE ONLINE soul02

ora.soul02.gsd application OFFLINE OFFLINE

ora.soul02.ons application ONLINE ONLINE soul02

ora.soul02.vip ora....t1.type ONLINE ONLINE soul02

ora.xysoul.db ora....se.type ONLINE ONLINE soul01

SQL> select * from v$version;

BANNER    

--------------------------------------------------------------------------------

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

PL/SQL Release 11.2.0.4.0 - Production

CORE 11.2.0.4.0 Production

TNS for Linux: Version 11.2.0.4.0 - Production

NLSRTL Version 11.2.0.4.0 - Production

SQL> select COMP_NAME,VERSION,STATUS from dba_registry;

COMP_NAME VERSION STATUS

----------------------------------- --------------- ----------

OWB 11.2.0.4.0 VALID

Oracle Application Express 3.2.1.00.12 VALID

Oracle Enterprise Manager 11.2.0.4.0 VALID

OLAP Catalog 11.2.0.4.0 VALID

Spatial 11.2.0.4.0 VALID

Oracle Multimedia 11.2.0.4.0 VALID

Oracle XML Database 11.2.0.4.0 VALID

Oracle Text 11.2.0.4.0 VALID

Oracle Expression Filter 11.2.0.4.0 VALID

Oracle Rules Manager 11.2.0.4.0 VALID

Oracle Workspace Manager 11.2.0.4.0 VALID

Oracle Database Catalog Views 11.2.0.4.0 VALID

Oracle Database Packages and Types 11.2.0.4.0 VALID

JServer JAVA Virtual Machine 11.2.0.4.0 VALID

Oracle XDK 11.2.0.4.0 VALID

Oracle Database Java Packages 11.2.0.4.0 VALID

OLAP Analytic Workspace 11.2.0.4.0 VALID

Oracle OLAP API 11.2.0.4.0 VALID

Oracle Real Application Clusters 11.2.0.4.0 VALID

19 rows selected.

SQL>

[oracle@soul01 dbs]$ crsctl query crs activeversion

Oracle Clusterware active version on the cluster is [11.2.0.4.0]

[oracle@soul01 dbs]$ crsctl query crs softwareversion

Oracle Clusterware version on node [soul01] is [11.2.0.4.0]

[oracle@soul01 ContentsXML]$ pwd

/opt/oracle/product/10.2.0/oraInventory/ContentsXML

[oracle@soul01 ContentsXML]$ ls

comps.xml inventory.xml libs.xml

[oracle@soul01 ContentsXML]$

[oracle@soul01 10.2.0]$ ls

admin cfgtoollogs crs db_1 diag oraInventory

[oracle@soul01 10.2.0]$ pwd

/opt/oracle/product/10.2.0

[oracle@soul01 10.2.0]$