Amazon Partner

Tuesday 25 May 2010

Disable / Enable Database Vault 11g


To Disable or Enable Database Vault you need to stop the oracle home and related process before hand.


Disable Oracle Database Vault as follows:





  • UNIX: 
    $ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk dv_off ioracle


  • Windows: In the ORACLE_BASE\ORACLE_HOME\bin directory, rename the oradvll.dll file to another name, such as oradvll.dll.dbl.




Enable Oracle Database Vault as follows:




  • UNIX: Run the following commands. The make command enables both Oracle Database Vault (dv_on) and Oracle Label Security (lbac_on). You must have Oracle Label Security enabled before you can use Database Vault. 

    $ cd $ORACLE_HOME/rdbms/lib
$ make -f ins_rdbms.mk dv_on lbac_on ioracle

    • 

  • Windows: In the ORACLE_BASE\ORACLE_HOME\bin directory, rename the backed up copy of the oradvll.dll file (for example, oradv11.dll.dbl) tooradvll.dll. Ensure that the name of the Oracle Label Security executable is oralbacll.dll (and not oralbacll.dll.dbl or some other backup name). You must have Oracle Label Security enabled before you can use Oracle Database Vault.
    • 











Posted by



at





No comments:
  









































Grid Control 11.1.0.1 Administration Start/Stop










Grid Control 11.1. Released Last month, Struggled to find the right instruction to start and stop the environment, Following Steps can be used to start/Stop grid control 11.1.0.1 





Start Sequence:

1. Start Listeners <= Start all the listeners

2. Start database <= start the database

3. Start OMS <= This will start WebTier and OMS

   

4. Start Agent <= Start agent



Stop grid control : Stop sequence will be opposite to start.

1. Stop agent

2. Stop OMS

3. Stop database

4. Stop Listeners





:::::START ::::

1. Start Listeners

$ . oraenv

ORACLE_SID = [oracle] ? gcdb01

The Oracle base for ORACLE_HOME=/u01/app/product/11.2.0/dbhome_1 is /u01/app/oracle





lsnrctl start 



2. Start Database

 $ . oraenv

ORACLE_SID = [oracle] ? gcdb01

The Oracle base for ORACLE_HOME=/u01/app/product/11.2.0/dbhome_1 is /u01/app/oracle

$ sqlplus "/ as sysdba"

SQL > startup



3. Start OMS 



$ . oraenv

 ORACLE_SID = [gcdb01] ? oms11g

 The Oracle base for ORACLE_HOME=/u01/app/product/Middleware/oms11g is /u01/app/oracle



$ $ORACLE_HOME/bin/emctl start oms 












$ORACLE_HOME/bin/emctl status oms -details

Oracle Enterprise Manager 11g Release 1 Grid Control

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

Enter Enterprise Manager Root (SYSMAN) Password :>

Console Server Host : 254739-andb3.kk.local

HTTP Console Port   : 7788

HTTPS Console Port  : 7799

HTTP Upload Port    : 4889

HTTPS Upload Port   : 4900

OMS is not configured with SLB or virtual hostname

Agent Upload is locked.

OMS Console is locked.

Active CA ID: 1




4. Start agent

 $ . oraenv

 ORACLE_SID = [oms11g] ? agent11g

 The Oracle base for ORACLE_HOME=/u01/app/product/Middleware/agent11g is /u01/app/oracle





 

$ $ORACLE_HOME/bin/emctl start agent  

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



:::::STOP SEQUENCE ::::



1. Stop agent

 $ . oraenv

 ORACLE_SID = [oms11g] ? agent11g

 The Oracle base for ORACLE_HOME=/u01/app/product/Middleware/agent11g is /u01/app/oracle



 $ $ORACLE_HOME/bin/emctl stop agent



Oracle Enterprise Manager 11g Release 1 Grid Control 11.1.0.1.0

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

Stopping agent ... stopped.









2. Stop OMS Components



$ . oraenv

 ORACLE_SID = [gcdb01] ? oms11g

 The Oracle base for ORACLE_HOME=/u01/app/product/Middleware/oms11g is /u01/app/oracle



 $ $ORACLE_HOME/bin/emctl stop oms  -all










Oracle Enterprise Manager 11g Release 1 Grid Control




Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

Stopping WebTier...

WebTier Successfully Stopped

Stopping Oracle Management Server...

Error Occurred: Error during stop oms. Please check error and log files





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

/u01/app/product/gc_inst/em/EMGC_OMS1/sysman/log/emctl.log

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








2010-05-25 08:58:45,110 [Thread-1] INFO  wls.OMSController run.1094 - Failed to stop admin server
2010-05-25 08:58:45,114 [Thread-1] INFO  wls.OMSController run.1094 - 
2010-05-25 08:58:45,115 [Thread-1] INFO  wls.OMSController run.1094 - _END_
2010-05-25 08:58:45,115 [Thread-2] INFO  wls.OMSController run.1094 - _END_
2010-05-25 08:58:45,149 [Main Thread] INFO  wls.OMSController processCmd.988 - wlst process is finished
2010-05-25 08:58:45,150 [Main Thread] INFO  wls.OMSController processCmd.990 - wlst process exited with code 125
2010-05-25 08:58:45,151 [Main Thread] INFO  wls.OMSController processCmd.992 - wlst outstream joined
2010-05-25 08:58:45,151 [Main Thread] INFO  wls.OMSController processCmd.994 - wlst errstream joined
2010-05-25 08:58:45,152 [Main Thread] ERROR wls.OMSController main.258 - OMSController failed for stop oms
2010-05-25 08:58:45,154 [Main Thread] ERROR wls.OMSController main.259 - OMSController Error: Error during stop oms. Please check error and log files
java.lang.Exception: Error during stop oms. Please check error and log files
        at oracle.sysman.emctl.wls.OMSController.stopOMS(OMSController.java:812)
        at oracle.sysman.emctl.wls.OMSController.main(OMSController.java:240)
------------------------------------------------------------------------------------





  3. Stop Database

 $ . oraenv

 ORACLE_SID = [oracle] ? gcdb01

 The Oracle base for ORACLE_HOME=/u01/app/product/11.2.0/dbhome_1 is /u01/app/oracle

$ sqlplus "/ as sysdba"





SQL*Plus: Release 11.2.0.1.0 Production on Tue May 25 09:02:30 2010

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:

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

With the Partitioning, OLAP, Data Mining and Real Application Testing options



SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options











  

4. Stop Listeners

 $ . oraenv

ORACLE_SID = [oracle] ? gcdb01

The Oracle base for ORACLE_HOME=/u01/app/product/11.2.0/dbhome_1 is /u01/app/oracle

  $ORACLE_HOME/bin/lsnrctl stop LISTENER_APP





LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 25-MAY-2010 09:04:58

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=254739-andb3.kkj.local)(PORT=61902)))

The command completed successfully





















Posted by



at





2 comments:
  

































        

      









Subscribe to:
Posts (Atom)