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
Sure, allways has been. Unless I am missing something obvious, you simply use sqlplus. Some things that you may need some help with though are as follows:
1. Find out the database instance your want to connect to; you DBA can tell you.
2. Source the Oracle environment file, which is typically kept in /usr/local/bin called oraenv (for sh, ksh, etc.)
3. When prompted for database, enter the name from step 1.
If oraenv doesn't prompt you for a path, you are finished; run sqlplus.
If oraenv does prompt you for a path, make sure your database name is correct and, if it is, you can either ask the DBA for the path for ORACLE_HOME or you can have a look in a file called "oratab". This is located typically in /var/opt/oracle. Alternatively, it may be located in /etc.
Good luck.
Thomas
P.S. Probably can't answer any Cytrix questions, I used 4 times probably. I may still have a client on my PC so if there isn't anyone else who can answer, I may be able to dig up an answer.
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 all,
In my concern they gave a task to me do cran job like
To write a shell script for
To connect a database
it should execute a query
it should save the output of the query
after getting the output it should send a mail to you inbox for every one hour
I can able to... (8 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 SUNOS
shells
shells(4) File Formats shells(4)NAME
shells - shell database
SYNOPSIS
/etc/shells
DESCRIPTION
The shells file contains a list of the shells on the system. Applications use this file to determine whether a shell is valid. See getuser-
shell(3C). For each shell a single line should be present, consisting of the shell's path, relative to root.
A hash mark (#) indicates the beginning of a comment; subsequent characters up to the end of the line are not interpreted by the routines
which search the file. Blank lines are also ignored.
The following default shells are used by utilities: /bin/bash, /bin/csh, /bin/jsh, /bin/ksh, /bin/pfcsh, /bin/pfksh, /bin/pfsh, /bin/sh,
/bin/tcsh, /bin/zsh, /sbin/jsh, /sbin/sh, /usr/bin/bash, /usr/bin/csh, /usr/bin/jsh, /usr/bin/ksh, /usr/bin/pfcsh, /usr/bin/pfksh,
/usr/bin/pfsh, and /usr/bin/sh, /usr/bin/tcsh, /usr/bin/zsh. Note that /etc/shells overrides the default list.
Invalid shells in /etc/shells may cause unexpected behavior (such as being unable to log in by way of ftp(1)).
FILES
/etc/shells lists shells on system
SEE ALSO vipw(1B), ftpd(1M), sendmail(1M), getusershell(3C), aliases(4)SunOS 5.10 4 Jun 2001 shells(4)