Thanks for the question, Gyan Bahadur.
Asked: March 07, 2017 - 9:29 am UTC
Last updated: March 07, 2017 - 9:31 am UTC
Version: 11.2.0.4
Viewed 1000+ times
You Asked
I have create the directory object and grant the user hr to the read, write on directory object, and run the followng command as:
expdp hr/hr@192.168.0.131 tables=test1, test2 directory=test_dir dumpfile=test.dmp logfile=test.log
show the following error:
UDE-12504: operation generated ORACLE error 12504
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
the configuration of listener.ora file is:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = test.database.com)(PORT = 1521))
(service_data=
(service_name=orcl))
)
ADR_BASE_TEST = /u01/app/oracle
, is any error in listener.ora file???
and Connor said...
It is not
expdp hr/hr@192.168.0.131
it would be
expdp hr/hr@orcl
which then does a lookup into your tnsnames.ora to see the 'orcl' means
- connect to host 'test.database.com' on port 1521, requesting service 'orcl'
Is this answer out of date? If it is, please let us know via a Comment