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/

Google accounts in Twitter

Google has posted a list of account it has in twitter & on its blog
Here is the link Click here to goto Google post