Oracle Database Preinstallation Tasks and Setting a local repo on CentOS 6.9

Copy the ISO file into the VM (i.e. Downloads folder) and create a dir to use to mount the ISO to:
mkdir -p /var/OSimage/OL6.9_x86_64

Mount the directory with ISO file to a path:
mount -o loop, ro /home/oracle/Downloads/CentOS-6.9-x86_64-bin-DVD1.iso /var/OSimage/OL6.9_x86_64/

Go to cd /etc/yum.repos.d and edit the “CentOS-Base.repo” file and add enabled=0 to each section to disable these entries

Add a new file “OL69.repo”

name=CentOS 6.9 x86_64

*Make sure the gpgkey file exists in that path or use an equivalent

Command to check which packages have been installed or not:

rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc glibc glibc-devel ksh libgcc libstdc++ libstdc++-devel libaio libaio-devel libXext libXtst libX11
libXau libxcb libXi make sysstat

Source: Oracle Database Preinstallation Tasks

How to add a Data Source on Oracle 11G Weblogic with JDeveloper 11gR2

To add a Data Source from JDeveloper:

  1. View > Application Server Navigator
  2. Application Servers > IntegratedWebLogicServer
  3. R-click > Launch Administrative Console…
    -that should be i.e. like “”
  4. Login with user/password
  5. From Domain Structure open Services > select Data Sources
  6. New > Generic Data Source
  7. Specify the connection properties:
  • Name: MyConnectionDS (or whatever you defined in your Java app data source)
  • JNDI Name: comp/env/jdbc/MyConnectionDS or jdbc/PoliceConnectionDS
  • Database Type: Oracle
  • > Next
  • Database Driver: Oracle’s Driver (thin) for Instance Connections (versions 9.0.1 or later)
  • > Next
  • Supports Global Transactions
  • One-phase commit
  • > Next
  • Type in: Database Name, Host Name, Port, Database User Name, Password
  • > Next
  • Test Database Connection screen > click Test Your Configuration
  • if “Connection test succeeded.”, click Finish

Your new data source should be ready to use for local server run/debug.





Create a Data Generator using sequence and a loop in Oracle DB

Create a sequence (i.e. “tmp” starting with 10001) to be used in statements:

MAXVALUE 9999999999999999999999
MINVALUE 1[/sql]

Enter the following in a DB-Tool editor:

FOR Lcntr IN 1..10000
insert into customer (surname, forname, some_id, some_field)
values (‘SN’ || tmp.nextval, ‘FN’ || tmp.nextval, 123456, ‘abcdef’);

Output should be something like this:


JMS error when running/debugging ADF application with JDev (10g)

If you get the following or similar error:

OC4J – (SEVERE) Failed to set the internal configuration of the OC4J JMS Server with: XMLJMSServerConfig (jms.xml)

You may need to delete all contents within the “persistence” folder:


How to remove the number next to JDeveloper caused by SVN

The reason you get some numbers next to file names of JDeveloper (or IPs on project names) is because subversioning is enable in your JDeveloper’s options.

To disable and continue to use your external subversioning system do as follows:

From within JDeveloper:
[text]Versioning > Configure…
Deselect “Versioning Support for Subversion…”[text]

Restart your JDeveloper and the revision numbering should go away.

How to check the version of an Oracle Database with PL/SQL

Login to the database and execute the following:

[sql]select * from v$version;
select * from product_component_version;[/sql]


[text]Oracle Database 11g Enterprise Edition Release – 64bit Production
PL/SQL Release – Production
CORE    Production
TNS for 64-bit Windows: Version – Production
NLSRTL Version – Production[/text]