Windows DBConsole internal stop. No OC4J admin passwd hence hard stop

 

Enterprise manager cannot be started. The status shows dbconsole is already started:

C:\>emctl status dbconsole

Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

https://JDEORA01:5500/em/console/aboutApplication

Oracle Enterprise Manager 11g is running.

------------------------------------------------------------------

Logs are generated in directory C:\APP\ORACLE\product\11.2.0\se1/jdeora01_e1prod/sysman/log

Install EM grid 11.1.0.1.0 on Linux

• Software

Downloads the following software:

Enterprise Linux Release 5 Update 5 for x86_64 (64 Bit) - DVD (3.3G)

Java SE Development Kit 6u18 (76M)

Oracle Database 11g Release 2 for Linux 64-bit (2G)

opatch - Latest version (26M)

Oracle WebLogic Server 11gR1 (10.3.2) - Package Installer (Generic) (1G)

(There’s a known issue with installing Enterprise Grid Control on Weblogic 10.3.3)

Enterprise Manager Grid Control (4.1G)

Manually configure the Oracle EM dbconsole

To Create EM Dbconsole:

$ emca -repos create
$ emca -config dbcontrol db

or$emca -config dbcontrol db -repos create

Toad hangs when retrieving User Script 

When using the Schema Browser, user selects select a User and the User Script tab. Toad hangs (or taking a long time) on a 10g db. When user uses 9.2.0.5 database, User script works as it should.

Does not appear to matter which user is selected . Toad does not return script and it hangs. Changing the Optimize hint does not address issue.

Also, right-clicking a user then clicking Create Script does not work no matter to File, to Screen, or to Clipboard.

Cannot connect to database from OBIEE 2.4 BI Admin Tool

If you have connection issue, modify bi_init.bat under BI install folder\oraclebi\orahome\bifoundation\server\bin, replace all ORACLE_HOME to OBIEE_HOME, and add new ORACLE_HOME for the actual oracle installation path:

@echo off
set OBIEE_HOME=C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orahome
set ORACLE_HOME=D:\oracle\product\11.2.0.3\owb
set ORACLE_INSTANCE=C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orainst
set ORACLE_BI_APPLICATION=coreapplication
rem call %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\%ORACLE_BI_APPLICATION%\setup\user.cmd
if NOT "%1" == "" set COMPONENT_NAME=%1
set PATH=%OBIEE_HOME%\bifoundation\server\bin;%OBIEE_HOME%\bifoundation\web\bin;%OBIEE_HOME%\bin;C:\Program Files\Oracle Business Intelligence Enterprise Edition Plus Client\jre\bin;%ORACLE_HOME\bin%;%windir%;%windir%\system32;%PATH%
if NOT "%2" == "" %2

Oracle Workflow ORA-24247

If you see the following errors:

ORA-24247:Network access denied by access control list(ACL) ORA-06512 at......

 

ORA-29532 when starting OWB Service

Run $ORACLE_HOME/owb/rtp/sql/start_service.sql with OWBSYS user.

If you have the following error:

Not Available

Diagnostics:

service startup failure using command "$ORACLE_HOME/owb/b

in/unix/run_service.sh -manual 1 $ORACLE_HOME OWBSYS 10.8

4.80.186:1521:bidev" reason ORA-29532: Java call terminated by uncaught Java ex

ception: java.io.IOException: service early exit: code=1 : err=JVMJ9VM015W Init

ialization error for library j9gc23(2): Failed to instantiate heap; 768M reques

ted

Could not create the Java virtual machine.

: out=

please invoke [owbhome]/owb/rtp/sql/service_doctor.sql for more information

PL/SQL procedure successfully completed.