Experience11g

I was getting this error when I was trying to associate migration repository to an user. All the privileges were granted but still had the same error message which leaves us clueless.

I was hunting for a solution and found that the tablespace which was associated for this user was out of space. I resized the tablespace and tried again to create repository and wow, it worked.

I dont know why the error is not more meaningful here...

Regards,
Vishal

After installing 11g, I tried to start sql developer and saw below error message in the messages log at the bottom of screen.

"SEVERE: Error while registering Oracle JDBC Diagnosability MBean"

I could fix it by renaming "$ORACLE_HOME/jdbc/lib" to "$ORACLE_HOME/jdbc/lib$".
Restarted sql developer and do not see those messages anymore.

Hope this helps.
Regards,
Vishal

This is awesome for APEX lovers...

See below link for more details:

http://www.oracle.com/technology/obe/11gr1_db/install/apexinst/apexinst.htm

Received a warning from DBCA saying "Enterprise manager configuration failed due to following error - listener is not up. Start the listener and run EM configuration assistant again.

When tried to start the listener manually in windows services. Got below error:

Error 3 : The system can not find the path specified.

Checked listener service properties and found that the path to executable was

driveletter:\app\product\11.1.0\db_1\bin\tnslsnr

instead of

driveletter:\app\hostname\product\11.1.0\db_1\bin\tnslsnr

that means the hostname was not included in that.

Now to modify it:

Go to registry editor (use regedit)
then go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\OracleOraDb11g_home1TNSListener

Check value of ImagePath, modified it.

Successfully started the service.

To configure dbcontrol:
emca -config dbcontrol db

URL link for dbcontrol:
https://hostname:1158/em

Downloaded software from http://www.oracle.com/technology/software/products/database/index.html
File name is win32_11gR1_database_1013.zip
Unzipped it and navigated to find setup.exe at win32_11gR1_database_1013\database\

Selected "Advanced Installation" --> "Enterprise Edition"

Then specified the ORACLE_BASE and ORACLE_HOME locations...note by default the directory structure on windows for ORACLE_BASE is :\app\ and for ORACLE_HOME :\app\\product\11.1.0\db_1

When we select to create the starter (seed) database, we get a screen to configure it:

Under automatic memory management, from 11g onwards we dont have to specify sga_target and pga_aggregate_target separately. We just have to specify, how much amount of memory we want to allocate to that instance (SGA+PGA). Minimum is 256M. You can see that when you select "Enable automatic memory management" , memory for SGA and PGA is specified as AUTO. That means Oracle will decide how much memory to be allocated to these 2 memory components. When you deselect "Enable automatic memory management" you can see how much memory is actually allocated for these components. We will talk about memory_target parameter later in detail.

Under Security tab, you can disable the security settings. These security settings include enabling auditing and using a new default password profile.

You can select database character set(default, unicode, list of charactersets). I selected unicode.

You can enable "Oracle Configuraion Manager", this is to link your env with metalink so that the diagnostic data is collected and stored on metalink. (I did not select it)

.......Installation started.........

Global inventory: C:\program files\Oracle\Inventory
Local Inventory: $ORACLE_HOME\inventory

Received a warning from DBCA saying "Enterprise manager configuration failed due to following error - listener is not up. Start the listener and run EM configuration assistant again.

Clicked OK and the installation and db creation completed.
Next article we will discuss about the "EMCA warning" and how to resolve it?

Today I have finished installing 11.1.0.6.0 on my laptop. I am putting just the error message what I received while installation. Rest of the new things/enhancements will be discussed later as I go on exploring them in details.

While installing 11g Rel 1(11.1.0.6.0) "Basic Installation" prerequisite check of "Network configuration requirements" was failed saying the Microsoft loopback adapter has to be installed and made primary.

Error Message:
=============
Checking Network Configuration requirements ...

Check complete. The overall result of this check is: Failed <<<<
Problem: The install has detected that the primary IP address of the system is DHCP-assigned.
Recommendation: Oracle supports installations on systems with DHCP-assigned IP addresses; However, before you can do this, you must configure the Microsoft LoopBack Adapter to be the primary network adapter on the system. See the Installation Guide for more details on installing the software on systems configured with DHCP.

Solution:
=========
Checked Oracle® Database Installation Guide 11g Release 1 (11.1) for Microsoft Windows. Follow below link to install Microsoft loopback adapter
http://download.oracle.com/docs/cd/B28359_01/install.111/b32006/reqs.htm#sthref291

After following above steps the prerequisite checks passed without any errors/warnings.

Other observation: Its interesting that "Advanced Installation - Custom" does not do the prerequisite check for "Network configuration requirments" hence does not report this problem.

More to study from:
===================
Oracle by Example series: Oracle Database 11g
http://otn.oracle.com/obe/obe11gdb/index.html