SQL*Loader: Release 11.2.0.3.0 - Production on Wed Jun 8 12:57:43 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

SQL*Loader-704: Internal error: ulmtsyn: OCIStmtExecute(tabhp) [1480]

ORA-01480: trailing null missing from STR bind value

Table was of more than 30 character in control file.

Table name corrected and loading was successful.

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.