How do you create a new database with new sid on Oracle's pre-built 11g virtual machine?Oracle 11G Can't...
How did the USSR manage to innovate in an environment characterized by government censorship and high bureaucracy?
Can produce flame be used to grapple, or as an unarmed strike, in the right circumstances?
Does the average primeness of natural numbers tend to zero?
I’m planning on buying a laser printer but concerned about the life cycle of toner in the machine
I see my dog run
Some basic questions on halt and move in Turing machines
How is it possible for user's password to be changed after storage was encrypted? (on OS X, Android)
Is it legal to have the "// (c) 2019 John Smith" header in all files when there are hundreds of contributors?
How many letters suffice to construct words with no repetition?
"listening to me about as much as you're listening to this pole here"
Crop image to path created in TikZ?
Unbreakable Formation vs. Cry of the Carnarium
Is this food a bread or a loaf?
What do the Banks children have against barley water?
Shall I use personal or official e-mail account when registering to external websites for work purpose?
Could a US political party gain complete control over the government by removing checks & balances?
How would photo IDs work for shapeshifters?
What is the meaning of "of trouble" in the following sentence?
What is the command to reset a PC without deleting any files
Why did the Germans forbid the possession of pet pigeons in Rostov-on-Don in 1941?
Is Fable (1996) connected in any way to the Fable franchise from Lionhead Studios?
What does 'script /dev/null' do?
Is there a way to make member function NOT callable from constructor?
Why do we use polarized capacitors?
How do you create a new database with new sid on Oracle's pre-built 11g virtual machine?
Oracle 11G Can't create database from templateHow do I create an Oracle 11g user with read access to all tables/schemas?SQL Server to Oracle migrationHow can I launch SQL Developer?how do you recreate an table structure and table data that is on oracle database A to oracle database B?how do you change directory where an exported dump file is written to in oracle 11g?How do you import an exported dump file into a pre-built oracle 11g virtual machine?Unable to connect Oracle 11g server remotely after recovering Database on a new host?How to create a database user for oracle 11g on windows 8?How can I recover oracle database without new data?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
I downloaded DeveloperDaysVM2016-06-02_13.ova from http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html and successfully loaded it into Virtual Box.
I logged in as "oracle" user and I can see the desktop.
From within the virtual machine, I opened Firefox and navigated to:
http://localhost:8080/ords/hrrest/employees/ and successfully received a list of employees in JSON format. So I know the database is up and running.
I noticed the local pre-built database is on port 1521 using SID:XE by default.
Also, in order to access it from an external oracle Java driver I had to use the credentials "hr"/"oracle", which is the default credential for this virtual machine.
My question: Is there a wizard I can use to create a brand new database? Or, if there are commands that do this, what documentation shows how to do this?
I want a new database, with a new username and password, with a new ORACLE_SID.
How do I do this? Is there a link to oracle documentation that shows me how to do this? This virtual machine uses Oracle 11g.
Ideally, I would like to connect to this new database with a Java program using new credentials like:
username:newuser
password:newpass
localhost
1521
ORACLE_SID=newsid
oracle-11g
asked Jun 9 '17 at 21:40
user1068636user1068636
143115
bumped to the homepage by Community♦ 1 hour ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I downloaded DeveloperDaysVM2016-06-02_13.ova from http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html and successfully loaded it into Virtual Box.
I logged in as "oracle" user and I can see the desktop.
From within the virtual machine, I opened Firefox and navigated to:
http://localhost:8080/ords/hrrest/employees/ and successfully received a list of employees in JSON format. So I know the database is up and running.
I noticed the local pre-built database is on port 1521 using SID:XE by default.
Also, in order to access it from an external oracle Java driver I had to use the credentials "hr"/"oracle", which is the default credential for this virtual machine.
My question: Is there a wizard I can use to create a brand new database? Or, if there are commands that do this, what documentation shows how to do this?
I want a new database, with a new username and password, with a new ORACLE_SID.
How do I do this? Is there a link to oracle documentation that shows me how to do this? This virtual machine uses Oracle 11g.
Ideally, I would like to connect to this new database with a Java program using new credentials like:
username:newuser
password:newpass
localhost
1521
ORACLE_SID=newsid
oracle-11g
asked Jun 9 '17 at 21:40
user1068636user1068636
143115
bumped to the homepage by Community♦ 1 hour ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
You can not create a second instance (=database) with Oracle Express. Why do you think you need that? Just create new user (=schema) and use that.
– a_horse_with_no_name
Jun 9 '17 at 21:49
add a comment |
I downloaded DeveloperDaysVM2016-06-02_13.ova from http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html and successfully loaded it into Virtual Box.
I logged in as "oracle" user and I can see the desktop.
From within the virtual machine, I opened Firefox and navigated to:
http://localhost:8080/ords/hrrest/employees/ and successfully received a list of employees in JSON format. So I know the database is up and running.
I noticed the local pre-built database is on port 1521 using SID:XE by default.
Also, in order to access it from an external oracle Java driver I had to use the credentials "hr"/"oracle", which is the default credential for this virtual machine.
My question: Is there a wizard I can use to create a brand new database? Or, if there are commands that do this, what documentation shows how to do this?
I want a new database, with a new username and password, with a new ORACLE_SID.
How do I do this? Is there a link to oracle documentation that shows me how to do this? This virtual machine uses Oracle 11g.
Ideally, I would like to connect to this new database with a Java program using new credentials like:
username:newuser
password:newpass
localhost
1521
ORACLE_SID=newsid
oracle-11g
asked Jun 9 '17 at 21:40
user1068636user1068636
143115
I downloaded DeveloperDaysVM2016-06-02_13.ova from http://www.oracle.com/technetwork/database/enterprise-edition/databaseappdev-vm-161299.html and successfully loaded it into Virtual Box.
I logged in as "oracle" user and I can see the desktop.
From within the virtual machine, I opened Firefox and navigated to:
http://localhost:8080/ords/hrrest/employees/ and successfully received a list of employees in JSON format. So I know the database is up and running.
I noticed the local pre-built database is on port 1521 using SID:XE by default.
Also, in order to access it from an external oracle Java driver I had to use the credentials "hr"/"oracle", which is the default credential for this virtual machine.
My question: Is there a wizard I can use to create a brand new database? Or, if there are commands that do this, what documentation shows how to do this?
I want a new database, with a new username and password, with a new ORACLE_SID.
How do I do this? Is there a link to oracle documentation that shows me how to do this? This virtual machine uses Oracle 11g.
Ideally, I would like to connect to this new database with a Java program using new credentials like:
username:newuser
password:newpass
localhost
1521
ORACLE_SID=newsid
oracle-11g
oracle-11g
asked Jun 9 '17 at 21:40
user1068636user1068636
143115
asked Jun 9 '17 at 21:40
user1068636user1068636
143115
asked Jun 9 '17 at 21:40
user1068636user1068636
143115
asked Jun 9 '17 at 21:40
user1068636user1068636
143115
asked Jun 9 '17 at 21:40
user1068636user1068636
143115
143115
bumped to the homepage by Community♦ 1 hour ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 1 hour ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
You can not create a second instance (=database) with Oracle Express. Why do you think you need that? Just create new user (=schema) and use that.
– a_horse_with_no_name
Jun 9 '17 at 21:49
add a comment |
You can not create a second instance (=database) with Oracle Express. Why do you think you need that? Just create new user (=schema) and use that.
– a_horse_with_no_name
Jun 9 '17 at 21:49
You can not create a second instance (=database) with Oracle Express. Why do you think you need that? Just create new user (=schema) and use that.
– a_horse_with_no_name
Jun 9 '17 at 21:49
You can not create a second instance (=database) with Oracle Express. Why do you think you need that? Just create new user (=schema) and use that.
– a_horse_with_no_name
Jun 9 '17 at 21:49
add a comment |
1 Answer
1
active
oldest
votes
Are you sure that your Developer Days VM 2016-06-02_13 runs Oracle 11g? I'm using the same, and it reports:
SQL> select * from v$version;
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
CORE 12.1.0.2.0 Production 0
TNS for Linux: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0
Reading your questions/explanations, I cannot tell how familiar you are with 12c's "multitenant option", which "allows a single container database (CDB) to host multiple separate pluggable databases (PDB)" (see eg oracle-base.com). For starters, a new PDB may be just what you need ... an overview of Oracle Multitenant can be found here.
In this article, section "Where to get started", you can see that the SERVICE NAME (not the SID) is used for connecting to a PDB. More about PDBs (cloning etc), with screen shots, can be found here. SQLDeveloper (already installed on the Developer Days VM) is probably the best tool for getting started. I'm not aware of any "wizards" that one could use.
Using Java: When connecting to a PBD, using a JDBC driver, make sure that you use the service name (again: not the SID).
SID (for connections): it seems that the SID is only used for connecting to CDBs (not PDBs) nowadays. Although - I have also used the "service name" successfully for accessing CDBs.
answered Jun 11 '17 at 17:22
stefanstefan
2,152139
I downloaded the developer days VM sometime last year, and so it came with Oracle 11, not 12. I'm trying to stick to using Oracle 11 because that's what the customer is using. I'll look into the PDF stuff, but I'm not sure it will work in Oracle 11.
– user1068636
Jun 12 '17 at 18:01
Even the 2014 version of the Developer Days VM already had a Oracle 12c installation (see the third link in my answer). However, if you need to stick to 11g, all the "multitentant" documentation is probably no use to you.
– stefan
Jun 12 '17 at 18:40
add a comment |
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
});
}
});
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%2f175928%2fhow-do-you-create-a-new-database-with-new-sid-on-oracles-pre-built-11g-virtual%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Are you sure that your Developer Days VM 2016-06-02_13 runs Oracle 11g? I'm using the same, and it reports:
SQL> select * from v$version;
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
CORE 12.1.0.2.0 Production 0
TNS for Linux: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0
Reading your questions/explanations, I cannot tell how familiar you are with 12c's "multitenant option", which "allows a single container database (CDB) to host multiple separate pluggable databases (PDB)" (see eg oracle-base.com). For starters, a new PDB may be just what you need ... an overview of Oracle Multitenant can be found here.
In this article, section "Where to get started", you can see that the SERVICE NAME (not the SID) is used for connecting to a PDB. More about PDBs (cloning etc), with screen shots, can be found here. SQLDeveloper (already installed on the Developer Days VM) is probably the best tool for getting started. I'm not aware of any "wizards" that one could use.
Using Java: When connecting to a PBD, using a JDBC driver, make sure that you use the service name (again: not the SID).
SID (for connections): it seems that the SID is only used for connecting to CDBs (not PDBs) nowadays. Although - I have also used the "service name" successfully for accessing CDBs.
answered Jun 11 '17 at 17:22
stefanstefan
2,152139
I downloaded the developer days VM sometime last year, and so it came with Oracle 11, not 12. I'm trying to stick to using Oracle 11 because that's what the customer is using. I'll look into the PDF stuff, but I'm not sure it will work in Oracle 11.
– user1068636
Jun 12 '17 at 18:01
Even the 2014 version of the Developer Days VM already had a Oracle 12c installation (see the third link in my answer). However, if you need to stick to 11g, all the "multitentant" documentation is probably no use to you.
– stefan
Jun 12 '17 at 18:40
add a comment |
Are you sure that your Developer Days VM 2016-06-02_13 runs Oracle 11g? I'm using the same, and it reports:
SQL> select * from v$version;
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
CORE 12.1.0.2.0 Production 0
TNS for Linux: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0
Reading your questions/explanations, I cannot tell how familiar you are with 12c's "multitenant option", which "allows a single container database (CDB) to host multiple separate pluggable databases (PDB)" (see eg oracle-base.com). For starters, a new PDB may be just what you need ... an overview of Oracle Multitenant can be found here.
In this article, section "Where to get started", you can see that the SERVICE NAME (not the SID) is used for connecting to a PDB. More about PDBs (cloning etc), with screen shots, can be found here. SQLDeveloper (already installed on the Developer Days VM) is probably the best tool for getting started. I'm not aware of any "wizards" that one could use.
Using Java: When connecting to a PBD, using a JDBC driver, make sure that you use the service name (again: not the SID).
SID (for connections): it seems that the SID is only used for connecting to CDBs (not PDBs) nowadays. Although - I have also used the "service name" successfully for accessing CDBs.
answered Jun 11 '17 at 17:22
stefanstefan
2,152139
I downloaded the developer days VM sometime last year, and so it came with Oracle 11, not 12. I'm trying to stick to using Oracle 11 because that's what the customer is using. I'll look into the PDF stuff, but I'm not sure it will work in Oracle 11.
– user1068636
Jun 12 '17 at 18:01
Even the 2014 version of the Developer Days VM already had a Oracle 12c installation (see the third link in my answer). However, if you need to stick to 11g, all the "multitentant" documentation is probably no use to you.
– stefan
Jun 12 '17 at 18:40
add a comment |
Are you sure that your Developer Days VM 2016-06-02_13 runs Oracle 11g? I'm using the same, and it reports:
SQL> select * from v$version;
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
CORE 12.1.0.2.0 Production 0
TNS for Linux: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0
Reading your questions/explanations, I cannot tell how familiar you are with 12c's "multitenant option", which "allows a single container database (CDB) to host multiple separate pluggable databases (PDB)" (see eg oracle-base.com). For starters, a new PDB may be just what you need ... an overview of Oracle Multitenant can be found here.
In this article, section "Where to get started", you can see that the SERVICE NAME (not the SID) is used for connecting to a PDB. More about PDBs (cloning etc), with screen shots, can be found here. SQLDeveloper (already installed on the Developer Days VM) is probably the best tool for getting started. I'm not aware of any "wizards" that one could use.
Using Java: When connecting to a PBD, using a JDBC driver, make sure that you use the service name (again: not the SID).
SID (for connections): it seems that the SID is only used for connecting to CDBs (not PDBs) nowadays. Although - I have also used the "service name" successfully for accessing CDBs.
answered Jun 11 '17 at 17:22
stefanstefan
2,152139
Are you sure that your Developer Days VM 2016-06-02_13 runs Oracle 11g? I'm using the same, and it reports:
SQL> select * from v$version;
BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
CORE 12.1.0.2.0 Production 0
TNS for Linux: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0
Reading your questions/explanations, I cannot tell how familiar you are with 12c's "multitenant option", which "allows a single container database (CDB) to host multiple separate pluggable databases (PDB)" (see eg oracle-base.com). For starters, a new PDB may be just what you need ... an overview of Oracle Multitenant can be found here.
In this article, section "Where to get started", you can see that the SERVICE NAME (not the SID) is used for connecting to a PDB. More about PDBs (cloning etc), with screen shots, can be found here. SQLDeveloper (already installed on the Developer Days VM) is probably the best tool for getting started. I'm not aware of any "wizards" that one could use.
Using Java: When connecting to a PBD, using a JDBC driver, make sure that you use the service name (again: not the SID).
SID (for connections): it seems that the SID is only used for connecting to CDBs (not PDBs) nowadays. Although - I have also used the "service name" successfully for accessing CDBs.
answered Jun 11 '17 at 17:22
stefanstefan
2,152139
answered Jun 11 '17 at 17:22
stefanstefan
2,152139
answered Jun 11 '17 at 17:22
stefanstefan
2,152139
answered Jun 11 '17 at 17:22
stefanstefan
2,152139
2,152139
I downloaded the developer days VM sometime last year, and so it came with Oracle 11, not 12. I'm trying to stick to using Oracle 11 because that's what the customer is using. I'll look into the PDF stuff, but I'm not sure it will work in Oracle 11.
– user1068636
Jun 12 '17 at 18:01
Even the 2014 version of the Developer Days VM already had a Oracle 12c installation (see the third link in my answer). However, if you need to stick to 11g, all the "multitentant" documentation is probably no use to you.
– stefan
Jun 12 '17 at 18:40
add a comment |
I downloaded the developer days VM sometime last year, and so it came with Oracle 11, not 12. I'm trying to stick to using Oracle 11 because that's what the customer is using. I'll look into the PDF stuff, but I'm not sure it will work in Oracle 11.
– user1068636
Jun 12 '17 at 18:01
Even the 2014 version of the Developer Days VM already had a Oracle 12c installation (see the third link in my answer). However, if you need to stick to 11g, all the "multitentant" documentation is probably no use to you.
– stefan
Jun 12 '17 at 18:40
I downloaded the developer days VM sometime last year, and so it came with Oracle 11, not 12. I'm trying to stick to using Oracle 11 because that's what the customer is using. I'll look into the PDF stuff, but I'm not sure it will work in Oracle 11.
– user1068636
Jun 12 '17 at 18:01
I downloaded the developer days VM sometime last year, and so it came with Oracle 11, not 12. I'm trying to stick to using Oracle 11 because that's what the customer is using. I'll look into the PDF stuff, but I'm not sure it will work in Oracle 11.
– user1068636
Jun 12 '17 at 18:01
Even the 2014 version of the Developer Days VM already had a Oracle 12c installation (see the third link in my answer). However, if you need to stick to 11g, all the "multitentant" documentation is probably no use to you.
– stefan
Jun 12 '17 at 18:40
Even the 2014 version of the Developer Days VM already had a Oracle 12c installation (see the third link in my answer). However, if you need to stick to 11g, all the "multitentant" documentation is probably no use to you.
– stefan
Jun 12 '17 at 18:40
add a comment |
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%2f175928%2fhow-do-you-create-a-new-database-with-new-sid-on-oracles-pre-built-11g-virtual%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
You can not create a second instance (=database) with Oracle Express. Why do you think you need that? Just create new user (=schema) and use that.
– a_horse_with_no_name
Jun 9 '17 at 21:49