06-27-2011
A tnsnames.ora file is read by the Oracle listener when it starts on the computer where the database resides.
Another tnsnames file is read by the client computer to initialise the client-server session.
i.e. Each computer has its own copy.
The client and server copies should be consistent for the section relevant to that connection. They don't have to be identical because a server could offer multiple listeners for different purposes.
I can't see why tnsnames.ora would be mentioned in a unix .profile - even for account "oracle". The unix .profile is used to initalise a "telnet" session. It would be more ususal to mention tnsnames.ora in a script which starts the listener in background.
Tnsnames.ora - Oracle FAQ
Last edited by methyl; 07-01-2011 at 08:27 AM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I wanted to add /home/oracle/sql to my path so that from which ever directory i connect to sqlplus i should be able to source the .sql files sitting in /home/oracle/sql. Also,
this is what i tried but it doenst work
# Set up the search paths:
export ... (2 Replies)
Discussion started by: jigarlakhani
2 Replies
2. UNIX for Dummies Questions & Answers
Hi,
i am changing something in .profile file and then esc :wq!. when i do the cat i can see the changes. but to bring the .profile in memory i have to do . .profile.but it says error while doing that is . .profile
ksh: .profile: not found.
can any body help
thanks in advance
sam71 (7 Replies)
Discussion started by: sam71
7 Replies
3. UNIX for Dummies Questions & Answers
The “set -o vi” command won't run in the .profile. WHY?
This has me puzzled as the problem seems to be too simple, but can't figure it out. Here's the info...
Running...
Generic sun4u sparc SUNW,Ultra-5_10
K shell
Here's the .profile
# Copyright (c) 2001 by Sun Microsystems, Inc.
# All... (12 Replies)
Discussion started by: jimmyc
12 Replies
4. Shell Programming and Scripting
I am trying to execute my .profile which has the path to oracle home. But when I execute it with the below command it says nothing and when I try to echo the ORACLE_HOME I am still in my home directory itself which means it didn't get executed.
Please help how to make sure that .profile is... (6 Replies)
Discussion started by: dsravan
6 Replies
5. Solaris
for some reason my profile doesnt seem to be loading.
here is some info
$SHELL /sbin/sh
$HOME / (yup, im running at root, its a VM and im using it to learn)
created /.profile
added something simple to test, PS1="test"
logout and back in, open a terminal... prompt is still #
... (2 Replies)
Discussion started by: jrich523
2 Replies
6. Shell Programming and Scripting
Hi All,
I have trying to schedule an autosys job and it is failing. The shutdown script runs fine by itself from the UNIX box but fails when i try to schedule it through autosys.
I have compared user.env with auto.env (variables obtained through an autosys script) and updated my profile... (1 Reply)
Discussion started by: userscript
1 Replies
7. Shell Programming and Scripting
How can we hardcode TNS_ADMIN?
When i try to connect to db with the code below..i get TNS issue. So wpndering if i can hardcode TNS..
<html>
<head>
<title>xxxxxxxxxxxxxx</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<%
### Load modules, connect to... (2 Replies)
Discussion started by: rdhanek
2 Replies
8. Shell Programming and Scripting
I am new in shell scripting. currently i am using cygwin. My problem is
i created a profile file in my own folder. file name is first.profile in which i gave following values to variable
export a=10
now i am executing this profile file by below command
./.first.profile
it executed... (4 Replies)
Discussion started by: pratikjain998
4 Replies
9. UNIX for Dummies Questions & Answers
I am using MacOSX, and I decided to change the way my terminal looks. So, I created a ~/.profile file that has only the line
export PS1="\\u\ @ \\W \($0) \\$ \" ( '\u' displays the current user
'\W' displays the Working dir
and the weird numbers are colors)
It works fine when I log in... (3 Replies)
Discussion started by: TX0
3 Replies
10. UNIX for Beginners Questions & Answers
i have a bash_profile
in this profile there are my variable but when i do csh there aren't my variables .set
how can i do ?
regards
Franc (1 Reply)
Discussion started by: Francesco_IT
1 Replies
LEARN ABOUT PHP
oci_new_connect
OCI_NEW_CONNECT(3) OCI_NEW_CONNECT(3)
oci_new_connect - Connect to the Oracle server using a unique connection
SYNOPSIS
resource oci_new_connect (string $username, string $password, [string $connection_string], [string $character_set], [int $ses-
sion_mode])
DESCRIPTION
Establishes a new connection to an Oracle server and logs on.
Unlike oci_connect(3) and oci_pconnect(3), oci_new_connect(3) does not cache connections and will always return a brand-new freshly opened
connection handle. This is useful if your application needs transactional isolation between two sets of queries.
PARAMETERS
o $username
- The Oracle user name.
o $password
- The password for $username.
o $connection_string
-Contains the Oracle instance to connect to. It can be an Easy Connect string, or a Connect Name from the tnsnames.ora file, or
the name of a local Oracle instance. If not specified, PHP uses environment variables such as TWO_TASK (on Linux) or LOCAL (on
Windows) and ORACLE_SID to determine the Oracle instance to connect to. To use the Easy Connect naming method, PHP must be linked
with Oracle 10 g or greater Client libraries. The Easy Connect string for Oracle 10 g is of the form: [//]host_name[:port][/ser-
vice_name]. From Oracle 11 g, the syntax is: [//]host_name[:port][/service_name][:server_type][/instance_name]. Service names can
be found by running the Oracle utility lsnrctl status on the database server machine. The tnsnames.ora file can be in the Oracle
Net search path, which includes $ORACLE_HOME/network/admin and /etc. Alternatively set TNS_ADMIN so that $TNS_ADMIN/tnsnames.ora
is read. Make sure the web daemon has read access to the file.
o $character_set
-Determines the character set used by the Oracle Client libraries. The character set does not need to match the character set used
by the database. If it doesn't match, Oracle will do its best to convert data to and from the database character set. Depending on
the character sets this may not give usable results. Conversion also adds some time overhead. If not specified, the Oracle Client
libraries determine a character set from the NLS_LANG environment variable. Passing this parameter can reduce the time taken to
connect.
o $session_mode
-This parameter is available since version PHP 5 (PECL OCI8 1.1) and accepts the following values: OCI_DEFAULT, OCI_SYSOPER and
OCI_SYSDBA. If either OCI_SYSOPER or OCI_SYSDBA were specified, this function will try to establish privileged connection using
external credentials. Privileged connections are disabled by default. To enable them you need to set oci8.privileged_connect to
On. PHP 5.3 (PECL OCI8 1.3.4) introduced the OCI_CRED_EXT mode value. This tells Oracle to use External or OS authentication,
which must be configured in the database. The OCI_CRED_EXT flag can only be used with username of "/" and a empty password.
oci8.privileged_connect may be On or Off. OCI_CRED_EXT may be combined with the OCI_SYSOPER or OCI_SYSDBA modes. OCI_CRED_EXT is
not supported on Windows for security reasons.
RETURN VALUES
Returns a connection identifier or FALSE on error.
EXAMPLES
The following demonstrates how you can separate connections.
Example #1
oci_new_connect(3) example
<?php
// create table mytab (mycol number);
function query($name, $c)
{
echo "Querying $name
";
$s = oci_parse($c, "select * from mytab");
oci_execute($s, OCI_NO_AUTO_COMMIT);
$row = oci_fetch_array($s, OCI_ASSOC);
if (!$row) {
echo "No rows
";
} else {
do {
foreach ($row as $item)
echo $item . " ";
echo "
";
} while (($row = oci_fetch_array($s, OCI_ASSOC)) != false);
}
}
$c1 = oci_connect("hr", "welcome", "localhost/orcl");
$c2 = oci_new_connect("hr", "welcome", "localhost/orcl");
$s = oci_parse($c1, "insert into mytab values(1234)");
oci_execute($s, OCI_NO_AUTO_COMMIT);
query("basic connection", $c1);
query("new connection", $c2);
oci_commit($c1);
query("new connection after commit", $c2);
// Output is:
// Querying basic connection
// 1234
// Querying new connection
// No rows
// Querying new connection after commit
// 1234
?>
See oci_connect(3) for further examples of parameter usage.
SEE ALSO
oci_connect(3), oci_pconnect(3).
PHP Documentation Group OCI_NEW_CONNECT(3)