Thursday, December 9, 2010

No input file specified

404 error suggests that there is no file... in my case i saved file test.php.txt ... after saving test.php worked for me but here is really good discussion....

Saturday, December 4, 2010

[ora1@RHEL1 ~]$ sqlplus
sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory
[ora1@RHEL1 ~]$

i believe that this error comes when u r running sqlplus from user other than oracle. for this (10.2.0.1) you have to run following script and that is included in Patch 4516865

put both files in $ORACLE_HOME/install/ directory.
n
1. cd $ORACLE_HOME/install
2. Run changePerm.sh script.

then press y

Monday, August 2, 2010

Oracle editor in Linux

simple is the way.

open file at
oraclehome/sqlplus/admin/glogin.sql

add an entry
define_editor=vi

Thursday, July 8, 2010

ora-12537: TNS connection closed

one of my solaris and linuxEL5 host name changed and i was faceing this problem(ora-12537). i just opened hosts file added entry
IP hostname localhost

and solved the problem...

Tuesday, July 6, 2010

SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]

faced the following error and solution is very very simple
C:\>sqlldr gcon_user control='E:\test_ctl.ctl'
Password:
SQL*Loader: Release 10.2.0.1.0 - Production on Wed Jul 7 11:11:45 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
ORA-12560: TNS:protocol adapter error
as the last line show that (ora-12560) its sid is not set. please use for windows at cmd
set ORACLE_SID=YOUR_SID
for linux
ORACLE_SID=YOUR_SID

Cheers.