Modify the attribute AUTO_START to “always”

With Oracle 11.2 database auto start policy in the clusterware is restore, which means that clusterware will remember the last state of the database.  If the database was stopped normally then on the next restart of clusterware it won’t be started. Otherwise if the server crashes or by some reason the OS is rebooted then clusterware will start the database because last state was ONLINE (running).

hibernate.jdbc.fetch_size and hibernate.jdbc.batch_size

Two important settings for hibernate java application, affecting hibernate CRUD performance.
C = create, R = read, U = update, D = delete

Fetch Size determines when JDBC Statement read data, how many records are going to be read per fetch.
Recommend setting for Oralce JDBC application:
hibernate.jdbc.fetch_size 100
hibernate.jdbc.batch_size 25

Disable Microsoft Office Upload Center

For starters, if you don't want it, don't run Microsoft SharePoint Workspace 2010 (what used to be called Groove). Workspace also loads the Upload Center, even if you simply start it, then cancel before doing anything. It also sets some values in the Windows registry that cause Upload Center to load again every time you restart Windows.

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.