Using Oracle data Pump in scripts without password?

Posted on 2012-08-12
Last Modified: 2013-10-22
I would like to use impdp in a shell script without using the sys password.  I am setting the Oracle SID in the script before using "impdp / DUMPFILE=dmp1.dmp, dmp2.dmp PARALLEL=2 LOGFILE=dmp.log FULL=y".
Question by:micbuchanan
    LVL 23

    Expert Comment

    - to run the script without any password, you will need to run it as the OS User that is in the “DBA”/"ORADBA" group of the OS, and just uses ‘/ as sysdba’ in the script:

    expdp '/ as sysdba' DUMPFILE=dmp1.dmp, dmp2.dmp PARALLEL=2 LOGFILE=dmp.log FULL=y
    LVL 36

    Accepted Solution

    you don't need to import (or even export) with the sys user
    this is only upon oracle support request

    you can setup a user with grants for the full export
    or with specific grants
    LVL 76

    Assisted Solution

    by:slightwv (䄆 Netminder)
    I agree, you should not import as sys.

    You can set up OS Authentication and use '/' without 'as sysdba'.
    LVL 22

    Expert Comment

    by:Steve Wales
    I've requested that this question be closed as follows:

    Accepted answer: 500 points for slightwv's comment #a38287369

    for the following reason:

    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
    LVL 36

    Expert Comment

    by:Geert Gruwez
    points should be divided or not only given to an expert who agrees with a given comment
    the given comment should at least be accepted too

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    733 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now