I am generating output file (.xls format) from the below DB query- sqlplus -S -L user/pass@DB > home/test/query_output.xls set line 22000 set head off set feedback off SELECT * from table; EOF The query_output.xls file contains records as below- VIM 00 34562356 22412299 Dated 11-JUN-18 OMM sansra carla Yes No No No 02356478 14-SEP-18 To send this query_output.xls file as an attachment in email, I am using below- uuencode home/test/ query_output.xls | mailx -s "Subject" me@Domain.com Also tried uuencode query_output.xls query_output.xls | mailx -s "Subject" me@Domain.com But not getting the data in attachment received in email. Also tried mailx -a and mutt but its showing 'illegal option -- a' and 'command not found' resp. mailx -a home/test/query_output.xls -s "Subject" me@Domain.com < /dev/null mutt -a query_output.xls query_output.xls < /dev/null also tried mailx -s "Subject" me@Domain.com < query_output.xls but no attachment received. Could you please help?

I'm trying to run Oracle Linux 9(aarch64) on M2 MacBook Air using UTM, so that I can develop my python application that is required to connect to Oracle Database 11g. Because the python app requires Oracle instantclient installed, I installed 3 RPMs(basic, devel, sqlplus) according to:https://docs.oracle.com/en/database/oracle/oracle-database/19/lacli/installing-ic-arm-packages.html#GUID-1F3D38AD-A4DB-461A-9B50-9FC283C5A7CB ~~~ [kojima@localhost ~]$ sudo dnf list installed | grep instantclient oracle-instantclient19.10-basic.aarch64 19.10.0.0.0-1 @@commandline oracle-instantclient19.10-devel.aarch64 19.10.0.0.0-1 @@commandline oracle-instantclient19.10-sqlplus.aarch64 19.10.0.0.0-1 @@commandline ~~~ SQLplus seems to be successfully installed, but bash complains like: ~~~ [kojima@localhost ~]$ sqlplus -bash: /usr/lib/oracle/19.10/client64/bin/sqlplus: No such file or directory ~~~ But the executable file actually exist. Can someone please explain me what I missed? What am I supposed to do? ~~~ [kojima@localhost ~]$ file /usr/lib/oracle/19.10/client64/bin/sqlplus /usr/lib/oracle/19.10/client64/bin/sqlplus: ELF 64-bit LSB executable, ARM aarch64, version 1 (SYSV), dynamically linked, interpreter /lib64/ld-linux-aarch64.so.1, for GNU/Linux 3.7.0, BuildID[sha1]=abac9e40cfe83fd8802fb2226289640658b3b024, not stripped [kojima@localhost ~]$ uname -a Linux localhost.localdomain 5.15.0-3.60.5.1.el9uek.aarch64 #2 SMP Wed Oct 19 20:23:09 PDT 2022 aarch64 aarch64 aarch64 GNU/Linux [kojima@localhost ~]$ cat /etc/oracle-release Oracle Linux Server release 9.1 ~~~ # EDIT strace sqlplus gives following: ~~~ [kojima@localhost ~]$ strace sqlplus execve("/usr/lib/oracle/19.10/client64/bin/sqlplus", ["sqlplus"], 0xfffff0bed0a0 /* 32 vars */) = -1 ENOENT (No such file or directory) strace: exec: No such file or directory +++ exited with 1 +++ ~~~ ldd -v /usr/lib/oracle/19.10/client64/bin/sqlplus: ~~~ [kojima@localhost ~]$ ldd -v /usr/lib/oracle/19.10/client64/bin/sqlplus linux-vdso.so.1 (0x0000ffff8e854000) libsqlplus.so => /usr/lib/oracle/19.10/client64/lib/libsqlplus.so (0x0000ffff8e744000) libclntsh.so.19.1 => /usr/lib/oracle/19.10/client64/lib/libclntsh.so.19.1 (0x0000ffff8ba19000) libclntshcore.so.19.1 => /usr/lib/oracle/19.10/client64/lib/libclntshcore.so.19.1 (0x0000ffff8b745000) libnnz19.so => /usr/lib/oracle/19.10/client64/lib/libnnz19.so (0x0000ffff8b24a000) libdl.so.2 => /lib64/libdl.so.2 (0x0000ffff8b229000) libm.so.6 => /lib64/libm.so.6 (0x0000ffff8b188000) libpthread.so.0 => /lib64/libpthread.so.0 (0x0000ffff8b167000) librt.so.1 => /lib64/librt.so.1 (0x0000ffff8b146000) libaio.so.1 => /lib64/libaio.so.1 (0x0000ffff8b125000) libresolv.so.2 => /lib64/libresolv.so.2 (0x0000ffff8b102000) libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x0000ffff8b0d1000) libc.so.6 => /lib64/libc.so.6 (0x0000ffff8af23000) /lib64/ld-linux-aarch64.so.1 => /lib/ld-linux-aarch64.so.1 (0x0000ffff8e817000) Version information: /usr/lib/oracle/19.10/client64/bin/sqlplus: libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6 /usr/lib/oracle/19.10/client64/lib/libsqlplus.so: libpthread.so.0 (GLIBC_2.17) => /lib64/libpthread.so.0 libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6 /usr/lib/oracle/19.10/client64/lib/libclntsh.so.19.1: libresolv.so.2 (GLIBC_2.17) => /lib64/libresolv.so.2 libdl.so.2 (GLIBC_2.17) => /lib64/libdl.so.2 libm.so.6 (GLIBC_2.17) => /lib64/libm.so.6 libpthread.so.0 (GLIBC_2.17) => /lib64/libpthread.so.0 libaio.so.1 (LIBAIO_0.4) => /lib64/libaio.so.1 libaio.so.1 (LIBAIO_0.1) => /lib64/libaio.so.1 libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6 /usr/lib/oracle/19.10/client64/lib/libclntshcore.so.19.1: librt.so.1 (GLIBC_2.17) => /lib64/librt.so.1 libgcc_s.so.1 (GCC_3.0) => /lib64/libgcc_s.so.1 libdl.so.2 (GLIBC_2.17) => /lib64/libdl.so.2 libm.so.6 (GLIBC_2.17) => /lib64/libm.so.6 libpthread.so.0 (GLIBC_2.17) => /lib64/libpthread.so.0 libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6 /usr/lib/oracle/19.10/client64/lib/libnnz19.so: libdl.so.2 (GLIBC_2.17) => /lib64/libdl.so.2 libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6 /lib64/libdl.so.2: libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6 /lib64/libm.so.6: ld-linux-aarch64.so.1 (GLIBC_2.17) => /lib/ld-linux-aarch64.so.1 libc.so.6 (GLIBC_PRIVATE) => /lib64/libc.so.6 libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6 /lib64/libpthread.so.0: libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6 /lib64/librt.so.1: ld-linux-aarch64.so.1 (GLIBC_PRIVATE) => /lib/ld-linux-aarch64.so.1 libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6 libc.so.6 (GLIBC_PRIVATE) => /lib64/libc.so.6 /lib64/libaio.so.1: ld-linux-aarch64.so.1 (GLIBC_2.17) => /lib/ld-linux-aarch64.so.1 libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6 /lib64/libresolv.so.2: ld-linux-aarch64.so.1 (GLIBC_2.17) => /lib/ld-linux-aarch64.so.1 libc.so.6 (GLIBC_2.34) => /lib64/libc.so.6 libc.so.6 (GLIBC_PRIVATE) => /lib64/libc.so.6 libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6 /lib64/libgcc_s.so.1: libc.so.6 (GLIBC_2.34) => /lib64/libc.so.6 libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6 /lib64/libc.so.6: ld-linux-aarch64.so.1 (GLIBC_PRIVATE) => /lib/ld-linux-aarch64.so.1 ld-linux-aarch64.so.1 (GLIBC_2.17) => /lib/ld-linux-aarch64.so.1 ~~~ Environment variables: ~~~ # at the bottom of the ~/.bashrc # ... export ORACLE_HOME=/usr/lib/oracle/19.10/client64 export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$ORACLE_HOME/lib" export DYLD_LIBRARY_PATH="$ORACLE_HOME/lib:$DYLD_LIBRARY_PATH" export TNS_ADMIN="$ORACLE_HOME/lib/network/admin" export PATH="$ORACLE_HOME/bin:$PATH" export NLS_LANG=Japanese_Japan.AL32UTF8 export SQLPATH="$ORACLE_HOME" export ORACLE_PATH="$ORACLE_HOME" export ORA_NCHAR_LITERAL_REPLACE=TRUE ~~~ ~~~ [kojima@localhost ~]$ echo $ORACLE_HOME /usr/lib/oracle/19.10/client64 [kojima@localhost ~]$ echo $PATH /usr/lib/oracle/19.10/client64/bin:/home/kojima/.local/bin:/home/kojima/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin

I am trying to execute below Unix script to fetch the Oracle version from Windows command prompt using ssh command to connect to Unix terminal.

#!/use/bin/ksh
Freport=/tmp/test.txt
cd /usr/oracle2/product/11.2.0/bin
echo "Begin" > $Freport
set +x
/usr/oracle2/product/11.2.0/bin/sqlplus -V >> $Freport
set -x
pwd >> $Freport
echo "Completed" >> $Freport

Windows command prompt output:

Begin
/usr/oracle2/product/11.2.0/bin
Completed

Same script ran in Unix server and got below output. Putty output:

Begin

SQL*Plus: Release 11.2.0.1.0

/usr/oracle2/product/11.2.0/bin
Completed

I want to print the Oracle version in my Windows command prompt output. Windows command prompt execution:

C:\programfiles\PUTTY>putty.exe -ssh uname@ip -pw pwd -m windowsscriptpath/test.sh

Any idea how I can solve this?

I am trying to pass mount_point details in my oracle script. I am able to pass integer variable using below code but not able to send mount point details in oracle script: sed "s/@@pqr@@/$space/g" tablespace_extend.sql | sqlplus -s "/ as sysdba" BEGIN space:="@@pqr@@"; dbms_output.put_line(space); END; / When I am using same code to pass mount point details, it is not working. it returns this error message: sed: -e expression #1, char 13: unknown option to `s', mount_point = /u08/dbname/

I'm trying to insert records into a column in Oracle where the values are passed from a shell variable. The variable itself stores pattern generated from a list of files. This pattern is generated on each iteration inside a for loop. The variable values are each inserted into the table inside the for loop. But since the variable reads only one record at a time, it inserts only one row at a time. There are thousands of files being read. The code containing both commands which is ran inside sqlplus and the shell commands is ran as a function. Please find the below for the code:

function call_HEAD_INSERT
{
    FILES=/home/oracle/LOG_*.DAT
    for f in $FILES
    do
      #echo "Processing $f file..."
      # take action on each file. $f store current file name
      
      ptrn=grep "HEAD" $f
      #echo $ptrn
    	
       echo "set feedback off;
             set heading off;
             set serveroutput on size unlimited;
    
             VARIABLE GV_return_code    NUMBER;
                     VARIABLE GV_script_error   CHAR(255);
    
             EXEC :GV_return_code := 0;
    
             WHENEVER SQLERROR EXIT 1
    
             DECLARE
               L_error_message VARCHAR2(255);
            BEGIN
                 insert into user.customer(HEAD) values ('$ptrn');
    			commit;
            EXCEPTION
               WHEN OTHERS THEN
                  ROLLBACK;
                  :GV_return_code := 1;
                  :GV_script_error := SQLERRM;
            END;
             /
    
             print :GV_script_error;
             exit :GV_return_code;
             /" | sqlplus -s ${ORACLE_LOGIN} >> ${logFile}
    		
    done 
    return $?
}

Is there a way to speed up the script or query? I tried giving parallel hint to the query but that didn't really speed up the process. So is there any other way this process can be improved in speed either in script or inside PL/SQL? Ideally I would love to insert all the records in one go while here on each iteration the insert statement adds only one record. Any kind of suggestions are welcome.

Is it possible to request a variable directly in the terminal? For example, I want to use command cat , but I want the terminal to ask what file name to use. Just like in SQL plus I'm using bind variables for this. Is there any solution for terminal?

Trying to invoke a sql file from unix shells script. ExecuteSql1.sh

#!/bin/sh
## steps to get the connection and form it.
result=`sqlplus -S ${connectURL} << EOF
SET PAGES 0 lines 800
@ /sql/testQuery.sql ${LOGFILE} 
EOF`

echo $result

output of the above script (works as expected without exception) MODULUS BEFORE: 0 MODULUS AFTER: 16 No errors. ExecuteSql2.sh {**NOTE the starting space is PRESERVED below result variable**}

#!/bin/sh
result=`sqlplus -S ${dbConnect} << EOF
      SET PAGES 0 lines 800
      @ /sql/testQuery.sql ${LOGFILE};
      EOF`

echo $result

When executing ExecuteSql2.sh, the output looks like below: ExecuteSql2.sh: line 147: warning: here-document at line 144 delimited by end-of-file (wanted `EOF') MODULUS BEFORE: 0 MODULUS AFTER: 16 No errors. SP2-0042: unknown command "EOF" - rest of line ignored. -------- using, didn't know when using the `` built in command substitution with space causes this issue. Any specific reason for this? -------- testQuery.sql:

SET SERVEROUTPUT ON SIZE UNLIMITED
set heading off verify off feedback off echo off

SPOOL &1

declare
 modulus NUMBER := 0;
BEGIN
  DBMS_OUTPUT.PUT_LINE('MODULUS BEFORE: '||modulus);

select mod(100,21) into modulus from dual;

DBMS_OUTPUT.PUT_LINE('MODULUS AFTER: '||modulus);

end;
/

SET ECHO ON FEEDBACK ON
SHOW ERRORS
SPOOL OFF

here I'm trying to run a normal query with sqlplus and dump the result into CSV file, then I have another job to do, I facing problem my script does not continue after executing sqlplus query it just views the result and dumps the output into csv file but it does not continue also i don't know how to dump the data without view the result out #!/bin/bash cd /dir/test_dir sqlplus -s test/test <