Sunday, August 8, 2010

using ed command

When trying to edit a sql query or a pl/sql program using ed command on linux platform, I end up with a probably primitive editor.
What I got is as:

SQL> ed
Wrote file afiedt.buf
29

?

The solution is to add follwing line to glogin.sql file of oracle user:

define_editor=vi

Thursday, March 18, 2010

Ora-12154 when connecting to Oracle forms

When I started oracle Forms to create a new data blocks, I was unable to connect to the database. I got error:
Ora 12154: TNS name could not resolve the connect identifier specified

I have installed Oracle Developer suite 10g after Oracle 10g server. Platform is Windows Xp.

Solution: copy tnsnames.ora file from oracle home location to oracle developer home location.
that is,
from
d:\ora_10g\ora92\network\admin\tnsname.ora to
d:\oracle_tool\network\admin\tnsname.ora

Shutdown and restart the oc4J instance again. Try to connect again. everything work fine.