Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

DMP File Import Failed #49

Open
Cheau opened this issue Nov 2, 2018 · 0 comments
Open

DMP File Import Failed #49

Cheau opened this issue Nov 2, 2018 · 0 comments

Comments

@Cheau
Copy link

Cheau commented Nov 2, 2018

I run the command below to start a container with a test.dmp file inside the sh_sql_dmp_files directory to get it auto import:

docker run -d --restart=always --name oracle -p 8080:8080 -p 1521:1521 -v /docker/oracle/data:/u01/app/oracle -v /docker/oracle/init/sh_sql_dmp_files:/docker-entrypoint-initdb.d sath89/oracle-xe-11g

Then I print the log:

Database not initialized. Initializing database.
Setting up:
processes=500
sessions=555
transactions=610
If you want to use different parameters set processes, sessions, transactions env variables and consider this formula:
processes=x
sessions=x*1.1+5
transactions=sessions*1.1

Oracle Database 11g Express Edition Configuration
-------------------------------------------------
This will configure on-boot properties of Oracle Database 11g Express
Edition.  The following questions will determine whether the database should
be starting upon system boot, the ports it will use, and the passwords that
will be used for database accounts.  Press <Enter> to accept the defaults.
Ctrl-C will abort.

Specify the HTTP port that will be used for Oracle Application Express [8080]:
Specify a port that will be used for the database listener [1521]:
Specify a password to be used for database accounts.  Note that the same
password will be used for SYS and SYSTEM.  Oracle recommends the use of
different passwords for each database account.  This can be done after
initial configuration:
Confirm the password:

Do you want Oracle Database 11g Express Edition to be started on boot (y/n) [y]:
Starting Oracle Net Listener...Done
Configuring database...Done
Starting Oracle Database 11g Express Edition instance...Done
Installation completed successfully.
Setting sys/system passwords
Database initialized. Please visit http://#containeer:8080/apex to proceed with configuration
Oracle Database 11g Express Edition instance is already started

Starting import scripts from '/docker-entrypoint-initdb.d':
f337c90696eea6f432f25246383345ad  /docker-entrypoint-initdb.d/test.dmp
Import finished

Database ready to use. Enjoy! ;)

It seems that auto import is successful. When I connect the database to execute SQL select * from all_tables, however, none of the tables in test.dmp can be found. Also, the user credential for the import is not exist according to this guide:

In case of using DMP imports dump file should be named like ${IMPORT_SCHEME_NAME}.dmp
User credentials for imports are ${IMPORT_SCHEME_NAME}/${IMPORT_SCHEME_NAME}

As the instructions and logs of auto import are limited, can anyone figure out what the problem is ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant