10-16-2001
Not unless you wrote a "wrapper" script for it that checks the current working directory, then executes the sqlplus executable. I wouldn't recommend naming them the same, though, and I definitely wouldn't want to change the name of the sqlplus binary... better to call it something like "sql+", and tell users to call it that way instead...
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
On my FTP server (Darwin/Mac OS X -- pretty much FreeBSD), I need to apply the following permissions to a directory:
1. A specific owner with full access
2. A specific group with full access
3. A specific group with read-only access
4. No access whatsoever for everyone else
I understand... (5 Replies)
Discussion started by: TyHockett
5 Replies
2. UNIX for Advanced & Expert Users
Hello Everyone,
if we log on to unix server how do we find that what permissions/roles and priveleges are assigned to any particular user.
Here i am not talking about the file permissions.
Thanks (1 Reply)
Discussion started by: hardesh
1 Replies
3. UNIX for Dummies Questions & Answers
Hope I'm in the right place to ask this.
... and I'm a total noob by the way.
When changing an account password through telnet, everything seems fine. I can telnet back in afterward, but if I try to use sqlplus to get in it tells me password invalid. If I try to get in through sqlplus with the... (1 Reply)
Discussion started by: tazman4
1 Replies
4. Shell Programming and Scripting
Can someone tell me how to execute sqlplus command.
I`m Executing:
sqlplus user/pasw @/report/output/new/PlatformOut_Cdrs.sql
the error is:
SQL*Plus: Release 9.2.0.5.0 - Production on Wed Aug 9 15:37:44 2006
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:... (3 Replies)
Discussion started by: Nel
3 Replies
5. Shell Programming and Scripting
Hi all,
I am new to SQLPLUS, can anyone tell me what is the following codes doing?
DECLARE
cursor c1 is select bts_int_id,
max(ave_busy_tch/res_av_denom14) maxBusyTch
from p_nbsc_res_avail
where to_char(period_start_time,'yyyymmdd')=to_char((sysdate-1),'yyyymmdd')
group by... (4 Replies)
Discussion started by: antkiu
4 Replies
6. Shell Programming and Scripting
I am looking to loop round a load of files and execute each in sqlplus, I have looked at the forum to see what was posted in the past, but most of the examples seem to use the sql being passed in through the script, which is not really what I am looking for, can someone tell me if the code below is... (9 Replies)
Discussion started by: LiquidChild
9 Replies
7. Shell Programming and Scripting
I am trying to connect to one of the oracle sever using uni through sqlplus
command: sqlplus -s BOXI_ALPH_AUDITOR,Q078_audit$@Q047
But its not getting connected. I tried using some different server using same syntax its working. What differene i found is the password is having no special... (2 Replies)
Discussion started by: gander_ss
2 Replies
8. Shell Programming and Scripting
When i run the following script am getiing the output correct but i want to get it in the form of a table, could any one help me please. the script is a s follows
count=`sqlplus -s $ORACLE_ACCOUNT << EOF
set heading off
set wrap on
set feedback off
column ChangeNumber format a12
column... (9 Replies)
Discussion started by: jhon1257
9 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 and Linux Applications
Hi all,
i face an error related to my server ""it's running server"" when i use sqlplus command
$ sqlplus
bash: sqlplus: command not found
the data base is up and running i just need to access the sqlplus to import the dump file as a daily backup.
i already check the directory... (4 Replies)
Discussion started by: clerck
4 Replies
LEARN ABOUT CENTOS
pivot_root
PIVOT_ROOT(2) Linux Programmer's Manual PIVOT_ROOT(2)
NAME
pivot_root - change the root file system
SYNOPSIS
int pivot_root(const char *new_root, const char *put_old);
Note: There is no glibc wrapper for this system call; see NOTES.
DESCRIPTION
pivot_root() moves the root file system of the calling process to the directory put_old and makes new_root the new root file system of the
calling process.
The typical use of pivot_root() is during system startup, when the system mounts a temporary root file system (e.g., an initrd), then
mounts the real root file system, and eventually turns the latter into the current root of all relevant processes or threads.
pivot_root() may or may not change the current root and the current working directory of any processes or threads which use the old root
directory. The caller of pivot_root() must ensure that processes with root or current working directory at the old root operate correctly
in either case. An easy way to ensure this is to change their root and current working directory to new_root before invoking pivot_root().
The paragraph above is intentionally vague because the implementation of pivot_root() may change in the future. At the time of writing,
pivot_root() changes root and current working directory of each process or thread to new_root if they point to the old root directory.
This is necessary in order to prevent kernel threads from keeping the old root directory busy with their root and current working direc-
tory, even if they never access the file system in any way. In the future, there may be a mechanism for kernel threads to explicitly
relinquish any access to the file system, such that this fairly intrusive mechanism can be removed from pivot_root().
Note that this also applies to the calling process: pivot_root() may or may not affect its current working directory. It is therefore rec-
ommended to call chdir("/") immediately after pivot_root().
The following restrictions apply to new_root and put_old:
- They must be directories.
- new_root and put_old must not be on the same file system as the current root.
- put_old must be underneath new_root, that is, adding a nonzero number of /.. to the string pointed to by put_old must yield the same
directory as new_root.
- No other file system may be mounted on put_old.
See also pivot_root(8) for additional usage examples.
If the current root is not a mount point (e.g., after chroot(2) or pivot_root(), see also below), not the old root directory, but the mount
point of that file system is mounted on put_old.
new_root does not have to be a mount point. In this case, /proc/mounts will show the mount point of the file system containing new_root as
root (/).
RETURN VALUE
On success, zero is returned. On error, -1 is returned, and errno is set appropriately.
ERRORS
pivot_root() may return (in errno) any of the errors returned by stat(2). Additionally, it may return:
EBUSY new_root or put_old are on the current root file system, or a file system is already mounted on put_old.
EINVAL put_old is not underneath new_root.
ENOTDIR
new_root or put_old is not a directory.
EPERM The calling process does not have the CAP_SYS_ADMIN capability.
VERSIONS
pivot_root() was introduced in Linux 2.3.41.
CONFORMING TO
pivot_root() is Linux-specific and hence is not portable.
NOTES
Glibc does not provide a wrapper for this system call; call it using syscall(2).
BUGS
pivot_root() should not have to change root and current working directory of all other processes in the system.
Some of the more obscure uses of pivot_root() may quickly lead to insanity.
SEE ALSO
chdir(2), chroot(2), stat(2), initrd(4), pivot_root(8)
COLOPHON
This page is part of release 3.53 of the Linux man-pages project. A description of the project, and information about reporting bugs, can
be found at http://www.kernel.org/doc/man-pages/.
Linux 2012-07-13 PIVOT_ROOT(2)