Re: impdp Issue

when connected with sqlplus / as sysdba current user environment will be used -  we already know, it is working properly

impdp is not a client process - it is client tool for background processes, so environment for background processes will be used

it(env) may highly depend on if you are using GI/Restart or not or how this specific Oracle instance was started, like was TNS_ADMIN set before starting instance or not

if GI/Restart is in use then you should additionally check environment of database/instance:

• srvctl getenv database
• srvctl getenv instance

additionally, check the env of pmon process of your instance for TNS_ADMIN if may be set on only by GI/Restart

• cat /proc/$(pgrep ora_pmon)/environ

Oleksandr Denysenko

11.09.2024 20:44, Jonathan Lewis пишет:
>
> The only thing I can think of at present is that you're allowed to use
> the database link when you connect to SQL*Plus but impdp does
> something that requires the link to be defined differently (e.g.
> you've got a private database link, but your use of impdp requires a
> public database link).
>
> Regards
> Jonathan Lewis
>
>
>
> On Tue, 10 Sept 2024 at 13:26, Scott Canaan
> <dmarc-noreply_at_freelists.org> wrote:
>
> I’m trying to import from one database to another via the
> network.  I’ve done this many, many times with no issues, until
> now.  I create the database link, put the entry in the
> tnsnames.ora file, and verified that all is good.  The tnsping
> returns correctly.  I can query the remote database from SQL*Plus
> with no issue, but when I try to run the impdp, I get:
>
> ORA-39001: invalid argument value
>
> ORA-39200: Link name "advcprod" is invalid.
>
> ORA-12154: TNS:could not resolve the connect identifier specified
>
> The source database is Oracle 12.1 on Red Hat 7, the destination
> database is Oracle 19 on Red Hat 8.  I’ve tried setting the SID
> and SERVICE_NAME in the tnsnames.ora file and it doesn’t matter, I
> get the same error either way.
>
> *Scott Canaan ‘88**
> */Sr Database Administrator
> /Information & Technology Services
> Finance & Administration
>
> *Rochester Institute of Technology
> *o: (585) 475-7886 | f: (585) 475-7520**
>
> _srcdco_at_rit.edu <mailto:srcdco_at_rit.edu>_| c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which
> it is addressed and may contain confidential and/or privileged
> material. Any review, retransmission, dissemination or other use
> of, or taking of any action in reliance upon this information by
> persons or entities other than the intended recipient is
> prohibited. If you received this in error, please contact the
> sender and destroy any copies of this information.
>

--
http://www.freelists.org/webpage/oracle-l