11-22-2011
I am invoking sqlplus by just typing sqlplus on the command line. Then it is asking for username and password which I am entering in and ending up with an error Target host doesn't exist. I see that I have to set environment variable called ORACLE_HOME to the directory where oracle was installed. This is exactly what my question was.
How do I set a environment variable in linux that points to a windows server directory assuming that windows and linux are in the same network?
10 More Discussions You Might Find Interesting
1. Solaris
Hello everybody .. i want connect with smbclient to an windows server 2003 with active directory. Exist a version of samba that can do this?
Thank you very much for your time.
Good Luck :b: (3 Replies)
Discussion started by: enkei17
3 Replies
2. Windows & DOS: Issues & Discussions
Hi
i am writing a script in unix where after some validations, i require the script to connect to a windows server and then kich off a batch file there. i tried ftp and got the error message that "the remote host refused an attempted connect operation".
I am able to connect to this unix... (4 Replies)
Discussion started by: vidzz911
4 Replies
3. Shell Programming and Scripting
Hi All,
I need to connect windows server by unix shell script then search the directory for some keyword in all files in that directory...
Windows Server is \\wh01ad04
Please help me and thanks in advance (2 Replies)
Discussion started by: Pratik4891
2 Replies
4. Shell Programming and Scripting
Hi everyone,
I have oracle 9i installed in Windows XP and i have ubuntu in VM WARE.
I would like to know how to connect to Oracle in windows xp from Linux through shel scripting...... (3 Replies)
Discussion started by: Zimbu
3 Replies
5. Red Hat
I want to connect RHEL server from my windows 7 Professional machine graphically. I logged into 1 RHEL server with IP, 10.101.17.80 using Putty from my Windows 7 professional machine. Now from this server, 10.101.17.80, I want to connect to another RHEL server 10.101.17.79. I used,
ssh -X... (1 Reply)
Discussion started by: RHCE
1 Replies
6. Windows & DOS: Issues & Discussions
Hi,
We are running Linux server and are required to connect to Windows server and fetch the files from windows server.
How can i connect to Windows server from Linux? I have to do this with a automated shell script on Linux
I appreciate your response. (4 Replies)
Discussion started by: reachmexyz
4 Replies
7. Shell Programming and Scripting
I am trying to connect to Windows server via Linux server through a script and run two commands " cd and ls " But its giving me error saying " could not start the program" followed by the command name i specify e g : "cd"
i am trying in this manner "
ssh username@servername "cd... (5 Replies)
Discussion started by: sunil seelam
5 Replies
8. Linux
Hi my name is Manju.
->I have configure the two way authentication on my linux server.
->Now I am able to apply two way authenticator on particuler user.
->Now I want to map this linux server to my AD server.
->Kindly tell me how to map AD(Active Directory) with this linux server.
... (0 Replies)
Discussion started by: manjusharma128
0 Replies
9. AIX
Hi,
I followed this procedure in order to mount in AIX a shared folder in windows server 2000.
https://www-304.ibm.com/support/docview.wss?uid=isg3T1012550
Ive tested the shared folder from other windows Server, and its fine.
What Ive do in AIX is:
Logon as root
Under /Home/spss/ I... (2 Replies)
Discussion started by: trevian3969
2 Replies
10. Shell Programming and Scripting
Hi,
I am facing an issue in connecting to database from Linux shell script. Here is my code
export ORACLE_BASE=xxx
export ORACLE_SID=xxx
export ORACLE_HOME=xxxx
DB_PATH=xxx/'yyy@yy'
UserId=`sqlplus -s $DB_PATH <<EOF
set head off feedback off
select max(USER_ID)+1 from USERS;... (6 Replies)
Discussion started by: yuvi
6 Replies
LEARN ABOUT PHP
oci_set_client_info
OCI_SET_CLIENT_INFO(3) OCI_SET_CLIENT_INFO(3)
oci_set_client_info - Sets the client information
SYNOPSIS
bool oci_set_client_info (resource $connection, string $client_info)
DESCRIPTION
Sets the client information for Oracle tracing.
The client information is registered with the database when the next 'roundtrip' from PHP to the database occurs, typically when an SQL
statement is executed.
The client information can subsequently be queried from database administration views such as V$SESSION.
The value may be retained across persistent connections.
PARAMETERS
o $connection
-An Oracle connection identifier, returned by oci_connect(3), oci_pconnect(3), or oci_new_connect(3).
o $client_info
- User chosen string up to 64 bytes long.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Setting the client information
<?php
$c = oci_connect('hr', 'welcome', 'localhost/XE');
// Record the client information
oci_set_client_info($c, 'My Application Version 2');
// Code that causes a roundtrip, for example a query:
$s = oci_parse($c, 'select * from dual');
oci_execute($s);
oci_fetch_all($s, $res);
sleep(30);
?>
// While the script is running, the administrator can see the client
// information:
sqlplus system/welcome
SQL> select client_info from v$session;
NOTES
Note
Oracle version requirement
This function is available when PHP is linked with Oracle Database libraries from version 10 g onwards.
Tip
Performance
With older versions of OCI8 or the Oracle Database, the client information can be set using the Oracle DBMS_APPLICATION_INFO pack-
age. This is less efficient than using oci_set_client_info(3).
Caution
Roundtrip Gotcha
Some but not all OCI8 functions cause roundtrips. Roundtrips to the database may not occur with queries when result caching is
enabled.
SEE ALSO
oci_set_module_name(3), oci_set_action(3), oci_set_client_identifier(3).
PHP Documentation Group OCI_SET_CLIENT_INFO(3)