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
Sunday, August 8, 2010
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.
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.
Subscribe to:
Posts (Atom)