Documentation Center

Procedure: Execute mkdumpdir.pl for the first time

As an Oracle DBA on the Oracle server, execute mkdumpdir.pl with all four command-line options, noting the following:

The first time this script is executed, to establish the default Directory Object, you must specify the following directory...

-dir XY_DBDUMP_DIR

...and you must specify the corresponding default Directory Object directory path created during the prerequisite steps:

-path <default_Directory_Object_dirpath>

Sample command line:

mkdumpdir.pl -dir XY_DBDUMP_DIR -path
E:\oracle\DBs\dump\xydump -sid <sid> -syspwd <pwd>

The script first checks for existing directories. If the specified Directory Object exists at the specified path, the script reports an informational message indicating that the specified directory is already created.

If the object exists but with a different path, you will be prompted with a message such as the following:

INFO: dir ‘<dirname>’ already exists with path
‘<serverpath>’. Do you want to change the path? (y/n)

If you answer anything but ‘y’, the script exits.

If the directory needs to be created, the script first attempts to check that it is being run on the Oracle server and not a client. If it cannot detect a server installation, it reports a warning such as the following:

WARNING: This utility should be run only on the Oracle
server. Any directory path you create must be on the server
with Oracle read/write permission. Continue? (y/n)

If you answer anything but ‘y’, the script exits.

If the specified path doesn’t already exist, the script reports that is creating the filesystem directory specified by the -path that you provided, and creating or modifying the Directory Object specified by the -dir that you provided.

Finally, the script proceeds to the permissioning step, checking users and database schemas (Contenta databases) and granting read/write permissions.

After the script exits, you can confirm the Directory Objects using SQLPlus with:

select directory_name||’=’||directory_path from
dba_directories;

where the double pipe characters indicate string concatenation.