SOA Foundation Certification

I saw a beta announcement on SOA Foundation. Intend to take this in the first week of March.
Beta Exam on SOA Foundation. For more details click here.

JDeveloper... up and working on OAF

Found the DBC file needed for connectivity, at two places viz; 1) $INST_TOP/./appl/fnd/12.0.0/secure/ 2)$FND_SECURE
Copied this to \dbc_files\secure (The variable JDEV_USER_HOME is created by clicking on MY Computer Icon and selecting advanced tab then clicking on Environment variables;click on New button under user variables and Create a variable JDEV_USER_HOME and give the path as mentioned above).

12.1.1. is up and running and srinivaSAN (pun intended :-) ) can work on JDev! Yahoooooo!

A typical DBC file looks like the following:
==========================
#DB Settings
#Sat Jun 13 15:24:33 EDT 2009
GUEST_USER_PWD=GUEST/ORACLE
APPL_SERVER_ID=7D3ED2C586E7B5EAE0400AC0867967BF11393538614093026453179252362826
FND_JDBC_BUFFER_DECAY_INTERVAL=300
APPS_JDBC_DRIVER_TYPE=THIN
FND_JDBC_BUFFER_MIN=1
GWYUID=APPLSYSPUB/PUB
FND_JDBC_BUFFER_MAX=5
APPS_JDBC_URL=jdbc\:oracle\:thin\:@(DESCRIPTION\=(ADDRESS_LIST\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS\=(PROTOCOL\=tcp)(HOST\=oracleDemo.com)(PORT\=1521)))(CONNECT_DATA\=(SERVICE_NAME\=ORA12)))
FND_JDBC_STMT_CACHE_SIZE=100
TWO_TASK=ORA12
JDBC\:oracle.jdbc.maxCachedBufferSize=358400
JDBC\:processEscapes=true
FND_MAX_JDBC_CONNECTIONS=500
FND_JDBC_USABLE_CHECK=false
FNDNAM=APPS
FND_JDBC_PLSQL_RESET=false
DB_PORT=1521
FND_JDBC_CONTEXT_CHECK=true
FND_JDBC_BUFFER_DECAY_SIZE=5
DB_HOST=oracleDemo.com
=============================

How to create tnsnames.ora for R12?

I followed the following steps to create a tnsnames.ora entry for Oracle Release 12. (funny could not find any entry for this)

To create this using Net Manager, you would need
# 1. Hostname, 2. Oracle HOME PATH in c drive, 3. SID - find from v$instance
# 4. Copy Oracle SID details from Listener.ora and add the following
# (CONNECT_DATA = (SID = )
# TNSNAMES.ora file is ready
# Open sqlnet.ora file and Comment out the line NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
# test by running tnsping
# add this to toad or sqldeveloper.


LISTENER ENTRY:

VISR12 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = demo)(PORT = 1521)
)
)

SID_LIST_VISR12 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = VISR12)
(ORACLE_HOME = )
(SID_NAME = VISR12)
)
)



TNSNAMES ENTRY:
Example entry I)

VISR12 =
( DESCRIPTION =
( ADDRESS = ( PROTOCOL = TCP ) (HOST = demo) (PORT=1521)
)
( CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =VISR12 )
)
)


Example Entry II)
VISR12 =
( DESCRIPTION =
(ADDRESS_LIST =
( ADDRESS = ( PROTOCOL = TCP ) (HOST = demo) (PORT=1521)
)
)
( CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =VISR12 )
)

)

Learning JDev

Oracle is throwing all it got in Jdeveloper suite and it is getting too interesting to remain in the Forms /PLSQL world.
So here I go. Attended an Oracle meet on Jdeveloper
Next moving on with what else? Howto's http://www.oracle.com/technology/products/jdev/howtos/index.html
To go to Jdeveloper Home: http://www.oracle.com/tools/jdev_home.html

ebooks for free

Came across this website which lists 50 topsites to download eBooks for free (although it did not find the book I was searching for as a free download).
http://www.bestonlinetools.org/50-top-websites-to-download-ebooks/