MERCADOS FINANCIEROS

jueves, 29 de mayo de 2014

Improper Oracle Clusterware configuration found on this host

En Oracle 12C con VirtualBox

./roothas.pl
Using configuration parameter file: ./crsconfig_params
2014/05/29 11:30:37 CLSRSC-351: Improper Oracle Clusterware configuration found on this host

2014/05/29 11:30:37 CLSRSC-353: Run '/u01/app/oracle/product/12.1.0/grid/crs/install/roothas.pl -deconfig' to deconfigure existing failed configuration and then re-run 'root.sh
[root@localhost install]# pwd
/u01/app/oracle/product/12.1.0/grid/crs/install
[root@localhost install]# ./root
rootcrs.pl  roothas.pl 
[root@localhost install]# ./roothas.pl -deconfig -force
Using configuration parameter file: ./crsconfig_params
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Stop failed, or completed with errors.
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Delete failed, or completed with errors.
PROCL-26: Error while accessing the physical storage
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Stop failed, or completed with errors.
2014/05/29 11:34:06 CLSRSC-180: An error occurred while executing the command '/etc/init.d/ohasd deinstall' (error code -1)

Failure in execution (rc=-1, 0, Inappropriate ioctl for device) for command /etc/init.d/ohasd deinstall
2014/05/29 11:34:06 CLSRSC-337: Successfully deconfigured Oracle Restart stack

[root@localhost install]# pwd
/u01/app/oracle/product/12.1.0/grid/crs/install
[root@localhost install]# cd ..
[root@localhost crs]# cd ..
[root@localhost grid]# pwd
/u01/app/oracle/product/12.1.0/grid

[root@localhost grid]# ./root.sh
Performing root user operation for Oracle 12c

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/12.1.0/grid

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.
Using configuration parameter file: /u01/app/oracle/product/12.1.0/grid/crs/install/crsconfig_params
LOCAL ADD MODE
Creating OCR keys for user 'oracle', privgrp 'oinstall'..
Operation successful.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node localhost successfully pinned.
2014/05/29 11:34:39 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.conf'


localhost     2014/05/29 11:35:01     /u01/app/oracle/product/12.1.0/grid/cdata/localhost/backup_20140529_113501.olr
2014/05/29 11:38:00 CLSRSC-327: Successfully configured Oracle Grid Infrastructure for a Standalone Server


[root@localhost grid]#

En Oracle 11g

Improper Oracle Clusterware configuration found on this host posted Apr 14, 2011, 12:33 PM by
Sachchida Ojha   [ updated Apr 14, 2011, 12:36 PM ]
va-idb01:RPTDB:/u01/home/oracle $sudo /u01/app/oracle/product/11.2.0/grid/root.sh
Running Oracle 11g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file "dbhome" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]:
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]:
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) [n]:

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.sh script.
Now product-specific root actions will be performed.
2011-04-14 19:25:59: Checking for super user privileges
2011-04-14 19:25:59: User has super user privileges
2011-04-14 19:25:59: Parsing the host name
Using configuration parameter file: /u01/app/oracle/product/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
Improper Oracle Clusterware configuration found on this host
Deconfigure the existing cluster configuration before starting
to configure a new Clusterware
run '/u01/app/oracle/product/11.2.0/grid/crs/install/rootcrs.pl -deconfig'
to configure existing failed configuration and then rerun root.sh

va-idb01:RPTDB:/u01/home/oracle $/u01/app/oracle/product/11.2.0/grid/crs/install/rootcrs.pl -deconfig
2011-04-14 19:26:53: Parsing the host name
2011-04-14 19:26:53: Checking for super user privileges
You must be logged in as root to run this script.
Log in as root and rerun this script.
2011-04-14 19:26:53: Not running as authorized user
Insufficient privileges to execute this script

va-idb01:RPTDB:/u01/home/oracle $

From Root user

va-idb01:RPTDB:/u01/home/oracle $/u01/app/oracle/product/11.2.0/grid/crs/install/rootcrs.pl -deconfig
2011-04-14 19:27:08: Parsing the host name
2011-04-14 19:27:08: Checking for super user privileges
2011-04-14 19:27:08: User has super user privileges
Using configuration parameter file: /u01/app/oracle/product/11.2.0/grid/crs/install/crsconfig_params
Failure to execute: No such file or directory for command /u01/app/oracle/product/11.2.0/grid/bin/crsctl check cluster -n va-idb01
Failure to execute: No such file or directory for command /u01/app/oracle/product/11.2.0/grid/bin/crsctl check cluster -n va-idb01
Oracle Clusterware stack is not active on this node
Restart the clusterware stack (use /u01/app/oracle/product/11.2.0/grid/bin/crsctl start crs) and retry
Failed to verify resources

va-idb01:RPTDB:/u01/home/oracle $/u01/app/oracle/product/11.2.0/grid/crs/install/rootcrs.pl -deconfig -force
2011-04-14 19:31:17: Parsing the host name
2011-04-14 19:31:17: Checking for super user privileges
2011-04-14 19:31:17: User has super user privileges
Using configuration parameter file: /u01/app/oracle/product/11.2.0/grid/crs/install/crsconfig_params
Failure to execute: No such file or directory for command /u01/app/oracle/product/11.2.0/grid/bin/crsctl check cluster -n va-idb01
Failure to execute: No such file or directory for command /u01/app/oracle/product/11.2.0/grid/bin/crsctl check cluster -n va-idb01
Usage: srvctl 

lunes, 26 de mayo de 2014

Configuracion ASM Oracle 12C Oracle Linux 64 Bits

[root@localhost ~]# /etc/init.d/oracleasm configure
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver.  The following questions will determine whether the driver is
loaded on boot and what permissions it will have.  The current values
will be shown in brackets ('[]').  Hitting without typing an
answer will keep that current value.  Ctrl-C will abort.

Default user to own the driver interface []: oracle
Default group to own the driver interface []: dba
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]: y
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver:                     [  OK  ]
Scanning the system for Oracle ASMLib disks:               [  OK  ]
[root@localhost ~]#
[root@localhost ~]# fdisk -l

[root@localhost ~]# /etc/init.d/oracleasm createdisk DATA01 /dev/sdc1
Marking disk "DATA01" as an ASM disk:                      [  OK  ]
[root@localhost ~]# /etc/init.d/oracleasm createdisk FRA01 /dev/sdd1
Marking disk "FRA01" as an ASM disk:                       [  OK  ]
[root@localhost ~]# /etc/init.d/oracleasm listdisks
DATA01
FRA01
[root@localhost ~]#