| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 3097.1 | decedi_create ? | UTRTSC::SMEETS | Workgroup support | Mon Apr 14 1997 19:52 | 15 |
| Hi Peter,
What do you mean with decedi_create. Is this a type and do you mean
decedi_config ?
What happens if you do the following:
su - oracle
svrmgrl
connect internal;
Regards,
Martin
|
| 3097.2 | Oops, I meant decedi_config | JOBURG::BERETTA | | Tue Apr 15 1997 00:43 | 22 |
| Hi,
Oops, yes I meant decedi_config.
128]root@ediit2:/> su - oracle
=======================================
= Machine ediit2 =
=======================================
oracle:none:/usr/users/oracle>svrmgrl
Server Manager: Release 2.0.3 - Production
Copyright (c) Oracle Corporation 1994. All rights reserved.
Oracle7 Server Release 7.1.4.1.1 - Production Release
With the distributed option
PL/SQL Release 2.1.4.0.0 - Production
SVRMGR> connect internal;
Connected to an idle instance.
SVRMGR>
|
| 3097.3 | protections on /data1 | UTRTSC::SMEETS | Workgroup support | Tue Apr 15 1997 11:47 | 32 |
| Hi Peter,
I took a better look at your base note
>> ORA-00603: ORACLE server session terminated by fatal error
>> ORA-00376: file 1 cannot be read at this time
>> ORA-01110: data file 1: '/data1/decedi_system.dbf'
>> ORA-00376: file 1 cannot be read at this time
>> ORA-01110: data file 1: '/data1/decedi_system.dbf'
>> ORA-01501: CREATE DATABASE failed
The /data1/decedi_system.db is the first file being created via the statement
create database "decedidb"
maxinstances 8
maxlogfiles 32
character set "US7ASCII"
datafile
'/data1/decedi_system.dbf' size 10M
logfile
'/data1/decedi_log1.dbf' size 500k,
'/data1/decedi_log2.dbf' size 500k,
'/data1/decedi_log3.dbf' size 500k;
It looks like /data1/decedi_system.dbf can't be created. So I would guess
there's something wrong with the protection on /data1.
Who's the owner of data1 and what are the protections on data1.
Regards,
Martin
|
| 3097.4 | my protections | UTRTSC::SMEETS | Workgroup support | Tue Apr 15 1997 13:39 | 11 |
| Hi Peter,
I had just a look at our DEC/EDI V3.1A with Oracle V7.3.2 system.
Our database is in /dms/oracle
drwxrwxrwx 4 oracle dba 8192 Feb 18 14:39 oracle
Regards,
Martin
|
| 3097.5 | Protections seem ok | JOBURG::BERETTA | | Tue Apr 15 1997 14:50 | 11 |
| Hi,
I have checked the protections and made them as open as I can and
removed any quotas. I am using ADVFS and the fileset had been mounted
with quotas. But this does not seem to make a difference.
drwxrwxrwx 8 oracle dba 8192 Apr 15 11:26 data1
Regards
Peter
|
| 3097.6 | are there files in data1 ? | UTRTSC::SMEETS | Workgroup support | Tue Apr 15 1997 14:56 | 10 |
| Hi Peter,
Is there any file being created in /data1 ?
I'm currently out of ideas, maybe someone else can help. Did you already talk
with Oracle support ?
Regards,
Martin
|
| 3097.7 | Here are my steps... | JOBURG::BERETTA | | Tue Apr 15 1997 15:24 | 344 |
| Hi Martin,
Thankyou for your help so far, I have a hunch that it has got to do
with protections as you have also indicated. I have also spoken to the
customers in-house oracle support and they say that we wrote the script
so its our problem.
The following are the steps I have been taking and the corresponding
results:
Logged in as oracle and did an su to root (I have tried logging as root
first aswell)
# printenv
PATH=/usr/users/oracle/bin:/usr/bin:.:/usr/users/oracle/obackup/bin:/usr/users/p
BRD_ERR_TIME=180
BRD_TOT_TIME=300
ORATERMPATH=/usr/users/oracle/forms30/admin/resource
BRD_NICE_VAL=0
LOGNAME=root
ORACLE_SID=decedidb
USER=root
OBK_HOME=/usr/users/oracle/obackup
BRD_RETRIES=5
SHELL=/bin/ksh
ORACLE_TERM=vt220
HOME=/
TERM=vt220
ORACLE_HOME=/usr/users/oracle
PWD=/usr/users/oracle
BRD_SAMP_TIME=30
MENU5PATH=/usr/users/oracle/forms30/admin/resource
# /usr/sbin/decedi_config
1. Configure ACAS
2. Configure ObjectBroker
3. Configure database
4. Modify database users
5. Dump database
6. Load database
7. Manage database
8. Exit Configuration
Select option [8] : 3
Configuring Database
Enter the database to be used (Rdb, Inf, Ora) [Ora] :
...Modifying /var/adm/decedi/config.dat
Enter Oracle Home directory /usr/users/oracle] :
Enter DEC/EDI Oracle 7 database location [/usr/users/oracle/db] :
/data1
...Modifying /etc/oratab
...Modifying /var/adm/decedi/config.dat
Enter DEC/EDI Oracle 7 database size in KB [8213744] : 100000
**********************************************************
Default oracle network templates have been generated
in /data1/. The files being:
listener.ora
tnsnav.ora
tnsnames.ora
These files should be merged with those already on this
server (in /etc), and those residing on any PC wishing
to use the CommandCenter or Cockpit to access this
server.
**********************************************************
Press <Return> to continue.
...Replacing /usr/users/oracle/dbs/initdecedidb.ora
...Creating database /data1
Error: Could not create database /data1
Press <Return> to continue.
1. Configure ACAS
2. Configure ObjectBroker
3. Configure database
4. Modify database users
5. Dump database
6. Load database
7. Manage database
8. Exit Configuration
Select option [8] :
# tail -250 /var/adm/decedi/logs/db_errors.log
********************************************************************************
DB error at Tue Apr 15 12:01:43 EET 1997
Commands Issued:
================
#! /bin/sh
ORACLE_HOME=/usr/users/oracle
export ORACLE_HOME
PATH=/usr/users/oracle/bin:/usr/bin:.:/usr/users/oracle/obackup/bin:/usr/users/o
racle/obackup/admin/backup:/usr/users/oracle/bin:/usr/users/oracle/bin
export PATH
ORACLE_SID=decedidb
export ORACLE_SID
cd /usr/users/oracle/dbs
svrmgrl < /tmp/decedi.sql
SQL Statements:
===============
connect internal;
shutdown;
Standard Output
===============
Server Manager: Release 2.0.3 - Production
Copyright (c) Oracle Corporation 1994. All rights reserved.
Oracle7 Server Release 7.1.4.1.1 - Production Release
With the distributed option
PL/SQL Release 2.1.4.0.0 - Production
SVRMGR> ORA-01092: ORACLE instance terminated. Disconnection forced
SVRMGR>
Server Manager complete.
Errors:
=======
********************************************************************************
DB error at Tue Apr 15 12:15:50 EET 1997
Commands Issued:
================
#! /bin/sh
ORACLE_HOME=/usr/users/oracle
export ORACLE_HOME
PATH=/usr/users/oracle/bin:/usr/bin:.:/usr/users/oracle/obackup/bin:/usr/users/o
racle/obackup/admin/backup:/usr/users/oracle/bin
export PATH
ORACLE_SID=decedidb
export ORACLE_SID
cd /usr/users/oracle/dbs
svrmgrl < /tmp/decedi.sql
SQL Statements:
===============
connect internal;
startup pfile=/usr/users/oracle/dbs/initdecedidb.ora nomount;
--
-- WARNING - This file is automatically generated by sqlgen.
-- Any changes to this file will almost certainly be lost.
--
--
-- M-) Digital Equipment Corporation 1994. All rights reserved.
--
--
-- Restricted Rights: Use, duplication, or disclosure by the U.S.
-- Government is subject to restrictions as set forth in subparagraph
(c)
-- (1) (ii) of DFARS 252.227-7013, or in FAR 52.227-19, or in FAR
-- 52.227-14 Alt. III, as applicable.
--
-- This software is proprietary to and embodies the confidential
-- technology of Digital Equipment Corporation. Possession, use, or
-- copying of this software and media is authorized only pursuant to a
-- valid written license from Digital or an authorized sublicensor.
--
--
-- ++
-- Facility: DEC/EDI
--
-- Module Description:
s--
-- decedi__db_ora_create_db.sql
--
-- Schema definition for database creation
--
-- Authors:
-- Doug Pickering, EDI Engineering
--
-- decedi__db_ora_create_db.sql: (DEC/EDI) Doug Pickering, EDI
Engineeri
ng
--
-- CREATION DATE: 13-Oct-1994
--
-- MODIFICATION HISTORY:
--
-- Initials Revision Date Problem source Comment
--
-- --
--
-- /* sql script for all tables */
set echo on;
--
-- Create the main database system file - this will contain the
dictionary
--
create database "decedidb"
maxinstances 8
maxlogfiles 32
character set "US7ASCII"
datafile
'/data1/decedi_system.dbf' size 10M
logfile
'/data1/decedi_log1.dbf' size 500k,
'/data1/decedi_log2.dbf' size 500k,
'/data1/decedi_log3.dbf' size 500k;
--
-- Create the Rollback tablespace and additional rollback segments
--
create rollback segment r0 tablespace system
storage (initial 16K next 16K minextents 2 maxextents 20);
alter rollback segment r0 online;
create tablespace rbs
datafile
'/data1/decedi_rbs.dbf' size 8M
default storage (
initial 128K
next 128K
pctincrease 0
minextents 2 );
create rollback segment r01 tablespace rbs;
create rollback segment r02 tablespace rbs;
create rollback segment r03 tablespace rbs;
create rollback segment r04 tablespace rbs;
alter rollback segment r01 online;
alter rollback segment r0 offline;
drop rollback segment r0;
--
-- Create the data tablespace where all the tables will be held
--
create tablespace mdata
datafile
'/data1/decedi_mdata.dbf' size 57100K ;
--
-- Create the index tablespace where all the indexes will be held
--
create tablespace mindex
datafile
'/data1/decedi_mindex.dbf' size 16312K ;
--
-- Create the temporary tablespace where all the sorting will be done
--
create tablespace mtemp
datafile
'/data1/decedi_mtemp.dbf' size 8156K ;
commit;
shutdown;
Standard Output
===============
Server Manager: Release 2.0.3 - Production
Copyright (c) Oracle Corporation 1994. All rights reserved.
Oracle7 Server Release 7.1.4.1.1 - Production Release
With the distributed option
PL/SQL Release 2.1.4.0.0 - Production
SVRMGR> Connected to an idle instance.
SVRMGR> ORACLE instance started.
SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR>
SVRMGR>
SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR>
SVRMGR>
SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR>
SVRMGR>
SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR>
SVRMGR>
SVRMGR> SVRMGR> SVRMGR> SVRMGR> Echo ON
SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> 2> 3> 4>
5>
6> 7> 8> 9> 10> create database "decedidb"
*
ORA-01501: CREATE DATABASE failed
ORA-00200: cannot create control file '/data1/decedi_ctrl1.dbf'
ORA-07352: sfccf: create error, unable to create file.
DEC OSF/1 (AXP) Error: 13: Permission denied
SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> 2> create rollback
segment
r0 tablespace system
*
ORA-01109: database not open
SVRMGR> SVRMGR> alter rollback segment r0 online
*
ORA-01109: database not open
SVRMGR> SVRMGR> 2> 3> 4> 5> 6> 7> 8>
create t
ablespace rbs
*
ORA-01109: database not open
SVRMGR> SVRMGR> create rollback segment r01 tablespace rbs
*
ORA-01109: database not open
SVRMGR> create rollback segment r02 tablespace rbs
*
ORA-01109: database not open
SVRMGR> create rollback segment r03 tablespace rbs
*
ORA-01109: database not open
sSVRMGR> create rollback segment r04 tablespace rbs
*
ORA-01109: database not open
SVRMGR> SVRMGR> alter rollback segment r01 online
*
ORA-01109: database not open
SVRMGR> SVRMGR> alter rollback segment r0 offline
*
ORA-01109: database not open
SVRMGR> drop rollback segment r0
*
ORA-01109: database not open
SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> 2> 3> create
tablespac
e mdata
*
ORA-01109: database not open
SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> 2> 3> create
tablespac
e mindex
*
ORA-01109: database not open
SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> 2> 3> create
tablespac
e mtemp
*
*
ORA-01109: database not open
SVRMGR> SVRMGR> SVRMGR> commit
*
ORA-01109: database not open
SVRMGR> ORA-01507: database not mounted
Database dismounted.
ORACLE instance shut down.
SVRMGR>
Server Manager complete.
Errors:
=======
|
| 3097.8 | Please ignore the previous log file: | JOBURG::BERETTA | | Tue Apr 15 1997 15:41 | 73 |
| Hi,
The files get created as you can see:
# cd /data1
# ls -l
total 12123
drwxrwxrwx 2 root system 8192 Apr 15 11:40 .tags
-rw-r----- 1 oracle dba 113664 Apr 15 12:30 decedi_ctrl1.dbf
-rw-r----- 1 oracle dba 113664 Apr 15 12:30 decedi_ctrl2.dbf
-rw-r----- 1 oracle dba 113664 Apr 15 12:30 decedi_ctrl3.dbf
-rw-r----- 1 oracle dba 513024 Apr 15 12:30 decedi_log1.dbf
-rw-r----- 1 oracle dba 513024 Apr 15 12:30 decedi_log2.dbf
-rw-r----- 1 oracle dba 513024 Apr 15 12:30 decedi_log3.dbf
-rw-r----- 1 oracle dba 10487808 Apr 15 12:30
decedi_system.dbf
-rw-r--r-- 1 root system 554 Apr 15 12:30 listener.ora
-rw-r----- 1 root operator 8192 Apr 15 11:40 quota.group
-rw-r----- 1 root operator 8192 Apr 15 11:40 quota.user
-rw-r--r-- 1 root system 411 Apr 15 12:30 tnsnames.ora
-rw-r--r-- 1 root system 207 Apr 15 12:30 tnsnav.ora
and a ps awx |grep ora shows :
6381 ?? I 0:00.26 oracledecedidb
(DESCRIPTION=(LOCAL=YES)(ADDRESS)
9607 ?? S 0:00.16 ora_pmon_decedidb
9888 ?? S 0:00.01 ora_dbwr_decedidb
9889 ?? I 0:00.01 ora_smon_decedidb
9895 ?? S 0:00.02 ora_lgwr_decedidb
9897 ?? I 0:00.01 ora_reco_decedidb
9883 ttyp2 S + 0:00.00 grep ora
The previous reply had the some misleading info in the sense that the
protections on /data1 had changed and I had to change them back to the
following:
drwxrwxrwx 3 oracle dba 8192 Apr 15 12:30 data1
With the protection set as above, the entry in the log file is as
follows:
(an extract)
SVRMGR> SVRMGR> SVRMGR> SVRMGR> Echo ON
SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> 2> 3> 4>
5>
6> 7> 8> 9> 10> create database "decedidb"
*
ORA-00603: ORACLE server session terminated by fatal error
ORA-00376: file 1 cannot be read at this time
ORA-01110: data file 1: '/data1/decedi_system.dbf'
ORA-00376: file 1 cannot be read at this time
ORA-01110: data file 1: '/data1/decedi_system.dbf'
ORA-01501: CREATE DATABASE failed
ORA-01519: error while processing file '?/dbs/sql.bsq' near line 365
ORA-00600: internal error code, arguments: [17087], [12606832], [], [],
[], [],
[], []
SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> SVRMGR> 2> create rollback
segment
r0 tablespace system
*
ORA-03114: not connected to ORACLE
SVRMGR> SVRMGR> alter rollback segment r0 online
*
ORA-03114: not connected to ORACLE
SVRMGR> SVRMGR> 2> 3> 4> 5> 6> 7> 8>
create t
ablespace rbs
|
| 3097.9 | Working now with oracle 7.2 | JOBURG::BERETTA | | Wed Apr 16 1997 18:21 | 10 |
| Hi,
Well at last I have got the database created. I reinstalled oracle,
this time using 7.2.2.3.0 and it worked first time. I think something
went wrong during the first installation.
Regards
Peter.
|