Orace-xe on Ubuntu 18.04 - Installation and impdpSYS.DBMS_INTERNAL_LOGSTDBY causes error on dump importOracle...
Using functions like sine, cosine and tangent to calculate coordinates in Tikz
Is the UK legally prevented from having another referendum on Brexit?
Is Screenshot Time-tracking Common?
"Those books belong to him, don't they / aren't they?" – tag questions for state verbs
Can someone explain what a key is?
What is an efficient way to digitize a family photo collection?
How do I add a strong "onion flavor" to the biryani (in restaurant style)?
Is the percentage symbol a constant?
How do I avoid the "chosen hero" feeling?
Can't figure out a htaccess rule
Expression for "unconsciously using words (or accents) used by a person you often talk with or listen to"?
Manager has noticed coworker's excessive breaks. Should I warn him?
How can changes in personality/values of a person who turned into a vampire be explained?
Disk space full during insert, what happens?
How can I give a Ranger advantage on a check due to Favored Enemy without spoiling the story for the player?
How can I handle players killing my NPC outside of combat?
Inline Feynman diagrams, Feynman diagrams in equations, very small Feynman diagrams
Converting numbers to words - Python
Is the Maximum Use License for Everybody (MULE) a FOSS license?
Taking an academic pseudonym?
What is the meaning of "usr"?
What could cause an entire planet of humans to become aphasic?
Is the tritone (A4 / d5) still banned in Roman Catholic music?
Linearity Assumption
Orace-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
asked 3 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
asked 3 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
asked 3 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
asked 3 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 3 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 3 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 3 mins ago
Piotr DajlidoPiotr Dajlido
1011
asked 3 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.
add a comment |
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%2forace-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%2forace-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
