woensdag 12 januari 2011

Set Global User Inactivity Timeout (GITO) SSO

cd $ORACLE_HOME/sso/admin/plsql/sso

sqlplus orasso/xxxx@infra_db

SQL> @ssogito
=============================================
SSO Server Inactivity Timeout Configuration
=============================================
Timeout          : DISABLED
Cookie name      : OSSO_USER_CTX
Cookie domain    : .domain.com
Inactivity period: 15 minutes
Encryption key   : G2N3011T68FD152W
-------------------------------------------
To disable timeout set inactivity period
to 0, (zero)
Press return key twice if you do not want
to change timeout configuration.

PL/SQL procedure successfully completed.

Enter value for timeout_cookie_domain: .domain.com
Enter value for inactivity_period: 15
Timout                   : ENABLED
New timeout cookie domain: .domain.com
New inactivity period    : 15 minutes

PL/SQL procedure successfully completed.

No errors.

SQL>exit

Restart HTTP Server and SSO Server:

opmnctl restartproc process-type=OC4J_SECURITY
opmnctl restartproc process-type=HTTP_Server


Check "OssoIdleTimeout" parameter in mod_osso.conf on the MID TIERS.
To activate gito, the parameter must be set to "on".

vi $ORACLE_HOME/Apache/Apache/conf/mod_osso.conf


LoadModule osso_module libexec/mod_osso.so

<IfModule mod_osso.c>

   OssoIpCheck off
   OssoIdleTimeout on
#   OssoIdleTimeout off

...
..

</IfModule>


Restart the HTTP Server(s) of the MID TIER(S):


opmnctl restartproc process-type=HTTP_Server

maandag 3 januari 2011

Recreate EM Repository RDBMS 11g

db11genv-oracle@vm5oelr5 /u01/oracle/db/11.2.0/db_1/network/admin>

emca -config dbcontrol db -repos recreate

STARTED EMCA at Jan 3, 2011 1:53:51 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: testdb11g
Listener port number: 1521
Listener ORACLE_HOME [ /u01/oracle/db/11.2.0/db_1 ]:
Password for SYS user: 
Password for DBSNMP user: 
Password for SYSMAN user: 
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/oracle/db/11.2.0/db_1

Local hostname ................ vm5oelr5
Listener ORACLE_HOME ................ /u01/oracle/db/11.2.0/db_1
Listener port number ................ 1521
Database SID ................ testdb11g
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Jan 3, 2011 1:54:12 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/oracle/cfgtoollogs/emca/testdb11g/emca_2011_01_03_13_53_51.log.
Jan 3, 2011 1:54:13 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jan 3, 2011 1:57:00 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Jan 3, 2011 1:57:00 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jan 3, 2011 2:03:27 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Jan 3, 2011 2:03:37 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jan 3, 2011 2:05:09 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jan 3, 2011 2:05:14 PM oracle.sysman.emcp.util.DBControlUtil configureSoftwareLib
INFO: Software library configured successfully.
Jan 3, 2011 2:05:14 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Deploying Provisioning archives ...
Jan 3, 2011 2:05:55 PM oracle.sysman.emcp.EMDBPostConfig configureSoftwareLibrary
INFO: Provisioning archives deployed successfully.
Jan 3, 2011 2:05:55 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jan 3, 2011 2:06:43 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jan 3, 2011 2:06:43 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jan 3, 2011 2:08:22 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jan 3, 2011 2:08:22 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://vm5oelr5:5500/em <<<<<<<<<<<
Jan 3, 2011 2:08:28 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/oracle/db/11.2.0/db_1/vm5oelr5_testdb11g/sysman/config/emkey.ora.   Please ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jan 3, 2011 2:08:28 PM
db11genv-oracle@vm5oelr5 /u01/oracle/db/11.2.0/db_1/network/admin>