Oracle-xe on Ubuntu 18.04 - Installation and impdpSYS.DBMS_INTERNAL_LOGSTDBY causes error on dump...
In the Lost in Space intro why was Dr. Smith actor listed as a special guest star?
What does "move past people" mean in this context?
How to regain lost focus?
Will the duration of traveling to Ceres using the same tech developed for going to Mars be proportional to the distance to go to Mars or not?
How can I keep my gold safe from other PCs?
Reason for small-valued feedback resistors in low noise Op Amp
What is an explicit bijection in combinatorics?
How do I narratively explain how in-game circumstances do not mechanically allow a PC to instantly kill an NPC?
Coworker asking me to not bring cakes due to self control issue. What should I do?
Is layered encryption more secure than long passwords?
Is practicing on a digital piano harmful to an experienced piano player?
Taking an academic pseudonym?
Why is Shelob considered evil?
How can I differentiate duration vs starting time
Sets that are both Sum-free and Product-free
What is wrong with my use of "find -print0"?
Buying a "Used" Router
In a post apocalypse world, with no power and few survivors, would Satnav still work?
Linearity Assumption
Is having explosions as a go to solution considered bad table manners?
If I tried and failed to start my own business, how do I apply for a job without job experience?
What is an efficient way to digitize a family photo collection?
Is there any danger of my neighbor having my wife's signature?
Inline Feynman diagrams, Feynman diagrams in equations, very small Feynman diagrams
Oracle-xe on Ubuntu 18.04 - Installation and impdp
SYS.DBMS_INTERNAL_LOGSTDBY causes error on dump importOracle 11g R2 installation on Ubuntu 14.04 LTSMongoDB installation Ubuntu 12.04 LTS errorsPgAdmin 4 installation on Debian/UbuntuOracle XE 11 on Ubuntu Server 16.04 - Install issuesCan Microsoft SQL Server be installed on Ubuntu 18.04 LTS?Workbench freezes on connecting after Ubuntu 18.04 upgradeMariaDB startup failure on Ubuntu 18.04Error while installing Oracle 11g in Ubuntu 18.04Impdp (Oracle 12c) on Ubuntu 16.04
Setup:
- 10 GB partition ext3 mounted at /u01
- 5 GB swap
- Oracle-xe oracle-xe-11.2.0-1.0.x86_64.rpm - installed with alien and then dpkg
- Followed instructions from https://community.oracle.com/thread/2229554
Problem:
After installation I do /etc/init.d/oracle-xe configure all default values. All went well.
And what comes next?
I have to import db.dmp.
But there isn't any db mounted.
So I tried createdb.sh from /u01/app/oracle/product/11.2.0/xe/config/scripts
It goes well.
Next I execute sqls that creates scheme.
Next I would like to import dump file.
But the impdp "/ as sysdba" schemas=DBV remap_schema=DBV:application directory=DATA_PUMP_DIR dumpfile=db.dmp logfile=db-import-$(date +%d-%b-%H_%M).log EXCLUDE=ROLE_GRANT reports the following:
UDI-01034: operation generated ORACLE error 1034
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
UDI-00003: all allowable logon attempts failed
My question is, what steps should I take after installation with dkpg to create empty oracle-xe db ready to use and import dumps?
ubuntu oracle-xe
edited 29 secs ago
McNets
15.9k42061
asked 9 mins ago
Piotr DajlidoPiotr Dajlido
1011
New contributor
Piotr Dajlido is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Setup:
- 10 GB partition ext3 mounted at /u01
- 5 GB swap
- Oracle-xe oracle-xe-11.2.0-1.0.x86_64.rpm - installed with alien and then dpkg
- Followed instructions from https://community.oracle.com/thread/2229554
Problem:
After installation I do /etc/init.d/oracle-xe configure all default values. All went well.
And what comes next?
I have to import db.dmp.
But there isn't any db mounted.
So I tried createdb.sh from /u01/app/oracle/product/11.2.0/xe/config/scripts
It goes well.
Next I execute sqls that creates scheme.
Next I would like to import dump file.
But the impdp "/ as sysdba" schemas=DBV remap_schema=DBV:application directory=DATA_PUMP_DIR dumpfile=db.dmp logfile=db-import-$(date +%d-%b-%H_%M).log EXCLUDE=ROLE_GRANT reports the following:
UDI-01034: operation generated ORACLE error 1034
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
UDI-00003: all allowable logon attempts failed
My question is, what steps should I take after installation with dkpg to create empty oracle-xe db ready to use and import dumps?
ubuntu oracle-xe
edited 29 secs ago
McNets
15.9k42061
asked 9 mins ago
Piotr DajlidoPiotr Dajlido
1011
New contributor
Piotr Dajlido is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Post the output ofps -ef | grep smonandenv | grep ORA.
– Balazs Papp
5 mins ago
add a comment |
Setup:
- 10 GB partition ext3 mounted at /u01
- 5 GB swap
- Oracle-xe oracle-xe-11.2.0-1.0.x86_64.rpm - installed with alien and then dpkg
- Followed instructions from https://community.oracle.com/thread/2229554
Problem:
After installation I do /etc/init.d/oracle-xe configure all default values. All went well.
And what comes next?
I have to import db.dmp.
But there isn't any db mounted.
So I tried createdb.sh from /u01/app/oracle/product/11.2.0/xe/config/scripts
It goes well.
Next I execute sqls that creates scheme.
Next I would like to import dump file.
But the impdp "/ as sysdba" schemas=DBV remap_schema=DBV:application directory=DATA_PUMP_DIR dumpfile=db.dmp logfile=db-import-$(date +%d-%b-%H_%M).log EXCLUDE=ROLE_GRANT reports the following:
UDI-01034: operation generated ORACLE error 1034
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
UDI-00003: all allowable logon attempts failed
My question is, what steps should I take after installation with dkpg to create empty oracle-xe db ready to use and import dumps?
ubuntu oracle-xe
edited 29 secs ago
McNets
15.9k42061
asked 9 mins ago
Piotr DajlidoPiotr Dajlido
1011
New contributor
Piotr Dajlido is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Setup:
- 10 GB partition ext3 mounted at /u01
- 5 GB swap
- Oracle-xe oracle-xe-11.2.0-1.0.x86_64.rpm - installed with alien and then dpkg
- Followed instructions from https://community.oracle.com/thread/2229554
Problem:
After installation I do /etc/init.d/oracle-xe configure all default values. All went well.
And what comes next?
I have to import db.dmp.
But there isn't any db mounted.
So I tried createdb.sh from /u01/app/oracle/product/11.2.0/xe/config/scripts
It goes well.
Next I execute sqls that creates scheme.
Next I would like to import dump file.
But the impdp "/ as sysdba" schemas=DBV remap_schema=DBV:application directory=DATA_PUMP_DIR dumpfile=db.dmp logfile=db-import-$(date +%d-%b-%H_%M).log EXCLUDE=ROLE_GRANT reports the following:
UDI-01034: operation generated ORACLE error 1034
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
UDI-00003: all allowable logon attempts failed
My question is, what steps should I take after installation with dkpg to create empty oracle-xe db ready to use and import dumps?
ubuntu oracle-xe
ubuntu oracle-xe
edited 29 secs ago
McNets
15.9k42061
asked 9 mins ago
Piotr DajlidoPiotr Dajlido
1011
New contributor
Piotr Dajlido is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 29 secs ago
McNets
15.9k42061
asked 9 mins ago
Piotr DajlidoPiotr Dajlido
1011
New contributor
Piotr Dajlido is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 29 secs ago
McNets
15.9k42061
edited 29 secs ago
McNets
15.9k42061
edited 29 secs ago
McNets
15.9k42061
15.9k42061
asked 9 mins ago
Piotr DajlidoPiotr Dajlido
1011
New contributor
Piotr Dajlido is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 9 mins ago
Piotr DajlidoPiotr Dajlido
1011
asked 9 mins ago
Piotr DajlidoPiotr Dajlido
1011
1011
New contributor
Piotr Dajlido is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Piotr Dajlido is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Piotr Dajlido is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Post the output ofps -ef | grep smonandenv | grep ORA.
– Balazs Papp
5 mins ago
add a comment |
Post the output ofps -ef | grep smonandenv | grep ORA.
– Balazs Papp
5 mins ago
Post the output of
ps -ef | grep smon and env | grep ORA.– Balazs Papp
5 mins ago
Post the output of
ps -ef | grep smon and env | grep ORA.– Balazs Papp
5 mins ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Piotr Dajlido is a new contributor. Be nice, and check out our Code of Conduct.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230552%2foracle-xe-on-ubuntu-18-04-installation-and-impdp%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Piotr Dajlido is a new contributor. Be nice, and check out our Code of Conduct.
Piotr Dajlido is a new contributor. Be nice, and check out our Code of Conduct.
Piotr Dajlido is a new contributor. Be nice, and check out our Code of Conduct.
Piotr Dajlido is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f230552%2foracle-xe-on-ubuntu-18-04-installation-and-impdp%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Post the output of
ps -ef | grep smonandenv | grep ORA.– Balazs Papp
5 mins ago