underscore in db name

  • From: "Johan Eriksson" <valpis@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 19 Feb 2007 10:24:35 +0100

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: