09-18-2006
This is answer
check the above link same question was answered there.
please use search on forum you will find plenty of same thread.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a script that passes a parameter to the sqlplus command that looks like the following:
#!/bin/sh
TARGET_SID=$1
AUXILIARY_SID=$2
sqlplus 'sys@$AUXILIARY_SID as sysdba' @shutdown.sql
I keep getting the following error:
ERROR:
ORA-12154: TNS:could not resolve service name... (4 Replies)
Discussion started by: renichols
4 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. UNIX for Dummies Questions & Answers
i'm having real problems retrieving the returncode of my sqlplus-call. I found a lot of informations on the net, but havn't been able to get it running so far, so now i ask for some help ;)
I do start the sqlplus out of my shell script with the parameters stored in the proc_clips.sql, which is... (6 Replies)
Discussion started by: maco_home
6 Replies
4. Shell Programming and Scripting
Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
Discussion started by: Hara
2 Replies
5. UNIX for Dummies Questions & Answers
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 (1 Reply)
Discussion started by: nehak
1 Replies
6. Shell Programming and Scripting
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Discussion started by: praka
6 Replies
7. Shell Programming and Scripting
Hi
I want to connect to the Oracle database using a username/password and get back the query result(a numeric value) in a variable, which I can then compare using a conditional.
Can anybody help me with this.
Thanks
Gaurav (4 Replies)
Discussion started by: gaurav_1711
4 Replies
8. 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
9. 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
10. 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
LEARN ABOUT DEBIAN
globus_url_t
globus_url_t(3) globus common globus_url_t(3)
NAME
globus_url_t -
SYNOPSIS
Data Fields
char * scheme
globus_url_scheme_t scheme_type
char * user
char * password
char * host
unsigned short port
char * url_path
char * dn
char * attributes
char * scope
char * filter
char * url_specific_part
Detailed Description
Parsed URLs.
This structure contains the fields which were parsed from an string representation of an URL. There are no methods to access fields of this
structure.
Field Documentation
char* globus_url_t::scheme
A string containing the URL's scheme (http, ftp, etc)
globus_url_scheme_t globus_url_t::scheme_type
An enumerated scheme type. This is derived from the scheme string
char* globus_url_t::user
The username portion of the URL. [ftp, gsiftp]
char* globus_url_t::password
The user's password from the URL. [ftp, gsiftp]
char* globus_url_t::host
The host name or IP address of the URL. [ftp, gsiftp, http, https, ldap, x-nexus
unsigned short globus_url_t::port
The TCP port number of the service providing the URL [ftp, gsiftp, http, https, ldap, x-nexus].
char* globus_url_t::url_path
The path name of the resource on the service providing the URL. [ftp, gsiftp, http, https]
char* globus_url_t::dn
The distinguished name for the base of an LDAP search. [ldap]
char* globus_url_t::attributes
The list of attributes which should be returned from an LDAP search. [ldap]
char* globus_url_t::scope
The scope of an LDAP search. [ldap]
char* globus_url_t::filter
The filter to be applied to an LDAP search [ldap].
char* globus_url_t::url_specific_part
An unparsed string containing the remaining text after the optional host and port of an unknown URL, or the contents of a x-gass-cache URL
[x-gass-cache, unknown].
Author
Generated automatically by Doxygen for globus common from the source code.
Version 14.7 Tue Nov 27 2012 globus_url_t(3)