hello -
Is it possible to connect to a database at the command line to an Oracle instance whilst logged in on the unix box i.e. not using a script
Cheers
(Running Solaris)
Also if anyone has any info on how a Citirix ICA client might be helpful here that would be appreciated
Cheers (1 Reply)
Hi,
While i am trying to connect to Oracle database from Perl using DBI module,am getting the error as follows :
Can't load '/usr/local/fuseperl-modules/lib/i586-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libwtc9.so: cannot open shared object file: No such file... (4 Replies)
if;
sql="select username from dba_users where username = '$FromUser';"
check_FromUser=`ExecSql "$sql"`
I want to connect to Oracle database & check the users in the database, store the value in check_FromUser.
First how to connect to Oracle database from the shell script ?
Appreciate your... (4 Replies)
I am trying to develop a script that can connect to a DB2 database mainframe and Query the database and display the results. I've been researching, but I have yet to find a definitive solution where I can enter in the Mainframe DB2 address db2:// and query the database and return the results. If... (2 Replies)
Hi,
Am running my client in Windows and the database (IBM DB2) is in AIX machine. if I open my client its not connecting to the database at first time and failing in a particular SQL Query. But if I close the client and open again then its connecting and the query is also working fine. Don't... (0 Replies)
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)
Hi,
My requirement is to generate a single text output which fetches data from two different databases. I have two different sqrs to generate text file1(data from db1) and file2(data from db2). can I execute both the sqrs from a single shell script? If yes, pls let me know how to connect to db2... (1 Reply)
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)
Hi experts.
I have different database and schema and their passwords in one file.
In Unix : I want to create the script that connect the sqlplus and execute the select query one by one schema with different database.
Ex: password File Format
databse schemaname password
DB1 name1 ... (1 Reply)
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
LEARN ABOUT HPUX
fs_whereis
FS_WHEREIS(1) AFS Command Reference FS_WHEREIS(1)NAME
fs_whereis - Reports each file server housing a file or directory
SYNOPSIS
fs whereis [-path <dir/file path>+] [-help]
fs whe [-p <dir/file path>+] [-h]
DESCRIPTION
The fs whereis command returns the name of each file server machine that houses the volume containing each directory or file named by the
-path argument.
OPTIONS -path <dir/file path>+
Names each AFS file or directory for which to return the host file server machine. Partial pathnames are interpreted relative to the
current working directory, which is also the default value if this argument is omitted.
-help
Prints the online help for this command. All other valid options are ignored.
OUTPUT
The output includes a line for each specified directory or file. It names the file server machine on which the volume that houses the
specified directory or file resides. A list of multiple machines indicates that the directory or file is in a replicated volume.
Machine names usually have a suffix indicating their cell membership. If the cell is not clear, use the fs whichcell command to display the
cell in which the directory or file resides. To display the cell membership of the local machine, use the fs wscell command.
EXAMPLES
The following example indicates that volume housing the directory /afs/abc.com resides is replicated on both "fs1.abc.com" and
"fs3.abc.com":
% fs whereis -path /afs/abc.com
File /afs/abc.com is on hosts fs1.abc.com fs3.abc.com
PRIVILEGE REQUIRED
None
SEE ALSO fs_whichcell(1), fs_wscell(1)COPYRIGHT
IBM Corporation 2000. <http://www.ibm.com/> All Rights Reserved.
This documentation is covered by the IBM Public License Version 1.0. It was converted from HTML to POD by software written by Chas
Williams and Russ Allbery, based on work by Alf Wachsmann and Elizabeth Cassell.
OpenAFS 2012-03-26 FS_WHEREIS(1)