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 DEBIAN
radsqlrelay
RADSQLRELAY(8) FreeRADIUS helper program RADSQLRELAY(8)
NAME
radsqlrelay - relay SQL queries to a central database server
SYNOPSIS
radsqlrelay [-?] [-d sql_driver] [-b database] [-f file] [-h host] [-u user] [-P port] [-p password] [-1] [-x] file_path
DESCRIPTION
radsqlrelay tails a SQL logfile and forwards the queries to a database server. Used to replicate accounting records to one (central) data-
base, even if the database has extended downtime.
The SQL logfile is created by the rlm_sql_log module. The module must be configured in the radiusd server before you can use radsqlrelay.
OPTIONS
-? Print usage help information.
-d sql_driver
Driver to use: mysql, pg, oracle.
-b database
Name of the database to use.
-f file
Read password from file, instead of command line.
-h host
Connect to host.
-u user
User for login.
-P port
Port number to use for connection.
-p password
Password to use when connecting to server.
-1 One-shot mode: push the file to database and exit.
-x Turn on debugging.
file_path
The pathname of the SQL logfile to use.
NOTES
Oracle driver
The command "radsqlrelay -d oracle -b db.domain.tld sql-relay" reads the database description stored in $TNS_ADMIN/tnsnames.ora:
db.domain.tld =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db.domain.tld)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = <DB SID>)
)
)
SEE ALSO
rlm_sql_log(5)
AUTHOR
Nicolas Baradakis <nicolas.baradakis@cegetel.net>
19 June 2005 RADSQLRELAY(8)