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
Welcome on luiksie.blogspot.com. Just a blog with pratical tips on Oracle rdbms, application server, etc
woensdag 12 januari 2011
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>
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>
Abonneren op:
Reacties (Atom)