Feb 1, 2018 | Databases, Oracle
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”
[OL69]
name=CentOS 6.9 x86_64
baseurl=file”///var/OSimage/OL6.9_86_64
gpgkey=file”///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
gpgcheck=1
enabled=1
*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
Sep 25, 2013 | JDeveloper, Oracle, Recent
To add a Data Source from JDeveloper:
- View > Application Server Navigator
- Application Servers > IntegratedWebLogicServer
- R-click > Launch Administrative Console…
-that should be i.e. like “http://127.0.0.1:7101/console/login/LoginForm.jsp”
- Login with user/password
- From Domain Structure open Services > select Data Sources
- New > Generic Data Source
- 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.
Mar 1, 2013 | Oracle, oracle pl/sql, Scripts, Scripts & Batch
Create a sequence (i.e. “tmp” starting with 10001) to be used in statements:
[sql]CREATE SEQUENCE TMP
START WITH 10001
MAXVALUE 9999999999999999999999
MINVALUE 1[/sql]
Enter the following in a DB-Tool editor:
[sql]begin
FOR Lcntr IN 1..10000
LOOP
insert into customer (surname, forname, some_id, some_field)
values (‘SN’ || tmp.nextval, ‘FN’ || tmp.nextval, 123456, ‘abcdef’);
END LOOP;
commit;
end;[/sql]
Output should be something like this:
[text]SN50076,FN50076,123456,abcdef
SN50077,FN50077,123456,abcdef
SN50078,FN50078,123456,abcdef
SN50079,FN50079,123456,abcdef
SN50080,FN50080,123456,abcdef
SN50081,FN50081,123456,abcdef[/text]
Feb 27, 2013 | JDeveloper, oracle ADF
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:
[text]jdev10.1.3.5.adf\jdev\system\oracle.j2ee.10.1.3.43.6\embedded-oc4j\persistence\[/text]
Jan 17, 2013 | JDeveloper
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.
Oct 3, 2012 | Databases, Oracle, oracle pl/sql
Login to the database and execute the following:
[sql]select * from v$version;
–OR:
select * from product_component_version;[/sql]
Result:
[text]Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 – 64bit Production
PL/SQL Release 11.1.0.7.0 – Production
CORE 11.1.0.7.0 Production
TNS for 64-bit Windows: Version 11.1.0.7.0 – Production
NLSRTL Version 11.1.0.7.0 – Production[/text]
Comments