OraFAQ Forum: Client Tools » Create new database in SQL Plus or PowerShell

Home » Other » Client Tools » Create new database in SQL Plus or PowerShell

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create new database in SQL Plus or PowerShell [message #628771]

Fri, 28 November 2014 05:37

pturner87
Messages: 3
Registered: November 2014
Location: United Kingdom

Junior Member

Hi guys, I'm very new to Oracle and I have a question about creating a new database.

I'm investigating this at work because our software relies on a database which can be either SQL Server or Oracle, and we have set up provisioning for the whole system using PowerShell. The provisioning only supports SQL Server at the moment hence my question.

I've installed Oracle 12c Enterprise and chose the "install database software only" option. I've spent some time googling how to create a new database from this starting point, using SQL Plus or anything else that can run through PowerShell but I haven't figured it out yet. Can anyone please point me in the right direction?

I think I'll try setting up a database using Universal Installer just to see what files it creates; I think this is one of my problems i.e. the lack of a tnsnames.ora, and I can't even log into SQL Plus because I don't think a user name and password was set up in the Oracle installation.

Sorry if I seem completely clueless about this. Any help would be greatly appreciated.

Report message to a moderator

Re: Create new database in SQL Plus or PowerShell [message #628779 is a reply to message #628771]

Fri, 28 November 2014 06:57

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

Oracle provides a couple of other utilities to do what you want.

First, Oraclue Universal Installer (OUI) only installs the software. It does not create a database. Some people THINK it does because if make a selection to let it do so, it will (after installing the software) invoke the next utility ...

'dbca' (Database Configuration Assistant) is a GUI tool that will create a database after the software is installed.

You can configure your tnsnames.ora with another GUI tool, 'netca'.

None of what you want to achieve will be as simple as copying some files (implied by your statement "I think I'll try setting up a database using Universal Installer just to see what files it creates;".

If you need to script everything so as to not need to rely on an interactive process, you can make one run of dbca. At the end it will give you the option to simply generate the necessary scripts for creating the database. If you then need for those script to not have hard-coded database names, you can replace the hard-coded values with some identifiable tag, and work out a method of global search and replace on those tags.

In fact, make two trial runs. Once, selecting a 'generic' template (you'll see what I mean when you get there) and the other with a 'custom' template. Compare the scripts put out by the two.

For tnsnames.ora, use netca. Again, if you need a 'generic', replace the hard-coded values in the generated file will identifieable tags and proceed accordingly.

Report message to a moderator

Re: Create new database in SQL Plus or PowerShell [message #628785 is a reply to message #628779]

Fri, 28 November 2014 07:33

pturner87
Messages: 3
Registered: November 2014
Location: United Kingdom

Junior Member

Thanks for the advice Ed, I'll have a look at dbca and netca and see if I can figure it out.

Report message to a moderator

Re: Create new database in SQL Plus or PowerShell [message #628804 is a reply to message #628785]

Fri, 28 November 2014 09:14

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Well, basically you can also create a database without any of those tools manually

See Creating a Database with the CREATE DATABASE Statement.

The scripts that dbca and the other tools create can be used in that process, but it might be a good idea to try it with a "simple" hand-crafted database first to get some insights into the process.

Report message to a moderator

Re: Create new database in SQL Plus or PowerShell [message #628811 is a reply to message #628804]

Fri, 28 November 2014 09:42

pturner87
Messages: 3
Registered: November 2014
Location: United Kingdom

Junior Member

I ran through dbca creating a database again, but I don't see an option to generate the scripts. Are they created automatically and stored somewhere?

Report message to a moderator

Re: Create new database in SQL Plus or PowerShell [message #628812 is a reply to message #628811]

Fri, 28 November 2014 09:51

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Go through the DBCA dialogue again. Right at the end you get a window with check boxes for creating the database and/or creating the scripts.

Report message to a moderator

Re: Create new database in SQL Plus or PowerShell [message #628813 is a reply to message #628811]

Fri, 28 November 2014 09:52

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

pturner87 wrote on Fri, 28 November 2014 07:42

I ran through dbca creating a database again, but I don't see an option to generate the scripts. Are they created automatically and stored somewhere?

usually a screen appears with radio buttons for you to select

make database
make scripts
make both

Report message to a moderator

Re: Create new database in SQL Plus or PowerShell [message #636884 is a reply to message #628813]

Tue, 05 May 2015 03:23

browncat
Messages: 9
Registered: May 2015

Junior Member

This is how you can create database in SQL plus....and then use it...

CREATE DATABASE db;
USE db;

[Updated on: Tue, 05 May 2015 03:24]

Report message to a moderator

Re: Create new database in SQL Plus or PowerShell [message #636887 is a reply to message #636884]

Tue, 05 May 2015 03:31

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

USE is not an Oracle command.

Report message to a moderator

Re: Create new database in SQL Plus or PowerShell [message #636910 is a reply to message #636884]

Tue, 05 May 2015 07:54

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

browncat wrote on Tue, 05 May 2015 03:23

This is how you can create database in SQL plus....and then use it...

CREATE DATABASE db;
USE db;

Is archeology your hobby? This thread had been dormant for over 5 months ....

Report message to a moderator

Previous Topic:	Importing data in csv file . . .
Next Topic:	Tool for tracking SQLs in Oracle 11g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 21 23:49:49 CST 2024