8.1.7.4 & svrmgrl - ora-12560

From: Damian Powell <damianp_at_cgp.co.uk>
Date: 7 May 2003 03:25:39 -0700
Message-ID: <6057d720.0305070225.63a1426a@posting.google.com>

Hi,

I recently installed the 8.1.7.4 patch to our Oracle server (running on W2K). Since then, I have not been able to create another database. One of my colleagues is having a similar problem with another machine that has had the same patch. Other systems we have that are 8.1.7.0 can still successfully run the creation scripts we are using without any problems. Can anyone shed any light on this? Your attention is appreciated.

I have included a snippet below.

Many thanks,
Damian.

From command prompt:

> D:\oracle\admin\waqd\create\database>e:\oracle\ora81\bin\svrmgrl
> @d:\oracle\admin\waqd\create\database\waqdrun.sql
>
> Oracle Server Manager Release 3.1.7.0.0 - Production
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> ORA-12560: TNS:protocol adapter error
> Echo ON
> SVRMGR> connect INTERNAL/oracle
> ORA-12560: TNS:protocol adapter error

waqdrun.sql contains:

spool d:\oracle\admin\waqd\create\logs\createdb set echo on
connect INTERNAL/oracle
startup nomount pfile="d:\oracle\admin\waqd\pfile\initwaqd.ora" CREATE DATABASE waqd

LOGFILE GROUP 1  ('d:\oracle\oradata\waqd\redo_01_a.log',
			'd:\oracle\oradata\waqd\redo_01_b.log') SIZE 4096K,
        GROUP 2  ('d:\oracle\oradata\waqd\redo_02_a.log',
			'd:\oracle\oradata\waqd\redo_02_b.log') SIZE 4096K,
        GROUP 3  ('d:\oracle\oradata\waqd\redo_03_a.log',
			'd:\oracle\oradata\waqd\redo_03_b.log') SIZE 4096K

MAXLOGFILES 30
MAXLOGMEMBERS 3
MAXLOGHISTORY 1
DATAFILE 'd:\oracle\oradata\waqd\system01.dbf' SIZE 264M REUSE AUTOEXTEND OFF
MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1;
spool off Received on Wed May 07 2003 - 05:25:39 CDT