• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5668
  • Last Modified:

dbconsole

C:\oracle\product\10.2.0\db_1\BIN>emctl start dbconsole
Environment variable ORACLE_SID not defined. Please define it.

C:\oracle\product\10.2.0\db_1\BIN>emctl start dbconsole india
Environment variable ORACLE_SID not defined. Please define it.

C:\oracle\product\10.2.0\db_1\BIN>set oracle_sid=india

C:\oracle\product\10.2.0\db_1\BIN>emctl start dbconsole
OC4J Configuration issue. C:\oracle\product\10.2.0\db_1/oc4j/j2ee/OC4J_DBConsole
_admin-44b005214_india not found.

C:\oracle\product\10.2.0\db_1\BIN>

what is the reason not found How can I make it
0
dbaseek
Asked:
dbaseek
  • 5
  • 3
1 Solution
 
TolomirAdministratorCommented:
You have to set ORACLE_SID to the database you want to use.

Is that really "india"??

Normally you get that message when dbconsole (OEM) is not configured with a database and/or you used the wrong SID.

0
 
TolomirAdministratorCommented:
Starting dbconsole in Windows

In Windows, in addition to using the command line, you can start the dbconsole process as a service.

To start dbconsole as a service:

   1.      From the main menu, click Start, Control Panel, Administrative Tools, Services. The Services page appears.
   2.      Oracle services begin with Oracle. The dbconsole service is listed as OracleDBConsoleORACLE_SID, where ORACLE_SID is your SID. The status of this process is listed in the Status column, either Started or Stopped.

Double click the service. The property page appears.

   3.      In the properties page, ensure that the Startup Type is either Manual or Automatic and not Disabled. Click Start, if the process is not already started. Click OK.

You can also use the Services page to stop the process.
0
 
dbaseekAuthor Commented:
regarding this
what is wrong
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
dbaseekAuthor Commented:

C:\Documents and Settings\Administrator>set oracle_sid=india

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Aug 4 22:35:09 2007

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

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1247900 bytes
Variable Size              79693156 bytes
Database Buffers           83886080 bytes
Redo Buffers                2945024 bytes
SQL> select name from v$database;
select name from v$database
                 *
ERROR at line 1:
ORA-01507: database not mounted


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01507: database not mounted


SQL> startup mount
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown immediate;
ORA-01507: database not mounted


ORACLE instance shut down.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1247900 bytes
Variable Size              79693156 bytes
Database Buffers           83886080 bytes
Redo Buffers                2945024 bytes
Database mounted.
SQL> select name from v$database;

NAME
---------
INDIA

SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1247900 bytes
Variable Size              79693156 bytes
Database Buffers           83886080 bytes
Redo Buffers                2945024 bytes
Database mounted.
SQL> alter database open;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Pr
oduction
With the Partitioning, OLAP and Data Mining options

C:\Documents and Settings\Administrator>lsnrctl stop

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 04-AUG-2007 22:40
:02

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   32-bit Windows Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.111)(PORT=2000
)))
TNS-12543: TNS:destination host unreachable
 TNS-12560: TNS:protocol adapter error
  TNS-00513: Destination host unreachable
   32-bit Windows Error: 51: Unknown error

C:\Documents and Settings\Administrator>
0
 
TolomirAdministratorCommented:
Why don't just just

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup;


and

c:\lsnrctl start

These listener error messages are no problem, they just say

"the listener is not started" maybe a bit too dramatically...

Tolomir
0
 
TolomirAdministratorCommented:
Btw. have you configured the database during creation with dbcontrol in the database configuration assistent (dbca)?

I now know there is this india DB, so it could be the reason you missed that step, that dbconsole will not start.
0
 
TolomirAdministratorCommented:
Here is how to setup dbconsole manually

Manually configure the Oracle 10g EM dbconsole
http://www.akadia.com/services/ora_dbconsole.html

0
 
dbaseekAuthor Commented:
Thanks
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now