Or perhaps the TNS_ADMIN location?
Rick Sullivan
312-606-4059 Office
630-670-5869 Cell
630-362-2452 BB Cell
-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x83972545.[Email address protected]
Sent: Friday, April 28, 2006 3:07 PM
To: LazyDBA Discussion
Subject: RE: ORA-12560: TNS:protocol adapter error
Also, you could set the ORACLE_SID environment.
-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x80576181.[Email address protected]
Sent: Friday, April 28, 2006 4:02 PM
To: LazyDBA Discussion
Subject: RE: ORA-12560: TNS:protocol adapter error
Sometimes, when I am being a LazyDBA, and I don't feel like searching
for the best answer, I use the connect string after the userid/password
and that works.
exp system/[Email address protected] full=y direct=y file=full.dmp
log=full.log consistent=y
you could add the buffer and recordlength parameters, if you want.
Please take a few minutes to provide feedback on the quality of service
you received. The Department of Education values your feedback as a
customer. Commissioner John L. Winn is committed to continuously
assessing and improving the level and quality of services provided to
you by Department staff. Simply use the link below. Thank you in
advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Dragana Kubura
[mailto:oracledba-ezmlmshield-x86801775.[Email address protected]
Sent: Friday, April 28, 2006 3:57 PM
To: LazyDBA Discussion
Subject: FW: ORA-12560: TNS:protocol adapter error
Any suggestions here...
-----Original Message-----
From: Dragana Kubura
[mailto:oracledba-ezmlmshield-x84567.[Email address protected]
Sent: Friday, April 28, 2006 12:04 PM
To: LazyDBA Discussion
Subject: ORA-12560: TNS:protocol adapter error
I have upgraded from Oracle 9.2.0.3 to Oracle 10.2.0.1 and I am trying
to export data remotely from another server in order to import it in my
10.2.0.1 database. This is the error I get:
EXP-00056: ORACLE error 12560 encountered
ORA-12560: TNS:protocol adapter error
EXP-00000: Export terminated unsuccessfully
I can successfully connect through sqlplus to the same server using the
same user .
Any suggestions???
Thanks
--------
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
--------
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