[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 899
  • Last Modified:

Manually create a database in a 10g r2 RAC cluster (NO ASM)

Hello,

I'm new to RAC and need to create a database on a 2-node RAC cluster on linux. Can someone give me the CREATE DATABASE command to create the RAC db - I usually create DBs manually but this will be a first on RAC, not sure if there are extra params I should specify.

I can't fire up the dbca GUI because there are too many SSH tunnels to push through, thanks!

K
0
Kong
Asked:
Kong
1 Solution
 
KongAuthor Commented:
I'm using a Cluster File System and not ASM - for an easy way to earn points, you could fire up dbca on your own 10g Rel 2 RAC, go through the create database options and choose to save it as a script, many thanks!
0
 
actonwangCommented:
>>go through the create database options and choose to save it as a script
     why don't you do it by yourself or ask sb in your end to do so? you can just create those scripts and batch files without actually doing it.
0
 
KongAuthor Commented:
I don't have access to the UI so can't just fire it up and save those scripts... Unless you know of a non UI way of using dbca...
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
MikeOM_DBACommented:
>>I can't fire up the dbca GUI because there are too many SSH tunnels to push through, thanks!

How is it you are connecting now?

If you can establish a terminal connection with the Unix box, all you need to fire-up the GUI is:

1) export DISPLAY variable
2) Add to your PATH variable either /usr/openwin/bin --or-- /usr/bin/X11 --or-- /usr/X11R6 --or-- whatever 'X' windows is on the server
3) An X-Windows terminal emulator on your PC -- If you don't have one, you can download WinVNC or some other free emulator.





0
 
MohanKNairCommented:
Silent or non-interactive installation is now supported for RAC installations. Here instead of choosing options in GUI dialog boxes, the DBA supplies a text file called "a response file" which contains all the installation options.

Also see the links
Customizing and Creating Response Files
http://www.stanford.edu/dept/itss/docs/oracle/10g/em.101/b12140/4_oui_response_files.htm

http://download-east.oracle.com/docs/cd/B19306_01/em.102/b16227/oui4_response_files.htm
0
 
KongAuthor Commented:
Guys, I think we're heading down the wrong track, I only want the CREATE DATABASE statement that caters for the CLUSTER file system on a 2-node 10g linux cluster.

Ok, let me give an example, here's my CREATE DATABASE statement:

CREATE DATABASE prd01 CONTROLFILE  REUSE
user sys identified by blah
user system identified by blah
maxdatafiles 10000
maxlogfiles 16
maxlogmembers 5
character set WE8MSWIN1252
national character set AL16UTF16
MAXINSTANCES 2
extent management local
DATAFILE '/u01/oradata/prd01/system01.dbf' SIZE 601M REUSE
SYSAUX datafile '/u00/oradata/prd01/sysaux01.dbf' size 601M REUSE
LOGFILE '/u01/oradata/prd01/redo01.log' SIZE 100M REUSE,
'/u00/oradata/prd01/redo02.log' SIZE 100M REUSE,
'/u01/oradata/prd01/redo03.log' SIZE 100M REUSE,
'/u00/oradata/prd01/redo04.log' SIZE 100M REUSE
default temporary tablespace temp tempfile '/u01/oradata/prd01/temp01.dbf' size 2048064K REUSE
        extent management local uniform size 10M
undo tablespace undo datafile '/u00/oradata/prd01/undo01_ts_01.dbf' size 2048064K REUSE;

I'm not sure if this will create a proper RAC database...

Can I run it as is? Do I need to start up the instance on both nodes...? Like I said, I'm new to RAC... Thanks!
0
 
MohanKNairCommented:
You can configure RAC manually. Create the Real Application Clusters Configuration with SRVCTL.

See the following links

Manually Creating Real Application Clusters Databases
http://www.lc.leidenuniv.nl/awcourse/oracle/rac.920/a96600/mancrea.htm

Installing Oracle Database 10g with Real Application Cluster (RAC) on Red Hat Enterprise Linux Advanced Server 3
http://www.puschitz.com/InstallingOracle10gRAC.shtml




0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now