Monday, December 31, 2012

ORA-00904: : invalid identifier dbms_workload_repository

User has "Select Any Dictionary".

Trying to run awrrpt using that user and got below error:

select output from table(dbms_workload_repository.awr_report_text( :dbid,
                         *
ERROR at line 1:
ORA-00904: : invalid identifier
 
This is because the user does not have grant to execute dbms_workload_repository.
 
So after granting execute on dbms_workload_repository, user was able to run awr report.
 
HTH.  

Thursday, December 27, 2012

Windows is searching for SQLDEVELOPER.BAT

Please refer to :

http://vishalorcl.blogspot.com/2012/12/sql-developer-from-11201-client-software.html

HTH.

Unable to find a Java Virtual Machine.

Please refer to :

http://vishalorcl.blogspot.com/2012/12/sql-developer-from-11201-client-software.html

HTH.

SQL Developer from 11.2.0.1 client software

Installed 11gR2 64-Bit Client on Windows 7 (64-Bit).

Tried to launch sqldeveloper from
Start-> All Programs -> Oracle - OraClient11g_home1 -> Application Development -> SQL Developer

Got below error:




Properties for that shortcut show that its looking for sqldeveloper.bat, which is not actually present.
But below executables are available at the same location:
sqldeveloper.exe and sqldeveloperW.exe




Modified the target to sqldeveloperW.exe and tried to launch the sqldeveloper. It asked the full path for JAVA.exe




Browsed to $ORACLE_CLIENT_HOME\jdk\bin

It failed with below message:



Did google on above error and found that 64-Bit JDK is not supported for sqldeveloper.

So dowloaded and installed 32 bit JDK (jdk-6u37-windows-i586.exe)

Remove below line from sqldeveloper.conf so that next time you launch sqldeveloper it prompts you to provide JAVA.exe location and then you can point it to newly installed 32 bit JDK.

    SetJavaHome C:\app\admin\product\11.2.0\client_1\jdk

Launch sqldeveloper. Provide new path for JAVA.exe.

AND IT WORKED!!!

After it launched, I checked version using Help -> About. It showed it is version 1.5.5.


But the latest version available for sql developer on oracle website is 3.2.2.

I will write another post to describe how to upgrade to 3.2.2

Wednesday, December 19, 2012

File not found WFMLRSVCApp.ear


I downloaded
win64_11gR2_database_1of2.zip
win64_11gR2_database_2of2.zip

The Directions on OTN download page mention that unzip them into same directory before install.




I decided to see what error message we would see if I didnt unzip them in the same directory.


Got below error:

It went around 50% of install and failed during Copy files operation as shown below:







Well, we know the solution already...

1. Unzip both zip files in same directory and redo the installation
2. Some forum posts suggests that if we copy everything from disk2->stage->components directory
to disk1->stage->components then it works too.




Hope this helps.