Unix tutorial : Unix Shell Script to connect Oracle database

Unix tutorial : Unix Shell Script to connect Oracle database

This tutorial will show you how to connect oracle database using the command line in Unix.

Here Unix shell scripting is used to connect the database using the sqlplus command.

And you can see how to retrieve data from database using the shell script

1)Oracle tutorial : How to connect oracle database using sqlplus command line

2)Job In Oracle : pl sql create job in Oracle Scheduler

You can learn useful shell scripts for oracle dba
oracle scripts for dba in unix
oracle dba scripts

Subscribe on youtube:

For more tutorial please visit #techquerypond

sqlplus connect to databaseoracle database monitoring shell scripts

[Technicalturbo]

Good .. new video with good knowledge of configuration files .

[bulu]

How to connect to a remote Oracle database ?

Service name won't be enough, how to provide the host and port along with the shell script

[carthikcr]

Sir I need to insert output of sed command in column of oracle table from Unix shell scripting.can you plz let me know how to do it

[Bharath_Tanuja]

If I need to point LDAP then what I need to do?? Please mention the syntax

[prasadkancharlaautomation]

Hi,
I have sqlplus client installed in machine A (under /u01/APPLTOP/dbclient/bin)
and in Machine B i have SQLPLUS DB available.
when i tried the script as suggestd.
i am getting error as :
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

can you help me to create a connection to DB from machine A

[crazycom]

I'm getting sqlplus: command not found error. Please let me know how to fix it

[roshanjohn]

Hi
video is nice :)
sqlplus -S, what does -S mean?
EOF?

Thanks

[akhtharbawazeer]

Thanks, can u plz tell me how to connect as sysdba

[passionatepravallika]

shell script to connect to oracle database