Hi David,
The first entry in your tnsnames.ora file is the original entry for your
Instance and your Instance Name or SID is actp and you will be able to
connect using alias ACTPDEV.
Now, the question comes is what is the Second entry doing there and what
does it mean.. well I've tried to explain that below:
The Second entry is for configuring an External Procedure environment
for different $ORACLE_HOME's on Windows NT. For the configuration of
external procedures you need a tsnnames.ora entry:
extproc_connection_data. This entry is hardcoded and cannot be
changed. Using multiple 'extproc_connection_data' entries in one
tnsnames.ora is not permitted.
Hope this explains you query.
Regards,
Rahul Dutta
-----Original Message-----
From: Miles Flint
[mailto:oracledba-ezmlmshield-x55399566.[Email address protected]
Sent: Tuesday, May 31, 2005 11:55 AM
To: LazyDBA Discussion
Subject: RE: how can I run exp from my Oracle 9i client on Windows
Hi David
The one with the word <sid> I am unsure of ,
I am familiar with the one with service name and that's how mine are.
A good way to get the hang of things is to use net configuration
assistant
to set up the TNS entry and than look at what it puts in the tnsnames
file.
Many Thanks
Miles
Miles Flint
System Architect
Laduma Project Team
Phone (+27) 11 677 6304
Cell (+27) 82 805 5339
-----Original Message-----
From: DXiang [mailto:[Email address protected]
Sent: 30 May 2005 05:20
To: [Email address protected]
Subject: RE: how can I run exp from my Oracle 9i client on
Windows
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
Miles,
Thank you for your reponse. I still have some questions like:
on my tnsnames.ora file, I have one entry without SID
ACTPDEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = cdsd005)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = actp)
)
)
And another entry with SID:
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
Should I use the above SID? It looks very strange becuase none of my
three
servers has this kind of SID.
Thank you very much for any hints.
David Xiang
Canadian Depository For Securities Ltd.
85 Richmond St. West.
Toronto, Ontario
M5H 2C9
(416) 815-2029
email: [Email address protected]
|---------+------------------------------------------------------->
| | "Miles Flint " |
| | [Email address protected]
| | azyDBA.com> |
| | |
| | 05/30/2005 10:26 AM |
| | |
|---------+------------------------------------------------------->
>-----------------------------------------------------------------------
----
-------------------|
|
|
| To: "LazyDBA Discussion" [Email address protected]
|
| cc:
|
| Subject: RE: how can I run exp from my Oracle 9i client on
Windows |
>-----------------------------------------------------------------------
----
-------------------|
Create a .bat file containing
*//
time /t
exp [Email address protected] parfile=export_params.txt
time /t
pause
//*
Than a .txt file containing
*//
file = tables_20050414.dmp
tables = (item_combination,item_dependency,adm_item_map,item)
feedback = 13332
buffer = 1024001
log =tables_exp_20050414.log//*/
ensure the <sid> is in your local tnsnames.ora
run the .bat flee
Many Thanks
Miles
Miles Flint
System Architect
Laduma Project Team
Phone (+27) 11 677 6304
Cell (+27) 82 805 5339
-----Original Message-----
From: DXiang
[mailto:oracledba-ezmlmshield-x40760661.[Email address protected]
Sent: 30 May 2005 04:19
To: LazyDBA Discussion
Subject: how can I run exp from my Oracle 9i client on Windows
Hey DBAs,
I have a 9i client(Windows) and three servers(two V8.1.6 and one V9.2,
UNIX). I want to use the client to connect to one of the V8.1.6 servers
to
exp data. How can I do that? I can use SQL PLUS on the client to connect
to
one of the servers by specifying host string, but I don't know how to
specify my server in the exp command. Is there any environment variable
that I need to set up?
Any help would be greatly appreciated.
David Xiang
Canadian Depository For Securities Ltd.
85 Richmond St. West.
Toronto, Ontario
M5H 2C9
(416) 815-2029
email: [Email address protected]
The information in this e-mail is confidential, privileged and is
subject
to copyright. It is intended solely for the addressee(s) named. Access
to
this e-mail by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any action taken or
omitted to be taken in reliance on it is prohibited and may be unlawful
and
we ask that you notify us immediately by telephone at (416) 365-8400 or
reply by e-mail to the sender. When addressed to our participants or
other
clients, any information contained in this e-mail is subject to the
terms
and conditions expressed in any applicable agreement governing the use
of
CDS services.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page