| Export Command Related [message #267596] |
Thu, 13 September 2007 16:54  |
dineshcr
Messages: 8
Registered: November 2006
|
Junior Member |
|
|
When I try to run the oracle “export “ command on UNIX environment , I got the following error message, I am not sure what setting should I check on UNIX to fix this error, I have verified the listener status, listener seems to be working fine and I can connect to database from windows client.
Please let me know, what environment variables needs to set ( I tried setting ORACLE_HOME and LIBPATH but export still not working )
Thanks
EXP-00056: ORACLE error 12541 encountered
ORA-12541: TNS:no listener
EXP-00000: Export terminated unsuccessfully
|
|
|
|
| Re: Export Command Related [message #267598 is a reply to message #267596] |
Thu, 13 September 2007 17:03  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
Here is what we know:
>EXP-00056: ORACLE error 12541 encountered
>ORA-12541: TNS:no listener
>EXP-00000: Export terminated unsuccessfully
Here is what we don't know:
Actual OS name and version.
Oracle version to FOUR decimal places
The actual command syntax that failed.
Where (on which system) is the database you want to export from actually exists; relative to where this "Unix environment" is.
>listener seems to be working fine and I can connect to database from windows client.
Above is positive news, but what happens when you try using SQL*Plus from unix environment?
Use CUT & PASTE plus use of <code tags> to respond as described in the #1 STICKY post at top of this forum.
[Updated on: Thu, 13 September 2007 17:04] by Moderator Report message to a moderator |
|
|
|
| Re: Export Command Related [message #267744 is a reply to message #267598] |
Fri, 14 September 2007 10:51 |
dineshcr
Messages: 8
Registered: November 2006
|
Junior Member |
|
|
Thanks for your reply.
Here are the details:
OS Name and Version: HP-UX ssaora B.11.00 A 9000/800
Oracle version : Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
Tnsnames:
listener=(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS= (PROTOCOL=tcp)(HOST=10.10.211.222)(PORT=1525))
)
(CONNECT_DATA=(SID=SCAR)
)
)
Command failed:
connect bac/bac@listener
ORA-12154: TNS:could not resolve service name
Am I using the wrong connect string, I can connect to database from windows oracle SQL*Plus client. Using following command
connect bac/bac@listener
|
|
|
|
|
|
| Re: Export Command Related [message #267751 is a reply to message #267750] |
Fri, 14 September 2007 12:44 |
dineshcr
Messages: 8
Registered: November 2006
|
Junior Member |
|
|
$ env | sort
COLUMNS=80
EDITOR=vi
ERASE=^H
HOME=/home/orauser
LINES=25
LOGNAME=u017176
MAIL=/var/mail/u017176
MANPATH=/usr/share/man/%L:/usr/share/man:/usr/contrib/man/%L:/usr/contrib/man:/usr/local/man/%L:/usr/local/man:/opt/upgrade/share/man /%L:/opt/upgrade/share/man:/usr/dt/share/man:/opt/pd/share/man/%L:/opt/pd/share/man:/opt/hparray/share/man/%L:/opt/hparray/share/man: /opt/ignite/share/man/%L:/opt/ignite/share/man
PATH=/usr/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/nettladm/bin:/opt/fc/bin:/opt/fcms/bin:/opt/upgrade/bin:/opt/pd/bin:/usr/bin/X11:/us r/contrib/bin/X11:/opt/hparray/bin:/wf/sw/bin:.
PWD=/home/u017176
SHELL=/usr/bin/sh
SWDIR=/wf/sw
TERM=ansi
TZ=EST5EDT
_=/usr/bin/env
|
|
|
|
|
|
| Re: Export Command Related [message #267753 is a reply to message #267752] |
Fri, 14 September 2007 13:32 |
dineshcr
Messages: 8
Registered: November 2006
|
Junior Member |
|
|
I did set ORACLE_HOME, using following, it's not in the previous env list since I logged out and logged in back after this settings.
Any other settings that I am missing other than ORACLE_HOME, I am sure this might not be the issue.
export ORACLE_HOME=/u01/app/oracle/product/8.1.7
export ORACLE_BIN=$ORACLE_HOME/bin
export PATH=$PATH:$ORACLE_HOME:$ORACLE_BIN
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
