underscore in db name

From: Johan Eriksson <valpis_at_gmail.com>
Date: Mon, 19 Feb 2007 10:24:35 +0100
Message-ID: <6c133d8a0702190124m6011b5cdoe1930c968df61eb1@mail.gmail.com>

Hi all

I created a new db with dbca (RH4 64bit oracle 10.2.0.3) and named it stage_ms, but when checking the installationsscripts generated where was a file called stagems.sh containing:

#!/bin/sh

mkdir -p /opt/oracle/admin/stage_ms/adump
mkdir -p /opt/oracle/admin/stage_ms/bdump
mkdir -p /opt/oracle/admin/stage_ms/cdump
mkdir -p /opt/oracle/admin/stage_ms/dpdump
mkdir -p /opt/oracle/admin/stage_ms/pfile
mkdir -p /opt/oracle/admin/stage_ms/udump
mkdir -p /opt/oracle/flash_recovery_area
mkdir -p /opt/oracle/product/10.2.0/cfgtoollogs/dbca/stage_ms
mkdir -p /opt/oracle/product/10.2.0/dbs
mkdir -p /oradata1/stage_ms

ORACLE_SID=stagems; export ORACLE_SID
echo You should Add this entry in the /etc/oratab: stagems:/opt/oracle/product/10.2.0:Y
/opt/oracle/product/10.2.0/bin/sqlplus /nolog
@/opt/oracle/admin/stage_ms/scripts/stagems.sql

creating the directories was made correctly but the SID gets stagems. This wouldn't had been any problem but since I already had a db named that it became problems...

Anyone seen this before? Is there a known problem with underscore in db name I am not aware of?

/Johan

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 19 2007 - 03:24:35 CST