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>
In this Blog you can learn Oracle 11g, 10g, 9i Database Administration and Oracle Developer Suit 6i, 10g, 11g Forms, reports Software Development.
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...
-
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...
-
1) How can you see the Current SCN number of the database? > Select current_scn from v$database; 2) How can you see the Current log...
-
SQL*Plus: Release 11.2.0.1.0 Production on Sun Sep 4 12:00:26 2016 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter user-n...