05-27-2008
connect sqlplus from unix
hi,
I have this basic query.
I have created a new user on unix.
I have given home directory and permission through chmod to create directory stucture.
Now need to connect sqlplus. What permissions should we give, so that this works?
Any help is appreciated.
Thanks,
Neha
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I want to write a script, in which I will connect to sqlplus and do a quary and then exit
sqlplus user/pwd@database
select count(*) from table
exit.
and write the result in a log file.
How to write it ?
Many thanks before. (1 Reply)
Discussion started by: big123456
1 Replies
2. Shell Programming and Scripting
I'm writting a shell script and at the begining I login to sqlplus by
sqlplus -l user_name/password@instance
what I would like is to check if the database is down or not , and if the database has started moved to the next step else sleep for a certain time and then check again .
I know how to... (4 Replies)
Discussion started by: aya_r
4 Replies
3. Shell Programming and Scripting
Hi
I am new to unix .I need a example program to connect oracle10g DB from shell script.The task is to connect sql from shellscript and to write a query inside to retieve some fiels.The reseult should be stored in a seperate .dat file(by using spool).
Thanks
Bala. (1 Reply)
Discussion started by: tobalajia
1 Replies
4. UNIX for Dummies Questions & Answers
HI Guys,
i just want ask the steps when trying to create a simple SQL select statement in linux.
I know how to use the select statement in SQLplus, but im having a difficult time in having a unix script connect direct to SQL plus and then retrieve the selected statement.
example.... (2 Replies)
Discussion started by: mdap
2 Replies
5. Shell Programming and Scripting
We had a requirement like we should find the user whoever logged into sqlplus through UNIX automatically.
For that we should write a script and store the result in file.
we will get that user manually by using WHO command.
can anybody help me how to trigger?
I tried many commands beyond... (1 Reply)
Discussion started by: siri_886
1 Replies
6. UNIX for Advanced & Expert Users
Hi,
I have been trying to connect to sqlplus the same way I used to do in my earlier company but I get these error messages , please suggest way out -
user name - xyzuser
schema name - xyzschema
$ sqlplus xyzuser@xyzschema
ksh: sqlplus: not found.
$ sqlplus -s xyzuser@xyzschema... (5 Replies)
Discussion started by: dhirajdsharma
5 Replies
7. Shell Programming and Scripting
I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'.
What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies
8. Shell Programming and Scripting
I have a unix shell script that calls two Select Queries using sqlplus as shown below.
more extract.sh
result=$(sqlplus -s usr/swd@myhost_sid @/tmp/SELECT_QUERY.run)
more @/tmp/SELECT_QUERY.run
SELECT PROBLEM_TYPE, COUNT (*) FROM BATCH WHERE UPPER (STATUS) = 'NEW' AND PROB_TYPE... (1 Reply)
Discussion started by: mohtashims
1 Replies
9. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
10. UNIX for Beginners Questions & Answers
hi guys
i have a sqlplus :
sqlplus -s username/password << EOF
@mysql.sql
EOF
in mysql.sql there is a count of a table, i want to write in a variabile unix.
how can i do?
Thanks a lot
Regards
Francesco. (3 Replies)
Discussion started by: Francesco_IT
3 Replies
LEARN ABOUT OSF1
shtrashcan
mktrashcan(1) General Commands Manual mktrashcan(1)
NAME
mktrashcan, rmtrashcan, shtrashcan - Attaches, detaches, or shows a trashcan directory
SYNOPSIS
/usr/sbin/mktrashcan trashcan directory...
/usr/sbin/rmtrashcan directory...
/usr/sbin/shtrashcan directory...
OPERANDS
Specifies the directory that contains files that were deleted from attached directories. Whenever you delete a file in the specified
directory, the file system automatically moves the file to the trashcan directory. Specifies the directory that you attach to a trashcan
directory.
DESCRIPTION
The trashcan utilities (mktrashcan and rmtrashcan) enable you to attach or detach an existing directory, which you specify as a trashcan
directory, to any number of directories within the same fileset.
A trashcan directory stores the files that are deleted with the unlink system call. For instance, you can use the mktrashcan utility to
attach a trashcan directory called /usr/trashcan to one or more directories; thereafter, when you delete a file from one of the attached
directories, the file system moves the file to the /usr/trashcan directory. Note that when more than one directory shares attachment to a
trashcan directory, files with the same file name can overwrite each other in the trashcan directory.
If you mistakenly delete a file, use the mv command to return the file from the /usr/trashcan directory to its original directory.
When you enter shtrashcan at the system prompt, the system shows the trashcan directory, if one exists, for the directory you specified.
It is important that trashcan directories have correct access permissions. If the permissions are too restrictive, then it may be impossi-
ble to remove files from the directories that are attached to the trashcan directory. In general, all users and groups that expect to use
the trashcan directory need write permission to the directory. If unexpected "permission denied" errors occur when deleting files that are
in a directory attached to a trashcan directory, use the chmod command to change the permissions on the trashcan directory.
RESTRICTIONS
The directory and trashcan directories must be in the same fileset; however, you can attach the trashcan directory to any directory within
the fileset.
EXAMPLES
The following example creates and attaches a trashcan directory, /usr/trashcan, to two directories, /usr/ray and /usr/projects/sql/test,
which are in the same fileset. The chmod command adds write permission for all users and groups on the new trashcan directory. % mkdir
/usr/trashcan % chmod a+w /usr/trashcan % mktrashcan /usr/trashcan /usr/ray /usr/projects/sql/test To attach the trashcan directory,
/usr/trashcan, to all subdirectories in the /usr directory, enter: % mktrashcan /usr/trashcan /usr/*
New subdirectories that you add beneath the /usr directory are not attached to the trashcan directory until you attach them. Also,
the mktrashcan utility distinguishes between directories and files, attaching only directories to the trashcan directory.
Note that an attached directory produces an EDUPLICATE_DIRS (-1165) error when /usr/trashcan is itself in the directory path you
attach to (as in the previous example). You can ignore this error message.
SEE ALSO
advfs(4), mkfset(8), showfsets(8)
mktrashcan(1)