Thanks, Mladen. I will look forward to it. Meanwhile, I at least have
something to recreate them as they are.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 12:40 PM
> I have it at home. It's a modified version of t
pena
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, June 17, 2003 1:29
PM
Subject: Re: recreating a create database
file
Ruth,
Ummm how did you do this in 9i?
Thanks,
-LizzRuth Gramolini <[EMAIL PROTECTED]>
wrote:
I
got the answer, thanks anyway. Ru
Here is the create script I just did for 9i
[createdb.sql]
spool \admin\\create\CreateDB.log
set echo on
connect SYS/ as SYSDBA
startup nomount
pfile="\admin\\pfile\init.ora";
-- build the db
CREATE DATABASE
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 64
MAXLOGMEMBERS 3
MAXDAT
Ron,
I read Ruth's original message meaning that she had to re-create the
database structures. Of course you are correct if she meant the schema
objects also.
I just liked Jeremiah's thinking - this is an excellent quick way of
creating the "create database" script to
Not sure if this was already mentioned. You can hack up the result of
this:
alter database backup controlfile to trace;
into an exact replica of the create database statement.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 17 Jun 2003, Jack van Zanen wrote:
> Maybe not
Not sure if this was already mentioned. You can hack up the result of
this:
alter database backup controlfile to trace;
into an exact replica of the create database statement.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Tue, 17 Jun 2003, Jack van Zanen wrote:
> Maybe not exac
I have it at home. It's a modified version of the script
in Orac_Dba, concocted by Jared Still and Andy Duncan. You
can get the script from CPAN and I'll send you my version
when I get home. I've even sent it to Jared and Andy, but I
don't have time to maintain Orac_Dba right now. May be Jared
ha
tables and tablespaces.
Ron
>>> [EMAIL PROTECTED] 06/17/03 10:59AM >>>
Do you need the "CREATE DATABASE ..." script or the scripts to create
all
the database objects. If it's the latter and you have an export,
import
that into an IFILE and remove all the REMs. Tha
Well ... here is some generic stuff for you to edit. This is from 8.1.x,
but I think it will still (with an edit or two) get you a running database
in 9.2.x
connect / as sysdba
startup nomount
create database "CRCT2"
maxinstances 8
maxlogfiles 32
character set
Ruth,
If you have the DataBee tool (available free )
http://www.cool-tools.co.uk You can take an export and then the
commands are available to recreate your tables and tablespaces.
Ron
>>> [EMAIL PROTECTED] 06/17/03 10:59AM >>>
Do you need the "CREATE DATABASE ...&qu
I got the answer, thanks anyway.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June 17, 2003 10:09 AM
> Good morning all,
>
> Somehow all of my scripts to create the databases on my 9i sandbox have
> disappeared. Does anyone h
Maybe not exactly what you are looking for, but
Start the GUI DBCA (NO don't shoot), go through the all the motions and at
the end choose generate scripts only.
Jack
-Original Message-
Sent: Tuesday, June 17, 2003 4:09 PM
To: Multiple recipients of list ORACLE-L
Good morning
Do you need the "CREATE DATABASE ..." script or the scripts to create all
the database objects. If it's the latter and you have an export, import
that into an IFILE and remove all the REMs. That should give you the
tablespaces, tables, and indexes. You'll have to do so
Good morning all,
Somehow all of my scripts to create the databases on my 9i sandbox have
disappeared. Does anyone have a script or trick or something to recreate
these files? I could recreate them manually but I am somewhat of a time
crunch.
Thanks in advance,
Ruth
--
Please see the officia
Just a note for everyone.
Installing the glibc 2.3.2 helped running Oracle, but the OUI
won't run anymore because of problems with the JRE 1.3.1
(Missing link in jre/lib/libjava.so).
I tried replacing the 1.3.1 JRE with the one of JDK 1.3.1, but the
OUI won't start.
Not giving any message, just di
lishness of things"
> > >
> > > -Unknown
> > >
> > >
> > > > -Original Message-
> > > > From: Schwerdtfeger, "Christoph [mailto:[EMAIL PROTECTED]
> > > > Sent: Monday, March 17, 2003 2:59 AM
> > >
t; Greenbrier & Russel, Inc.
> > Madison, Wisconsin USA
> >
> > "Let us linger here a while in the foolishness of things"
> >
> > -Unknown
> >
> >
> > > -Original Message-
> > > From: Schwerdtfeger, &
>
> -Unknown
>
>
> > -Original Message-
> > From: Schwerdtfeger, "Christoph [mailto:[EMAIL PROTECTED]
> > Sent: Monday, March 17, 2003 2:59 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: can't create database
>
2:59 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: can't create database
>
>
> Am Mit, 2003-03-12 um 21.14 schrieb [EMAIL PROTECTED]:
> > I've had this problem on linux. Best and fastest solution:
> reboot the
> > server. There is a memor
2003 12:44 PM, Stahlke, Mark
> <[EMAIL PROTECTED]> wrote:
> > > > > > >RE: LMT monitoring
> > > > > > >Is this on Linux?
> > > > > > >If yes, then it sounds like you need to install the glibc stubs
> patch.
> > > > >
Hi,
I have RadHat AS2.1, oracle 8.1.7.4 (with OPS)
oracm, oranm, watchdogd are running
create database fails with ora-29702
lmon trace contains:
/usr/oracle/admin/OPS/bdump/lmon_1164.trc
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning and Parallel Server
You need oradebug for that.
Jared
Ray Stell <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/12/2003 01:45 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: can't create database
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: can't create database
On Wed, Mar 12, 2003 at 12:44:07PM -0800, [EMAIL PROTECTED] wrote:
> I run into this every time I stop 9.2 on Linux.
>
> No need to reboot. Just use
L
>
>
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> cc:
> Subject:Re: can't create database
>
>
> I've had this problem on linux. Best and fastest solution: reboot the
> server. There is a memory issue
]
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: can't create dat
Subject: Re: can't create database
I've had this problem on linux. Best and fastest solution: reboot the
server. There is a memory issue preventing you from starting oracle. I
just had it happen about 2 minutes ago on an upgrade to 9i. Reboot, and
now I can start the d
; >
> > > > >
> > > > > On 3/11/2003 12:44 PM, Stahlke, Mark
<[EMAIL PROTECTED]> wrote:
> > > > > >RE: LMT monitoring
> > > > > >Is this on Linux?
> > > > > >If yes, then it sounds like you need to ins
;[EMAIL PROTECTED]> wrote:
> > > > >RE: LMT monitoring
> > > > >Is this on Linux?
> > > > >If yes, then it sounds like you need to install the glibc stubs
patch.
> > > > >If no, then I don't know what the problem might be.
> > > >
OTECTED]> wrote:
> > >RE: LMT monitoring
> > >Is this on Linux?
> > >If yes, then it sounds like you need to install the glibc stubs patch.
> > >If no, then I don't know what the problem might be.
> > >
> > >-Original Message---
t; > >Is this on Linux?
> > > > > >If yes, then it sounds like you need to install the glibc stubs patch.
> > > > > >If no, then I don't know what the problem might be.
> > > > > >
> > > > > >-Original Messa
t; > >
> > > > On 3/11/2003 12:44 PM, Stahlke, Mark <[EMAIL PROTECTED]> wrote:
> > > > >RE: LMT monitoring
> > > > >Is this on Linux?
> > > > >If yes, then it sounds like you need to install the glibc stubs patch.
> > > &
Is this on Linux?
> > > >If yes, then it sounds like you need to install the glibc stubs patch.
> > > >If no, then I don't know what the problem might be.
> > > >
> > > >-Original Message-
> > > >From: Milen Pankov [ma
;
> > >-Original Message-
> > >From: Milen Pankov [mailto:[EMAIL PROTECTED]
> > >Sent: Tuesday, March 11, 2003 10:00 AM
> > >To: Multiple recipients of list ORACLE-L
> > >Subject: can't create database
> > >
> > >
> > &
like you need to install the glibc stubs patch.
> >If no, then I don't know what the problem might be.
> >
> >-Original Message-
> >From: Milen Pankov [mailto:[EMAIL PROTECTED]
> >Sent: Tuesday, March 11, 2003 10:00 AM
> >To: Multiple recipients of list ORA
oach can help you localize
at which step the problem appears.
Best wishes
Milen Kulev
-Ursprüngliche Nachricht-Von: Milen Pankov
[mailto:[EMAIL PROTECTED]Gesendet: Dienstag, 11. März 2003
18:00An: Multiple recipients of list ORACLE-LBetreff:
can't create database
can
v [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, March 11, 2003 10:00 AM
>To: Multiple recipients of list ORACLE-L
>Subject: can't create database
>
>
>can't create a database with oracle 8.1.7.
>the installation went fine, but when i start dbassist on the 2% of
>the
On Tue, Mar 11, 2003 at 09:00:09AM -0800, Milen Pankov wrote:
> RE: LMT monitoringcan't create a database with oracle 8.1.7.
> the installation went fine, but when i start dbassist on the 2% of the
> database creation it tels me:
> "not connected to oracle".
> any ideas?
--
look in the ale
AMTo: Multiple recipients of list ORACLE-LSubject: can't
create database
can't create a database with oracle 8.1.7. the installation went
fine, but when i start dbassist on the 2% of the database creation it
tels me: "not connected to oracle". any ideas?
x27;t
create database
can't create a database with oracle 8.1.7. the installation went
fine, but when i start dbassist on the 2% of the database creation it
tels me: "not connected to oracle". any ideas?
=== Confidentiality Statement =
Title: RE: LMT monitoring
can't create a database with oracle 8.1.7. the installation went
fine, but when i start dbassist on the 2% of the database creation it
tels me: "not connected to oracle". any ideas?
Within the create database statement there is:
MAXLOGHISTORY. Does this apply only to Oracle Parallel Server (OPS) like
the docs say? So If I am not running OPS I can set this to 1 (one) safely?
thanks,
David Ehresmann
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
Actually, there are a lot of different errors possible against the
"CREATE DATABASE " statement.
A quick search for "CREATE DATABASE" in the Error Messages manual [9.2]
returned a count of 43, of which some would be "CREATE DATABASE LINK ..."
I remember when I&
ginal Message-
> From: Tim Gorman [mailto:Tim@;SageLogix.com]
> Sent: Thursday, October 17, 2002 1:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: auditing CREATE DATABASE
>
>
> What a tongue-in-cheek answer: "only catches successful
> a
Um... wasn't this...
> Then you go and publicly execute that
> person by beating him to the pulp with a baseball bat (so called "Soprano
> method")
...the Al Capone method in "The Untouchables"?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Verga
Yes, there is. You might notice that someone has issued a
"create database" command because all of your data will be
gone fishing. When the noise level reaches 500 decibels,
someone has issued "CREATE DATABASE" command on your production
database, which, of course, no lo
What a tongue-in-cheek answer: "only catches successful attempts"! I like
his/her sense of humor...
Issuing a CREATE DATABASE command against an already mounted and open
database triggers an ORA-01501 error. If you are running Oracle8i or above,
you could create an AFTER SERVERERRO
Is there a way of capturing info on people who issue CREATE DATABASE
statements?
My Oracle Support technician says auditing won't catch this, only catches
successful attempts.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exp
[mailto:[EMAIL PROTECTED]]
> Sent: 14 February 2002 16:33
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Create Database ... really dumb question
>
>
> Not per the LESS than Friendly manuals...
>
> Admin guide, 2-12
>
> -Original Message-
> S
Yes. You call your local oracle office and get yourself a support contract.
WARNING: YOU MAY BE REQUIRED TO SIGN A CHECK IN THE PROCESS
-Original Message-
Sent: Thursday, February 14, 2002 12:28 PM
To: Multiple recipients of list ORACLE-L
[SARKAR, Samir]
> Check Metalink Note
April,
Sorry about that - I looked at the docs again, and I don't think you can do
it the way you had it originally.
I created my last db like so:
create database WTWU
maxinstances 1
maxlogfiles 32
maxdatafiles 99
noarchivelog
character set WE8ISO8859P1
dat
Try this:
create database testcc1
controlfile reuse
logfile ('/admin04/cc1test/redo01.log') size 1m reuse,
('/admin05/cc1test/redo02.log') size 1m reuse,
('/admin06/cc1test/redo03.log') size 1m reuse
datafile '/data10/cc1test_system.dbf
[SARKAR, Samir]
> Check Metalink Note : 56016.999
Is there any way to get access to metalink for those of us not fortunate
enough to have an Oracle support contract? (Startup life is fun!)
--
James Manning <[EMAIL PROTECTED]>
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F
Not per the LESS than Friendly manuals...
Admin guide, 2-12
-Original Message-
Sent: Thursday, February 14, 2002 10:23 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells
Shouldn't your dbname be in double quotes
create database "testcc1"
etc.
etc...
HTH
Le
, February 14, 2002 10:29 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells
erm... highly embarrassed, slinks off into the corner. That was a total
brain fart...
Here is one of mine that works OK
create database "BRIT"
maxdatafiles 5000
maxinstances 8
maxlogfiles 32
cha
]; April Wells
April,
Your script sure looks good, you already know that. The only thing I can
suggest is to specify
character set. Just guessing
Rick
create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log
the error manual is ever so helpful
> on the errors... >:\
>
> THESE are my errors..
>
> create database testcc1
> *
> ERROR at line 1:
> ORA-01501: CREATE DATABASE failed
> ORA-02084: database name is missing a component
>
> THIS is my script..
create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component
THIS is my script...
create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/adm
Shouldn't your dbname be in double quotes
create database "testcc1"
etc.
etc...
HTH
Lee
-Original Message-
Sent: 14 February 2002 14:29
To: Multiple recipients of list ORACLE-L
create database testcc1
controlfile reuse
logfile ('/admin04/cc1test/redo0
erm... highly embarrassed, slinks off into the corner. That was a total
brain fart...
Here is one of mine that works OK
create database "BRIT"
maxdatafiles 5000
maxinstances 8
maxlogfiles 32
character set "US7ASCII"
national character set &qu
at a loss. There is SOMETHING wrong, and I can not for the
life of me see it. I know there is something REALLY simple wrong with this,
but I can't find it... ANYWHERE... and the error manual is ever so helpful
on the errors... >:\
THESE are my errors......
create database testc
April,
Your script sure looks good, you already know that. The only thing I can
suggest is to specify
character set. Just guessing
Rick
create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size
ary 2002 13:23
> To: Multiple recipients of list ORACLE-L
>
>
>
> Okay... I am at a loss. There is SOMETHING wrong, and I can not for the
> life of me see it. I know there is something REALLY simple wrong with
this,
> but I can't find it... ANYWHERE... and the error manu
create database testcc1
controlfile reuse
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse)
datafile '/data10/cc1test_system.dbf' size 100m reuse
/
SQL> @a
can not for the
> life of me see it. I know there is something REALLY simple wrong with
this,
> but I can't find it... ANYWHERE... and the error manual is ever so helpful
> on the errors... >:\
>
> THESE are my errors..
>
> create database testcc1
> *
with this,
but I can't find it... ANYWHERE... and the error manual is ever so helpful
on the errors... >:\
THESE are my errors..
create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is
ul
on the errors... >:\
THESE are my errors..
create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component
THIS is my script...
create database testcc1
controlfile reuse
>:\
THESE are my errors......
create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component
THIS is my script.......
create database testcc1
controlfile reuse
logfile '/admin04/cc1test/red
e of me see it. I know there is something REALLY simple wrong with
this,
but I can't find it... ANYWHERE... and the error manual is ever so
helpful
on the errors... >:\
THESE are my errors..
create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084
create database testcc1
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-02084: database name is missing a component
THIS is my script...
create database testcc1
controlfile reuse
logfile '/admin04/cc1test/redo01.log' size 1m reuse,
'/adm
ecember 11, 2001 6:05 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am trying to generate some generic CREATE DATABASE scripts from the Oracle
Database Configuration assistant and I cannot see the "Generate Database
Creation Scripts" option that is mentioned in the HELP. It is not
uter. Thank you.
-Original Message-
Sent: Tuesday, December 11, 2001 12:05 PM
To: Multiple recipients of list ORACLE-L
Hi,
I am trying to generate some generic CREATE DATABASE scripts from the Oracle
Database Configuration assistant and I cannot see the "Generate Database
Creatio
Hi,
I am trying to generate some generic CREATE DATABASE scripts from the Oracle
Database Configuration assistant and I cannot see the "Generate Database
Creation Scripts" option that is mentioned in the HELP. It is not listed on
the screen with the "Create Database" and
Deepak Thapliyal wrote:
>lol .. john by "no" i meant "no u dont need to modify
>db creation scripts" .. my bad .. maybe i should have
>articulated a bit clearly .. i guess it was 2 late
>when i replied.. lol
>
>thx for your reply all the same.
>
>Deepak (counting .. just 3 more days for friday;)
hn Kanagaraj <[EMAIL PROTECTED]> wrote:
> Deepak/Sujatha,
>
> I see no reason why the same script should not work
> as long as it is limited
> to CREATE DATABASE/CREATE or ALTER TABLESPACE
> commands. (I believe that was
> the original question). However, dependencies
Deepak/Sujatha,
I see no reason why the same script should not work as long as it is limited
to CREATE DATABASE/CREATE or ALTER TABLESPACE commands. (I believe that was
the original question). However, dependencies such as parameters in init.ora
(compatible, _system_trig_enabled, etc. come to
no
--- Sujatha Madan <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> If I have a create database script which I've used
> with v8.0.6, would I be
> able to use these same scripts in v8.1.7??? ... or
> are there any
> modifications to be made.
>
> Thanks
>
> Su
Hi,
If I have a create database script which I've used with v8.0.6, would I be
able to use these same scripts in v8.1.7??? ... or are there any
modifications to be made.
Thanks
Sujatha
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sujatha Madan
INET: [
e recipients of list ORACLE-L
> Subject: Create Database ORA-907 need help
>
>
> Hi all,
>
> Can someone tell me whats wrong with my script ?
>
>
> CREATE DATABASE TEST
> LOGFILE (
> '/test/redo01.log' SIZE 10K,
>
Chk the spelling of maxlogfiles. You have used 0(zero) instead of 'O'.
--
On Tue, 04 Sep 2001 23:55:42
Sinardy wrote:
>Hi all,
>
>Can someone tell me whats wrong with my script ?
>
>
>CREATE DATABASE TEST
> LOGFILE (
> '/test/redo0
Try to remove the brackets.
Rgds/Jeram
-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Wednesday, September 05, 2001 2:27 PM
>Hi all,
>
>Can someone tell me whats wrong with my script ?
>
>
>CREATE DATABASE TEST
> LO
You don't need to put any Bracket after keyword 'LOGFILE'
See following lines...
CREATE DATABASE OHIR
LOGFILE 'D:\Oracle\oradata\OHIR\redo01.log' SIZE 1024K,
'D:\Oracle\oradata\OHIR\redo02.log' SIZE 1024K,
'D:\Oracle\oradata\OHIR\redo03.log
Hi all,
Can someone tell me whats wrong with my script ?
CREATE DATABASE TEST
LOGFILE (
'/test/redo01.log' SIZE 10K,
'/test/redo02.log' SIZE 10K,
'/test/redo03.log' SIZE 10K
)
MAXL0G
install.log:-
-
Connected.
ORA-27102: out of memory
Intel SVR4 UNIX Error: 22: Invalid argument
create database "orcl805"
*
ORA-01034:
How can I generate from my schema, the SQL to re-create sequences, tables,
procedures, etc etc.i.e, not using import/export.
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
I had a similar problem before
Make sure in your /etc/system file you set the following correctly (use
appropriate values where necesary)
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set
solaris 2.7 + oracle 8.1.6 ( 64-bit)
After I installed the oracle software, I tried to create a database by
dbassist.
But dbassist exited at finial step with 'segmentation violation' error and
thread dump;
Oracle support told me that it has relations with os enviroment and it does
happen somet
86 matches
Mail list logo