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

Oracle LazyDBA home page