Monday, 29 August 2016

Configure EM (Enterprise Manager ) in Oracle 11g

Microsoft Windows [Version 6.1.7600]
Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

C:\Users\Administrator>emctl status dbconsole
Environment variable ORACLE_SID not defined. Please define it.

C:\Users\Administrator>set ORACLE_SID=ORCL

C:\Users\Administrator>emctl status dbconsole
OC4J Configuration issue. C:\oracle\product\10.2.0\db_1/oc4j/j2ee/OC4J_DBConsole
_192.168.4.19_ORCL not found.

C:\Users\Administrator>emca -config dbcontrol db

STARTED EMCA at Mar 31, 2016 8:05:17 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: ORCL
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for DBSNMP user: Invalid username/password.
Password for DBSNMP user:
Password for SYSMAN 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 ................ C:\oracle\product\10.2.0\db_1

Database hostname ................ <your PC IP Address>
Listener port number ................ 1521
Database SID ................ ORCL
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: yes
Mar 31, 2016 8:07:45 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\oracle\product\10.2.0\db_1\cfgtoollog
s\emca\orcl\emca_2016-03-31_08-05-17-AM.log.
Mar 31, 2016 8:07:56 AM oracle.sysman.emcp.util.PlatformInterface executeCommand

WARNING: Error executing CMD /C C:\oracle\product\10.2.0\db_1\bin\emctl.bat depl
oy dbconsole C:\oracle\product\10.2.0\db_1\192.168.4.19_ORCL <your PC IP Address>:3938 <your PC IP Address> ORCL
Mar 31, 2016 8:07:56 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Error instantiating EM configuration files
Refer to the log file at C:\oracle\product\10.2.0\db_1\cfgtoollogs\emca\orcl\emc
a_2016-03-31_08-05-17-AM.log for more details.
Could not complete the configuration. Refer to the log file at C:\oracle\product
\10.2.0\db_1\cfgtoollogs\emca\orcl\emca_2016-03-31_08-05-17-AM.log for more deta
ils.

C:\Users\Administrator>emctl stop dbconsole
Unable to determine local host from URL REPOSITORY_URL=http://<your PC IP Address>:%EM_U
PLOAD_PORT%/em/upload/
 .

C:\Users\Administrator>emctl start dbconsole
Unable to determine local host from URL REPOSITORY_URL=http://<your PC IP Address>:%EM_U
PLOAD_PORT%/em/upload/
 .

C:\Users\Administrator>emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Mar 31, 2016 8:10:46 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: ORCL
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: yes
Mar 31, 2016 8:11:01 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\oracle\product\10.2.0\db_1\cfgtoollog
s\emca\orcl\emca_2016-03-31_08-10-46-AM.log.
Mar 31, 2016 8:11:04 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Mar 31, 2016 8:11:15 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Mar 31, 2016 8:11:55 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Mar 31, 2016 8:11:55 AM

C:\Users\Administrator>emctl stop dbconsole
OC4J Configuration issue. C:\oracle\product\10.2.0\db_1/oc4j/j2ee/OC4J_DBConsole
_<your PC IP Address>_ORCL not found.

C:\Users\Administrator>emca -config dbcontrol db -repos create

STARTED EMCA at Mar 31, 2016 8:20:58 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: ORCL
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN 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 ................ C:\oracle\product\10.2.0\db_1

Database hostname ................ <your PC IP Address>
Listener port number ................ 1521
Database SID ................ ORCL
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: yes
Mar 31, 2016 8:22:06 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\oracle\product\10.2.0\db_1\cfgtoollog
s\emca\orcl\emca_2016-03-31_08-20-58-AM.log.
Mar 31, 2016 8:22:14 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Mar 31, 2016 8:23:33 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Mar 31, 2016 8:23:37 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Mar 31, 2016 8:24:17 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Mar 31, 2016 8:24:17 AM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://<your PC IP Address>:5500/em <<<<<<
<<<<<
Enterprise Manager configuration completed successfully
FINISHED EMCA at Mar 31, 2016 8:24:17 AM

C:\Users\Administrator>emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Mar 31, 2016 8:24:28 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Enter the following information:
Database SID: ORCL
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:
Password for SYSMAN user:
Do you wish to continue? [yes(Y)/no(N)]: yes
Mar 31, 2016 8:24:41 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at C:\oracle\product\10.2.0\db_1\cfgtoollog
s\emca\orcl\emca_2016-03-31_08-24-28-AM.log.
Mar 31, 2016 8:24:44 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Mar 31, 2016 8:25:25 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Mar 31, 2016 8:26:01 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Mar 31, 2016 8:26:02 AM

C:\Users\Administrator>

Performance Tuning Interview Questions and Answers

performance tuning questions and solutions 1. A tablespace has a table with 30 extents in it. Is this bad? Why or why not? Expected answ...