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

http://jenseng.com/archives/000035.html

[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

Oracle editor in Linux

simple is the way.

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

add an entry
define_editor=vi

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

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.

Oracle auto start Script for Solaris x86 / Solaris 10

We have 10+ oracle 10g instances on Solaris different versions, I have worked alot with linux(EL, AS, Fedora4-9), but now days I am working with Solaris......
task is to configure oracle autostartup.

i made a file at /etc/rc3.d/S98oradbstart

-------------------------------------------------------------------------------------
#!/bin/sh
#
#echo "Starting Oracle Database" > /dev/consoleORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATHexport ORACLE_HOME LD_LIBRARY_PATH
su oracle -c "${ORACLE_HOME}/bin/dbstart" < /dev/nullexit 0
-------------------------------------------------------------------------------------
now either you will run level 3 or 5 your oracle plus listener will be started automatically.
Here was some error that i faced.
1.
/u01/app/oracle/product/10.2.0/db_1/bin/dbstart: VER10LIST=10: is not an identifier
i looked into file /u01/app/oracle/product/10.2.0/db_1/bin/dbstart
and changed
this export VER10LIST=`$ORACLE_HOME_LISTNER/bin/lsnrctl version grep "LSNRCTL for " cut -d' ' -f5 cut -d'.' -f1`
to

VER10LIST=`$ORACLE_HOME_LISTNER/bin/lsnrctl version grep "LSNRCTL for " cut -d' ' -f5 cut -d'.' -f1`; export VER10LIST

then faced
2. “`COUNT=$’ unexpected” at or near line 259
i changed in dbstart scropt
from
COUNT=$((COUNT+1))toCOUNT=`expr $COUNT + 1`

Now life is good.

Failed to allocate port(s) in the specified range(s) for the following process(es):

Failed to allocate port(s) in the specified range(s) for the following process(es): JMS [5540-5559],RMI [5520-5539],Database Control [5500-5519],EM Agent [3938] [1830-1849]
Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2008-03-12_03-42-45-PM.log for more details.
Could not complete the configuration. Refer to the log file at /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/emca/orcl/emca_2008-03-12_03-42-45-PM.log for more details.
I just added ip-address machinename in /etc/hosts file