Monday, December 28, 2009

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 )
)

)

Thursday, November 12, 2009

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

Sunday, August 23, 2009

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/

Saturday, July 11, 2009

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

Sunday, May 10, 2009

adiyen's acharyan - K.K.A. U.Ve. APPAN RAMANUJACHAR SWAMIGAL



Adiyen's acharyan Sri. K.K.A. U.Ve. APPAN RAMANUJACHAR SWAMIGAL

Thursday, January 8, 2009

How to capture invalid Email address & lot of others things

After a long hiatus from writing in the blog, I am back;
Problem is that, it is difficult to decide whether the post will add value or is it something known to everyone, except me!

This was an interesting issue. What appeared to be a relatively straightforward work, stretched beyond 2 days with no end in sight.
There is a metalink note how to handle this 456378.1
However, this did not mention how to enable the Event - I did not see any way to enable. A little digging showed me that "Create Events" button has to be enabled. Enabled it myself using "FND: Diagnostics" option.
Once the oracle.apps.wf.notification.send.failure event was enabled, ensured that I created a malformed email address. Then created a test email by going to OAM->Workflow Manager -> Service Components -> "NotificationMailer"->View Details -> Test Email. selected my role and that is it. Now Oracle will generate an invalid email address or so I thought.
However, I found that the Notification was still in MAIL Status.
This led to question is the Background Engine on? I need to turn on the Background engine with all the three parameters as Y. No problem. But I need to know the Item type before I can start. Only problem is what is the Workflow Item Type? All I had was the Notification.
The Table WF_ITEM_TYPES_VL carries the Item_Type and is linked to WF_NOTIFICATIONS (WF_ITEM_TYPES_VL.NAME = WF_NOTIFICATIONS.MESSAGE_TYPE) .

I was able to see in the Mailer Log , that Workflow mailer has attempted to send a notification several times. all of them ended up with an error message: "451 Timeout waiting for client input"