Error during running sqlplus command from shell script in Solaris
I am using following code to connect to oracle database from solaris shell script. which will try thrice to connect the database ...at the 4rth atempt it will exir=t.
I have a script which connects to different database servers using sqlplus. Is there a way by which I can run a shell command on that host from sqlplus?
I know about 'host' command but it runs script on the local machine where the original script is running. Is there a way to run command on the... (9 Replies)
Hello
i have a shell script. it is running fine when i manually run at command prompt using following command
./script_file
but while running shell script from crontab, it is giving error in each line. (2 Replies)
hi,
I am using a shell script from where i will be conecting to sqlplus..
i am having a problem in passing a variable to sqlplus query..
i will be assigning the variable in the unix environment..whenever i am trying to pass a variable having the contents greater than 2500 characters, i am... (3 Replies)
I am running a shell file following script on bash shell in solaris 10
(
echo abc@orcl
echo abc
echo "set feedback off"
echo "truncate table SIndexDataTypeHst1_changes;"
) | sqlplus -s
but getting the following error
ERROR:
ORA-01005: null password given; logon denied
... (3 Replies)
cron job not running the sqlplus command in shell script but the shell script works fine from command line..
Cronjob:
5 * * * * /home/dreg/script.sh
script.sh:
#!/bin/ksh
/oracle/u000/app/oracle/product/10204/GEN/bin/sqlplus -s <user>/<pass>@<sid/home/dreg/sqlscript.sh
... (18 Replies)
Hi,
Can someone please help me here with this one.
This is my script:
# more tosh.sh
#!/usr/bin/ksh
clear
. /home/oracle/.profile
echo "Good morning, world."
export ORACLE_HOME=/u01/app/oracle/product/9.0.1
export PATH=$ORACLE_HOME/bin:/usr/local/bin
export ORACLE_SID=xxxx
... (11 Replies)
Hi all,
I am using the below given sqlplus command in my unix script to invoke a stored procedure which returns a value .It works fine.
RET_CODE=$(/opt/oracle/product/10.2.0.4.CL/bin/sqlplus -S $USER/$PASSWD@$DB_NAME <<EOF
EXEC MY_PKG.MY_SP (:COUNT);
PRINT COUNT;
commit;
... (6 Replies)
Hi All,
Is there any way where we can run few commands with different shell in a shell script ?
Let's have an example below,
My first line in script reads below,
#!/bin/sh
However due to some limitation of "/bin/sh" shell I wanted to use "/bin/bash" while executing few... (9 Replies)
Hi all,
on AIX 6.1 I want to run the following but for 5 DB. How should I do that ? Using FOR, WHILE ???? How ?
export ORACLE_SID=DB1
sqlplus / as sysdba << EOF
whenever sqlerror exit sql.sqlcode;
whenever oserror exit FAILURE
set define off
set head off
set feedback off
set echo off... (1 Reply)
Hello All,
Good Afternoon.
I am new to this platform and I need one small help regarding running a SQL file from Bat file. Below is what I am doing,
1. I placed the below command in one Bat file.
start putty.exe -ssh user@host -pw pwd -m C:\2.txt
2. In 2.txt, I have below command.
... (3 Replies)
Discussion started by: PavanPatil
3 Replies
LEARN ABOUT PHP
udm_alloc_agent
UDM_ALLOC_AGENT(3) 1 UDM_ALLOC_AGENT(3)udm_alloc_agent - Allocate mnoGoSearch sessionSYNOPSIS
resource udm_alloc_agent (string $dbaddr, [string $dbmode])
DESCRIPTION
Allocate a mnoGoSearch session.
PARAMETERS
o $dbaddr
-$dbaddr - URL-style database description, with options (type, host, database name, port, user and password) to connect to SQL
database. Do not matter for built-in text files support. Format for $dbaddr: DBType:[//[DBUser[:DBPass]@]DBHost[:DBPort]]/DBName/.
Currently supported DBType values are: mysql, pgsql, msql, solid, mssql, oracle, and ibase. Actually, it does not matter for
native libraries support, but ODBC users should specify one of the supported values. If your database type is not supported, you
may use unknown instead.
o $dbmode
-$dbmode - You may select the SQL database mode of words storage. Possible values of $dbmode are: single, multi, crc, or crc-
multi. When single is specified, all words are stored in the same table. If multi is selected, words will be located in different
tables depending of their lengths. "multi" mode is usually faster, but requires more tables in the database. If "crc" mode is
selected, mnoGoSearch will store 32 bit integer word IDs calculated by CRC32 algorithm instead of words. This mode requires less
disk space and it is faster comparing with "single" and "multi" modes. crc-multi uses the same storage structure with the "crc"
mode, but also stores words in different tables depending on words lengths like in "multi" mode.
Note
$dbaddr and $dbmode must match those used during indexing.
RETURN VALUES
Returns a mnogosearch agent identifier on success, FALSE on failure. This function creates a session with database parameters.
NOTES
Note
In fact this function does not open a connection to the database and thus does not check the entered login and password. Establish-
ing a connection to the database and login/password verification is done by udm_find(3).
PHP Documentation Group UDM_ALLOC_AGENT(3)