how to Fixed: windows could not start the oracledbconsole on local computer error code 2 or OracledbConsole does not start problem..pls watch full video & solved ur problem by urself. if face any problem; pls comments I'll try to level best to solve related problems; also u can follow below desc...........
Find & follow on Social media:
please subscribe my channel: https://www.youtube.com/c/dhamaliyadotnet
for more Tips & tricks: https://www.youtube.com/playlist?list=PLAmEKK-wglL13Vhb9gvLHFih7LkXPkzbv
Following is the Solution which worked well for me.
Step 1: Go to dbhome --- hostname_SID --- Sysman --- Config --- open emd.properties in notepad and set the value agentTZRegion=+06:00 to the value of your timezone and click save. You can also do it using export and time zone reset commands.
Step 2: ALTER DATABASE SET TIME_ZONE='+06:00'; according to your time zone. You can check DB TIME Zone using " select dbtimezone from dual ; ".
Step 3: In step 2 if you get the error "ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH
LOCAL TIME ZONE columns" then please FOLLOW following steps
SQL--- select count (*) from dba_tab_columns
2 where data_type like 'TIMESTAMP%WITH LOCAL TIME ZONE' ;
In this case there is only one table. The owner and name can be determined by:
SQL--- select owner, table_name from dba_tab_columns
2 where data_type like 'TIMESTAMP%WITH LOCAL TIME ZONE';
SQL--- desc oe.orders ;
Name Null? Type
-------- ORDER_ID NOT NULL NUMBER(12)
ORDER_DATE NOT NULL TIMESTAMP(6) WITH LOCAL TIME ZONE
CUSTOMER_ID NOT NULL NUMBER(6)
This oe.orders is just a table in the example schema of OE so this colums can be dropped. So please dont install sample schemas if you dont need them.
SQL--- alter table OE.ORDERS drop column ORDER_DATE ;
Now the Time Zone can be altered using above command.
Step 4: Also check the value of " SELECT SESSIONTIMEZONE FROM DUAL; " and if the value differs from os time zone, db time zone , emd.properties / agent time zone then also set it according to your timezone but I believe it always gives the OS time zone.
Step 5: Stop and Restart all Services and check that Oracle DBConsole service is running or not and if not running then start from command prompt " emctl start dbconsole" .