8.1.7 on RH7.3 database creation problems.

From: dbuckingham <member8912_at_dbforums.com>
Date: Wed, 06 Aug 2003 03:33:10 +0000
Message-ID: <3205456.1060140790@dbforums.com>

Hi There,

I am trying to create a database manually in Redhat 7.3 running Oracle 8.1.7.

I have installed Oracle with out any apparent problems on the system. Now when I try to physically create the database I am getting errors. The steps that I am following are:

Set the Linux environment

ORACLE_HOME, ORACLE_BASE and PATH in the .bash_profile.

2. Set SID

ORACLE_SID=TEMPUS2; export ORACLE_SID

3. Start instance:

$svrmgrl

SVRMGR> connect internal/oracle
SVRMGR> connected
SVRMGR>startup nomount pfile=’/sdc1/tempus2/pfile/inittempus2.ora

instance started
ORA-01012: not logged in

I am not sure why I am getting this oracle error here? Reading the documentation that I have found, indicates that is should only get the above line svrmgr>instance started.

I have another RH7.3 machine here with Oracle 8.1.7 on it and when I try the above on it, and it starts up without any issues.

4. Attempt to create database

SVRMGR> exit
$svrmgrl

SVRMGR>connect internal/oracle
SVRMGR> shutdown abort
instance shutdown
SVRMGR> @/sdc1/tempus2/create/tempus.sh
MGR-01507: unable to open file tempus2.log CREATE DATABASE TEMPUS2
*
ORA-01012 – not logged in.

Where the file that I am attempting to execute is:

SPOOL tempus2.log
STARTUP NOMOUNT PFILE=/sdc1/tempus2/pfile/inittempus2.ora CREATE DATABASE TEMPUS2
  MAXLOGFILE 5
  MAXLOGMEMBERS 5
  MAXDATAFILES 100
  MAXLOGHITORY 100
LOGFILE
   GROUP 1 ('/sdb1/tempus1/mlnc1a.rdo','/sdb1/tempus1/mlnc1b.rdo') size    5M,
   GROUP 2 ('/sdb1/tempus1/mlnc2a.rdo','/sdb1/tempus1/mlnc2b.rdo') size    5M,
   GROUP 3 ('/sdb1/tempus1/mlnc3a.rdo','/sdb1/tempus1/mlnc3b.rdo') size    5M
DATAFILE
   '/sdb1/tempus1/system.dbf' SIZE 400M AUTOEXTEND ON NEXT 5M CHARACTER SET WE8ISO8859P1 Does anyone have any ideas as to why this may occur on one machine and not the other?

My ultimate aim is to create 4 database instances on this machine, can anyone see anything wrong with what I am doing?

PS, I know that 8.1.7 is not supported by Oracle on RH7.3 but it is what I have to work with for now.

--
Posted via http://dbforums.com

Received on Tue Aug 05 2003 - 22:33:10 CDT