Sponsored Content
Top Forums Shell Programming and Scripting Connecting to Oracle Database Post 302167805 by srikanthgr1 on Friday 15th of February 2008 01:44:52 PM
Old 02-15-2008
Just a Small Question

Hi Pals..

I have a shell script Which is calling a .sql file.

Code:
#!/bin/ksh
sqlplus -s userID/password@DB_INSTANCE @Test.sql & 
sqlplus -s  userID/password@DB_INSTANCE << EOF
exit
EOF

Is there any thing wrong in the above Code Snippet ???

The Test.sql and Testsql.sh are in the same directory ..
 

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problem in Connecting to Oracle Database using KornShell

Hello, I am very new to Scripting. I am having a Kornshell Script below for connecting to Oracle database. But getting an error while executing it. #!/bin/ksh ssh -X root@192.168.2.127 <perimuka> sleep 5 su - oracle sqlplus <mraghunandanan>/<peri123> <<eof Can anyone tell what is wrong... (3 Replies)
Discussion started by: mraghunandanan
3 Replies

2. Shell Programming and Scripting

Connecting to oracle database from shell script

Hi all, I am satyakiran , i am new to the forum. i never done shell scripts for connecting to the data base (oracle) and fetching the data from the database( thru sql select statements ) i want to know 1. how to connect to the data base(oracle) using shell script 2. how to retrieve data... (8 Replies)
Discussion started by: satyakiran
8 Replies

3. Shell Programming and Scripting

Connecting to Database

Hi, I want to write a shell script which connects to a Database, executes a set of SQLs and displays a message for every SQL that was run whether any records have been returned or not? Can anyone help me in this regard? Appreciate your help and concern. Thanks, Dave (1 Reply)
Discussion started by: yoursdavinder
1 Replies

4. Shell Programming and Scripting

Connecting to oracle database

Hai i want to connect to oracle database from user input and create a view. ${ECHO} "Debut Creating View" ${ECHO} "Please Enter the User Name:" read user_name ${ECHO} "Please Enter the Connection String:" read con_string ${ECHO} "Please Enter the Password:" read pwd... (3 Replies)
Discussion started by: shenthil76
3 Replies

5. Solaris

Connecting to Oracle database

Hi guys, long time no typing :D I have problems when I try to connect to Oracle database from SQL Developer which is located on my Windows box. Server is running Solaris 11/11 and Oracle 11 enterprise. I can log in locally with sys account to database, start it up and shut it down but when I... (2 Replies)
Discussion started by: solaris_user
2 Replies

6. UNIX and Linux Applications

Identify a specific environment Oracle variable to connect a remote Oracle database ?

Good evening I nned your help pls, In an unix server i want to connect to a remote oracle databse server by sqlplus. I tried to find out the user/passwd and service name by env variable and all Ive got is this: ORACLE_SID_REPCOL=SCL_REPCOL ORACLE_SID=xmeta ORACLE_SID_TOL=SCL_PROTOLCOL... (2 Replies)
Discussion started by: alexcol
2 Replies
quota(1)						      General Commands Manual							  quota(1)

NAME
quota - displays disk usage and limits SYNOPSIS
quota [-agGuUqv] quota [-a] [-g] [groupname] [-qv] quota [-a] [-G] [groupID] [-qv] quota [-a] [-u] [username] [-qv] quota [-a] [-U] [userID] [-qv] OPTIONS
Displays quota information for all mounted file systems: those in the /etc/fstab file and those mounted manually or with automount. The -q option takes precedence over the -a option. When specified without the groupname argument, displays group quotas for groups of which you are a member. Displays group quotas for the group when you specify groupname. When specified without the groupID argument, displays group quotas for groups of which you are a member. Displays group quotas for the group when you specify groupID. Displays only your user quotas (the default) when specified without the username argument. Displays user quotas for the user when you specify username. Displays only your user quotas (the default) when specified without the userID argument. Displays user quotas for the user when you specify userID. Displays information only for file systems that have disk quotas and where usage is over quota. Takes precedence over the -v and -a options. Displays quota information for all mounted file systems that are specified in the /etc/fstab file. Quota information is dis- played for each file system whether or not quotas are enabled for it. The -q option takes precedence over the -v option. DESCRIPTION
The quota command displays disk space usage and limits. Disk quotas are displayed as 1 kilobyte blocks. By default, only your user quotas are displayed. If you use the -g or the -G option without an argument, the quota command displays group quotas for groups of which you are a member. Unless you use the -v option, the quota command reports only on file systems listed in /etc/fstab that have disk quotas and under which you have files. If quota exits with a status of 1, one or more file systems are over quota. If quota exits with a status of 2, there are sys- tem errors. NOTES
The term file system represents either a UFS file system or an AdvFS fileset. Do not use both a user and a group option in the same command. RESTRICTIONS
You must be the root user to use the optional username or userID argument to view information about another user, or to use the optional groupname or groupID argument to view information about a group to which you do not belong. FILES
Contains user quotas for each file system. Contains group quotas for each file system. Contains file system names and locations. SEE ALSO
edquota(8), quot(8), quotacheck(8), quotaon(8), quotaoff(8), repquota(8), quotactl(2), fstab(4) quota(1)
All times are GMT -4. The time now is 06:57 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy