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 manual is ever so helpful
on the errors... :\
THESE are my errors..
create
April,
could quite possible be that you are missing the GROUP # clause for the
logfiles, You list 3 files but not define a group for each of them.
ROR mª¿ªm
[EMAIL PROTECTED] 02/14/02 08:23AM
Okay... I am at a loss. There is SOMETHING wrong, and I can not for
the
life of me see it. I know
db_domain = .world same error
db_domain = .worldsame error
db_domain = world same error...
Oracle Version 8.1.7.0
-Original Message-
Sent: Thursday, February 14, 2002 7:45 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells
Check Metalink Note : 56016.999
Samir
Samir
Check Metalink Note : 56016.999
Samir
Samir Sarkar
Oracle DBA - Lennon Team
SchlumbergerSema
Email : [EMAIL PROTECTED]
[EMAIL PROTECTED]
Phone : +44 (0) 115 - 957 6217
EPABX : +44 (0) 115 - 957 6418 Ext. 76217
Fax : +44 (0) 115 - 957 6018
-Original Message-
April,
I think you need parens around the logfiles like:
logfile ('/admin04/cc1test/redo01.log' size 1m reuse,
'/admin05/cc1test/redo02.log' size 1m reuse,
'/admin06/cc1test/redo03.log' size 1m reuse)
Your syntax is correct for one log file.
Tom Mercadante
Oracle Certified
Have you set the ORACLE_SID before running the script? Just a thot... Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, February 14, 2002 8:23 AM
Okay... I am at a loss. There is SOMETHING wrong, and I can not for the
life of me
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 @afiedt.buf
logfile
The db_domain=world should be in the init.ora. $0.02 more,Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, February 14, 2002 8:53 AM
db_domain = .world same error
db_domain = .world same error
db_domain = world same error...
Okay... so it wasn't such a dumb question... there is bad block on the disk
where the contolfile is... changing where I put it fixed the problem...
Thank you all.
-Original Message-
Sent: Thursday, February 14, 2002 7:23 AM
To: Multiple recipients of list ORACLE-L
Okay... I am at a
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 US7ASCII
datafile
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/redo01.log' size 1m reuse,
I would think that the database name of testccl would need to be in double
quotes.
Kevin Bass
Senior Manager, I.D.E.
Americal Corporation
Phone: (252) 762-2144
E-mail: [EMAIL PROTECTED]
-Original Message-
Sent: Thursday, February 14, 2002 8:23 AM
To: Multiple recipients of list
I had a similar error to this. What my error turned out to be was the
rollback_segments parameter was not commented out in the initdb.ora
parameter file. The private rollback segments had not been created yet
and oracle could not find them to start the database. I commented out
this parameter
cc:
Sent by: Subject: Create Database ...
really dumb question
root@fatcity.
com
02/14/2002
08:23 AM
Please
Sorry... really bad day... another script is eating huge amounts of paging
space on prod server...
turns out that there was corrupt blocks on disk where control file was...
move control file... rerun script... runs fine.
Thank you!
8-)
April
-Original Message-
Sent: Thursday,
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
Lee
-Original Message-
[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
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' size 100m reuse
/
First thing it
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
datafile
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
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-
Sent: Thursday, February 14, 2002 10:23 AM
To: '[EMAIL PROTECTED]'
Cc: April Wells
21 matches
Mail list logo