Oracle -ksh: sqlplus: not found [No such file or directory]

User is getting the below error when trying to connect from a client unix machine to the PROD database...-ksh: sqlplus: not found [No such file or directory]Anyone please help in fixing this ...

Oracle sub: /usr/bin/ksh: sqlplus: not found.

I installed Oracle 9R2 client on one server and i'm not able to execute sqlplus command it's throwing following error's :oracle:/home/oracle#sqlplus/usr/bin/ksh: sqlplus: not found.:oracle:/u01/app/oracle/product/9.2.0#sqlplus/usr/bin/ksh: sqlplus: 0403-006 Execute permission denied.then i gave 777 ...

Oracle Executing sqlplus in windows batch file - URGENT

HiIs it possible to run sqlplus.exe thru batch file as follows.set PATH=%PATH%;C:\oracle\product\10.2.0\client_1\BIN;host sqlplus userid=test1/test12@testdev sELECT * FROM CASESTATUS ...

Oracle ksh: sqlplus: not found.

i can logon to oracle db as id=oracle but when i tryto connect to sqlplus as a regular user, i got this error ksh:sqlplus not foundi've configured the .profile as***********PATH=/oracle/app/oracle/product/10.2.0/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.export PATHif [ -s "$ ...

Oracle Can I output SqlPlus messages to a file?

This is part of my ksh script. checkDiskSpace.sql is used to display the diskspace used in specific table spaces. Currently, they are displayed on my linux xterm. How can I redirect the results to a file?Thanks!$ORACLE_HOME/bin/sqlplus -s $PW <<EOF@checkDiskSpace.sql;exitEOF ...

Sqlplus output to text file truncates spaces in Shell script

I am trying to send output to a flat file using following code. Last column has 3 spaces (NOT NULL). When I use spool or run the same commands from sqlplus it works fine, but when I put this code in shell script, output gets truncated to the second column (it does not give 3 spaces at the end). Any ...

SQLPLUS spool to CSV file

What is the better way that I can export data recordset to a .CSV file from Oracle SQLPLUS?I want to output the records with comma seperated values to a .CSV file on Unix and "ftp" to a Windows2000 Desktop and open in MSEXCEL.select * from table1.I have to schedule this on Unix through cro ...

Oracle Running sqlplus in a command file

How to run SQLPLUS command in a command file ...

Oracle sqlplus: using a spool file with relative path

I have an issue which i am hoping has an easy answer ..i am trying to generate the name of the sqlscript file inside another sqlscript file by using spool, and then executing the resultant script file, how can i do this with a relative path. i cannot do a CD to the location of the scripts.wrapper sq ...

Oracle Problem in connecting to sqlplus from windows batch file (DOS)

We have a new 10g Oracle database installed on windows server. I am trying to write a windows batch file to 1) Connect to SQLPLUS2) Execute a script3) Disconnect from SQLPLUS. Example File Name:- execsql.bat SET ORACLE_SID=CAUTSET SCHEMA_IN=%1SET PASS=DEVSET script=%2sqlplus %SCHEMA_IN%/%PASS%@%ORAC ...

Oracle How to exetucute multiple sql scripts with sqlplus from a batch file

everyone. I would like to thank you for everyone in advance. I have couple problems I need to solveI need to create batch file (windows bat file) and be able execute all the sql scripts located in a certain folder.For example, all the sql scripts will be in folder;C:\tfsroot2\Interfaces and Extracts ...

Oracle Mysterious sqlplus error (/tmp/sh$$.* file)

I recently see this error frequently in our system. The log shows something like /tmp/sh28370.3: cannot openSQL Error Exiting...The /tmp/sh<PID>.* file seems to be the sqlplus generated file. I could some some similar files in the /tmp directory generated by other processes. And there is only ...

ksh: how to process a file by batch given that each batch is 1kb in size.

this problem is a continuation to the problem that I posted last friday.... the problem that I posted was how to extract the first 8 and last 18 character of each string in a file... but is it possible that when the file that was being processed reaches 1kb it will be put in a separate file.... I me ...

Oracle AIX, ksh and FTP - automating a file transfer. DONE! Thanks.

I have a commandfind /xxx/oracle/WHITE/ -amin -30 -name "*.dbf"which produces a list of files I wish to transfer over our network to a backupmachine.I would like a sample of a shell script (ksh on AIX) which automates thisprocess, and which I could then put into crontab.15 * * * * /home/xxx/paul/p1. ...

Oracle File Director

I am running Oracle9i Release 9.2.0.6.0. I want to use utl_file in PL/SQL. How many ways I can give it direcotry name in unix HP box. Please give example also. Please no reference to book or reference to link. Help me here please. ...

ksh script sqlplus < file.sql problem

hii am trying to do the following line in ksh script:sqlplus <user>/<pass>@<instance> < file.sqlfile .sql = UPDATE <table_name> SET <param_name> = $environment_parameterthe problem is that the sql file does not recognize the env_param (only ksh do)how do i introduce ...

Oracle instantclient/sqlplus on linux64 gets "cannot execute binary file"

I'm trying to setup a Linux system on ia64 (Opteron) to remotely connect to a Oracle database using instantclient.I've downloaded: instantclient-basiclite-linux-x86-64-10.2.0.1-20051025.zipinstantclient-sdk-linux-x86-64-10.2.0.1-20051025.zipinstantclient-sqlplus-linux-x86-64-10.2.0.1-20051025.zipThe ...

Oracle sqlplus fails to link; s0afimai.o File format not recognized

I have installed Oracle 10g on a Red Hat Linux system,and several of the supporting programshave failed to link.In particular, sqlplus has an error, saying thatthe file format of s0afimai.o is not recognized.An extract from the log file appears below.I have searched through this forum, but I have no ...

Can't run sqlplus to oracle on different user

I have installed oracle 10g on opensuse. After i logon as normal user and type sqlplus, it was display an error message as below:-login: nv2am Password for nv2am: login: Configuration file does not specify default realm when parsing name nv2am Last login: Tue Aug 3 16:33:19 from 10.69.20.25 Have a l ...

Pass error sql to ksh

I try to use 'whenever sqlerror exit sql.sqlcode' to pass the SQL error code to the bash but it doesn't work:This is my script It is in a file file_name.ksh :sqlplus -s /nolog << END | tee -a $LogFileconnect $CidUser/$CidPwdwhenever sqlerror exit sql.sqlcodealter session enable parallel dml;se ...

Give error code from sqlplus to shell script

First sorry for my englis I'm french.I try to use 'whenever sqlerror exit sql.sqlcode' to pass the SQL error code to the bash but it doesn't work:This is my script It is in a file file_name.ksh :sqlplus -s /nolog << END | tee -a $LogFileconnect $CidUser/$CidPwdwhenever sqlerror exit sql.sqlcod ...

Oracle output to spool file only

I don't want the output of the spool file to be written to a log file while executing the script. My script looks like this,#/bin/kshsqlplus test/test 1>>/test/abc.log 2>>/test/abc.log <<EOFset termout offset feedback offset flush offspool /test/test.datselect 'a' || 'b'|| 'c' from ...

Oracle Running SQLPLUS from UNIX shell script

I'm not sure if this is the right forum, but...How can I execute a sql file from inside the UNIX shell script, logging on to Oracle w/o supplying a UID/pwd? Normally, we log into UNIX using our own logon, then sudo as another user to login to Oracle. Now, I'm trying to create a UNIX shell script, wh ...

sqlplus with oracle xe on OEL

here is my problem: I am using XE on OEL 4.8, and would like to perform batch operations with Korn shell scripts and perl code. we all know we can fire up a window that offers an SQL command line, which has the appearance of having entered SQLPlus, and then you do a connect command to reach your des ...

Oracle sqlplus command not found

I have installed oracle 10g on opensuse. After i logon as normal user and type sqlplus, the command not found.. The error message as below:-login: nv2amPassword for nv2am:nv2am@ARMSDEV:/home/nv2am> sqlplus-ksh: sqlplus: not found [No such file or directory]nv2am@ARMSDEV:/home/nv2am> sqlplus "/ ...

Director 5.2 Software Distribution (Not Premium)

Hi, I´ve created the task form the director server to install by the xml file director agent on the Level 0 machines discovered, but always get me this erroras you can see, Spanish lenguage used (Server2003 R2 server, XP Clients)15/01/2007 17:42:50 Se ha activado el trabajo "Agente de IBM Director ...

Using Director Agent from LoriotPro

We are trying to integrate the IBM MIB for the director agent and we do have some questionI do have the following mib file IBM-Director-Agent-MIB IBM-Director-Server-MIBIBM-Director-Alert-MIBIBM-SERVERAID-MIB assuming that the object director is 1.3.6.1.4.1.2.6.159when i walk the director branch i g ...

which file is the startup file in suse9.3?

If I have to add something like "export FPATH=/usr/share/ksh/functions" to the startup file, which file should I add it to? ...

get data > 4000 bytes into a flat file using pl/sql

I am working on an application to get data older than 18 months from Oracle 8i tables into flat files.I am using simple sql queries along with spool to get all rows data into flat files,however, I am using PL/SQL for those tables whose total rowlength can be more than 4000 bytes (determined from the ...

Where does SQLplus store files?

I am using oracle9i on win2000. When I save SQLPlus buffer to a file xxx.sql, where did it go? ...

can't start sqlplus after 10g installation

I am new to Oracle, and kind of new to Solaris too. This is my problem:I have Oracle 9.2 client installed on this Sun Solaris machine (no database), which points to another Sun Solaris machine (10g database). My customer wants a 10g clients on the first machine, so I installed on it (custom installa ...

oraenv/dbhome/sqlplus errors

I have a 2 node 10g RAC running on AIX 5.3. I'm having some issues with the oraenv/dbhome/sqlplus. When i try to use these features to access my database i get the following errors:(oracle@lbdbora1) /home/oracle > . oraenvORACLE_SID = [labtest1] ?dbhome[4]: 0403-057 Syntax error at line 4 : `(' i ...

Oracle Problem in starting sqlplus after installing http server only on red hat linux 7.1

I have installed http server on my pc. it was installed successfully mt http server is running on port 7777 but when i am trying to run sqlplus from user root/home/oracle/OraHome1/bin > ./sqlplusit's giving msg1<lang>.msb file not found.error 6 intializing sql*plus but i have seen that sqlp ...

Extracting a character from a string in KSH

Good day. I'm having problems with my KSH.I have a text file with lines like this: (impsrc.lst)!WK29_20070720_1109_v26=SCMUIUSERThis is my script:cat impsrc.lst | while read linedo{if line contains '=' then do} <--- don't know how to do thisfilez=${line##*"="}echo "Found: "$fi ...

Oracle sqlplus and unix (bash) shell scripting

I'm extracting some information from a DB and then "spooling" it to a file. So far so good. The problem is that the records I get are not like what they look like when I run the stuff in sqlplus. Instead, the spooled file has alot of weird spaces and tabs in between and does not properly separate be ...

How to Sool SqlPlus result to .txt

Guys I am new at oracle(SQLPlus ,as well) I am trying to run a sql file which contains more than 500 alter statement which is suppose to alter all of my tables.After running the @alterTab.sql in sqlplus the result display at cmd command but I can's navigate to previous pages to to see what table did ...

Oracle Runnin sqlplus on the server AIX

I'm new on UNIX and when i run sqlplus 'connect as sysdba' on AIX 5.3 i receive the following error ksh: sqlplus: not foundCould u give me a help to solve this problem? ...

Oracle instant client 10.2.0.2 - Solaris 32 bit - sqlplus relocation error

Did anyone use the sqlplus that comes with Instant Client 10.2.0.2 - Solaris 32 bit to connect to a remote Oracle database? I am unable to get it working.More info below:I unpacked these two packages onto my Solaris 9 box into a directory called /space/OracleClient10g/instantclient_10_2a) instantcli ...

Oracle suppress heading for printing bind variable in sqlplus

I have to spool a lot of (XML) text from within a sqlplus session to a file (unfortunately I cannot use UTL_FILE).Because I found no way to pull out the complete XML string at once with sqlplus I wrote a function which returns a CLOB value. Inside sqlplus I declare a variable andassign the return va ...

Oracle InstantClient on HPUX- sqlplus not working

I am trying to configure oracle instant client on HPUX (11.23 IA64) machine. I downloaded the zip files from http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/hpitanium64soft.html and unzipped them into /../oracle directory as a root. And as per the instructions on below url, i ...

Oracle sqlplus and Unix crontab

I would like to employ the crontab of Unix (Unix Aix)to launch a Unix script containing a stored procedure (oracle). Here the code of cron: 15 09 * * 1-5 /bin/ksh -c "/my_rep/my_script.ksh"And the Unix script (part of): my_script.ksh":!/bin/ksh....sqlplus user/pwd@db_name << EOFspool my_trace# ...

Oracle unix (solaris) variables from sqlplus

I modfied the /user1/oracle9i/sqlplus/admin/glogin.sql file in a solaris machine in order that the sqlprompt included the machine name that I read from v$isntance, it worked ok, the problem was that it hung when the db instance was not up making the dbstart command to fail.I wonder if there is a way ...

Oracle Sqlplus cannot start

I have a problem with sql. I have installed a new test DB and when i tried to start sqlplus:oracle@spf9:/home/oracle<0>sqlplus ksh: sqlplus: not foundoracle@spf9:/home/oracle<1>and when i tried ./sqlplus in a directory -> cannot execute... =(Some idea?Thx FuCco ...

Ubuntu File Permissions

There is a file that I can not executethis file is under /usr/local/opt/msc/bin-rwxr-xr-x 17 root root 11420 2004-07-28 15:18 nastran.When trying to execute ./nastran, I getbash: ./nastran: /bin/ksh: bad interpreter: No such file or directory since I have owner and group permissions as root, I think ...

Oracle getting sqlplus to read tnsnames.ora

I have installed the instant client (version 11_1) on an Ubuntu box (9.04)I have a tnsnames.ora file I would like to use with sqlplus.What do I need to do to configure to get sqlplus to use my tnsnames.ora file?When I strace the sqlplus process, I see that it tries accessing tnsnav.ora (in several l ...

Oracle exit from sqlplus while in an if

I'm running this with sqlplus udser/pass@sid@file.sqlI want to exit sqlplus not doing anything if my count is 0but stuff outside the BEGIN/END is still running.. example:Begindeclarev_count number DEFAULT '0';beginselect count(*) into v_count from rwp.bil_core_receipt where f_processed_for_core = 'Y ...

oracle scripts fail need help

I cannot get my new scripts to run correctly:SQL*Plus: Release 8.1.7.0.0 - Production on Wed Dec 29 13:57:32 2004(c) Copyright 2000 Oracle Corporation. All rights reserved.Connected.Disconnected from Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit ProductionWith the Partitioning, OLAP and Orac ...

running all sql files from a unix directory

I am on solaris 5.8 and work on a 10.2.0.3 oracle database.In my shell scripts, I have #!/bin/kshsqlplus -s /NOLOG <<!EOFconnect user/pwd@database@/data/dev/file1.sqlexit!EOFexit 0The above code is good for executing a single file. Suppose, I want to run all the .sql files in the /data/dev dir ...

Oracle dbms_scheduler.create_job() job_type executable

I created a job using a dbms_scheduler.create_job()here is the code:BEGINDBMS_SCHEDULER.CREATE_JOB(job_name=>'CRSJOB',job_type=>'EXECUTABLE',job_action=>'/tmp/crsrows2 > nul',start_date=>SYSTIMESTAMP,repeat_interval=>'freq=minutely; byminute=2',end_date=>NULL,ENABLED=>TRUE,co ...

Oracle getting data

I want to get data from oracle to a unix file.I am using like this..I am getting data directly on the screen but in a file..plz help me if anybody knows..I have written like this.#!/bin/kshsqlplus -s /nolog << EOFCONNECT ccop/appluser1SET LINESIZE 180SET PAGESIZE 50select * from s_nsc >> ...