OraFAQ Forum: Server Administration » CREATE ONE MORE DATABASE ON SAME SERVER

Home » RDBMS Server » Server Administration » CREATE ONE MORE DATABASE ON SAME SERVER (Oracel 10g Red Hat 4.1.2-41)

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

CREATE ONE MORE DATABASE ON SAME SERVER [message #478611]

Mon, 11 October 2010 05:36

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

Hi

I need to create one more database on same server. One database is already running on the system but that is our test server which we have to synchronize after every 15 days so we just remove all dbf files and place from production so we need to create another database on the same server which we will not touch at the time of synchronize.
Please tell me some steps how to create another database on a same system where one is already running.

Report message to a moderator

Re: CREATE ONE MORE DATABASE ON SAME SERVER [message #478613 is a reply to message #478611]

Mon, 11 October 2010 05:40

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Creating an Oracle database

Report message to a moderator

Re: CREATE ONE MORE DATABASE ON SAME SERVER [message #478614 is a reply to message #478611]

Mon, 11 October 2010 05:41

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

Is it possible through DBCA easily?

Report message to a moderator

Re: CREATE ONE MORE DATABASE ON SAME SERVER [message #478617 is a reply to message #478614]

Mon, 11 October 2010 05:46

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I wouldn't know. But document I provided contains "steps" you are looking for.

Perhaps you should wait for DBA's opinion(s) (before taking any of those steps).

Report message to a moderator

Re: CREATE ONE MORE DATABASE ON SAME SERVER [message #478623 is a reply to message #478617]

Mon, 11 October 2010 05:55

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

ok.
Will it not overwrite my previous data files as already exist on server?
And I am taking DBA's opinion with the help of this Smile

Report message to a moderator

Re: CREATE ONE MORE DATABASE ON SAME SERVER [message #478630 is a reply to message #478623]

Mon, 11 October 2010 06:08

Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

CREATE DATABASE statement caution:
Oracle

Caution:
This statement prepares a database for initial use and erases any data currently in the specified files. Use this statement only when you understand its ramifications.

Handle with care!

Report message to a moderator

Re: CREATE ONE MORE DATABASE ON SAME SERVER [message #478643 is a reply to message #478630]

Mon, 11 October 2010 07:08

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

I just decide to use DBCA.
But when I create database it gives error
ORA-09925:unable to create audit trail file
ORA-01012:not logged on
ORA-01031:insufficient privileges

I checked this error and give proper privilege to admin using chmod 777 cmd.
But still problem exist what should I do?

Report message to a moderator

Re: CREATE ONE MORE DATABASE ON SAME SERVER [message #478655 is a reply to message #478643]

Mon, 11 October 2010 08:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post results from following commands

id
env | sort

Report message to a moderator

Re: CREATE ONE MORE DATABASE ON SAME SERVER [message #478656 is a reply to message #478643]

Mon, 11 October 2010 08:20

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You need to create dedicated areas for udump/adump etc in your ORACLE_BASE.
DBCA will do it for you, based on OFA along with your ORACLE_SID.
Provided you do have proper OS Privs (in dba group) it should be all fine.
DBCA or even create database statement will not override the files, unless you ask it Smile

.
Make sure you use another ORACLE_SID, another path (with OFA).

Report message to a moderator

Re: CREATE ONE MORE DATABASE ON SAME SERVER [message #478677 is a reply to message #478655]

Mon, 11 October 2010 22:40

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

[oracle@localhost ~]$ id
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba) context=root:system_r:unconfined_t:SystemLow-SystemHigh
[oracle@localhost ~]$ env | sort
_=/bin/env
CVS_RSH=ssh
DISPLAY=:1.0
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/oracle
HOSTNAME=localhost.yusata.com
INPUTRC=/etc/inputrc
LANG=en_US.UTF-8
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=00;34:ln=00;36:pi=40;33:so=00;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=00;32:*.cmd=00;32: *.exe=00;32:*.com=00;32:*.btm=00;32:*.bat=00;32:*.sh=00;32:*.csh=00;32:*.tar=00;31:*.tgz=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*. zip=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.bz=00;31:*.tz=00;31:*.rpm=00;31:*.cpio=00;31:*.jpg=00;35:*.gif=00;35:*.bmp=00; 35:*.xbm=00;35:*.xpm=00;35:*.png=00;35:*.tif=00;35:
MAIL=/var/spool/mail/oracle
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
ORACLE_SID=TESTDB
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/u01/app/oracle/product/11.1.0/db_1/bin
PWD=/home/oracle
SHELL=/bin/bash
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
TERM=xterm
USER=oracle

Report message to a moderator

Re: CREATE ONE MORE DATABASE ON SAME SERVER [message #478678 is a reply to message #478677]

Mon, 11 October 2010 22:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

09925, 00000,  "Unable to create audit trail file"
// *Cause:  ORACLE was not able to create the file being used to hold
//          audit trail records.
// *Action: Check the UNIX error number for a possible operating system error.
//          If there is no error, contact ORACLE customer support.

Report message to a moderator

Re: CREATE ONE MORE DATABASE ON SAME SERVER [message #478679 is a reply to message #478678]

Mon, 11 October 2010 22:58

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

But I tried database creation through DBCA on three server independently and I got the same errors on all of them.
Then I tried on my personal system on which windows7 installed
and it creates successfully.

Can you please give me some solution what should I do?

Report message to a moderator

Re: CREATE ONE MORE DATABASE ON SAME SERVER [message #478680 is a reply to message #478679]

Mon, 11 October 2010 23:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can you please give me some solution what should I do?
I suspect you have some sort of OS permission problem.

DBCA creates a log file which should contain clues as to why dbca fails.

When all else fails, Read The Fine Manual.
http://download.oracle.com/docs/cd/B19306_01/install.102/b15660/toc.htm

Report message to a moderator

Previous Topic:	ORA-03135: connection lost contact
Next Topic:	PB to startup Oracle 7

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 16 03:03:37 CDT 2024