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]
Mar 13, 2012 | java, Oracle, oracle forms, oracle reports
specs: Pentium Dual 2.2 64bit, 5 GB mem, Windows 7 64bit
reqs: Win7 x64, 1GB Memory, Administrator
time: Oracle Weblogic: 5 min, Fusion Middleware: 23 min setup, 16 min config
- Download Java JDK 6u25 x64 (jdk-6u25-windows-x64.exe)
- Download Weblogic Server 10.1.3.2 (11g) from here
Tip: look for “Oracle WebLogic Server 11gR1 (10.3.2) – Package Installer” and select
the x64 JVM installer package (about 1 GB)
- Download Fusion Middleware – Portal, Forms, Reports and Discoverer (11.1.1.2.0) from here
Tip: look for “Portal, Forms, Reports and Discoverer (11.1.1.2.0)” download link and select
the x64 zip files (about 2.5 GB in chunks of ~500MB).
- Make sure you have at least
- a 64bit CPU and Windows system
- 1 GB of memory
- 5 GB of free disk space for a typical install (more…)
Dec 21, 2011 | Databases, Linux, Oracle
Check or change the default port numbers by editing the file (in VI):
[bash]vi $ORACLE_HOME/install/portlist.ini[/bash]
Apr 18, 2011 | Oracle, oracle ADF |
To deploy a java/ADF app on an Oracle Application Server (10.1.3.1) and handle the datasources from there:
After generating the ear and war files from within JDeveloper…
- Login to OAS
- Cluster Topology > OC4J-instance > Administration > JDBC Resources
- Firstly create the Connection Pools:
- Connection Pools > Create (for “native” pool)
- Application: Default
- select “New Connection Pool“:
- Name: jdev-connection-native-appname
- Connection Factory Class: oracle.jdbc.pool.OracleDataSource
- JDBC URL: jdbc:oracle:thin:@//192.168.10.230:1521/serviceID
- provide Username and Password
- Test Connection
(more…)
Apr 8, 2011 | Databases, Linux, oracle pl/sql
Prerequisites:
- Import:
- Oracle DB setup with default DB
- the username that has access to the import DB
- Remember to set the character set if importing Unicode
- Import/Export:
- ip-address, SID, user/pass (sysDBA) (more…)
Comments