OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Problem with SID

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem with SID [message #210949]

Sun, 24 December 2006 01:28

oraclesg2006
Messages: 5
Registered: December 2006

Junior Member

Dear all,

first of all. wish you all merry christmas.

I come across this problem in my work, as a junior oracle DBA, I am using Web Enterprise Manager to perform a cloning of the existing instance. The problem is the EM restricted the SID and global database name to 8 chars, but my boss wants it longer. I am using oracle 10g.

The second dummy question is since each instance has quite a log of tablespaces, that's why boss wants to clone, do you have any other suggestions?

Thanks a lot.

Regards,
Keane

Report message to a moderator

Re: Problem with SID [message #210953 is a reply to message #210949]

Sun, 24 December 2006 02:13

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

first of all. wish you all merry christmas

Marry Christmas to you too.

Understanding How Global Database Names Are Formed
A global database name is formed from two components: a database name and a domain. The database name and the domain name are determined by the following initialization parameters at database creation:

Component Parameter Requirements Example
Database name Must be eight characters or less.
DB_NAME sales

Domain containing the database
Must follow standard Internet conventions. Levels in domain names must be separated by dots and the order of domain names is from leaf to root, left to right.
DB_DOMAIN us.acme.com

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14231/ds_admin.htm

regards
Taj

Report message to a moderator

Re: Problem with SID [message #210969 is a reply to message #210953]

Sun, 24 December 2006 07:03

oraclesg2006
Messages: 5
Registered: December 2006

Junior Member

Hi Taj,

Thanks for the reply. But my problem is more about the SID length. Actually the existing instances all have SID longer than 8 chars. However when I use Oracle Enterprise Manager to do the database clone, it restricts the new SID to be not longer than 8 chars. Is there anyway to bypass the restrict?

Thanks.

Regards,
Keane

Report message to a moderator

Re: Problem with SID [message #210974 is a reply to message #210969]

Sun, 24 December 2006 08:15

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

I am create one database and the database name is more than 8 char.(oracleoracle)

SQL> select name from v$database;

NAME
---------
ORACLEOR

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
oracleoracle

SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------

ORACLEOR

 Clone Database: Error 
 
 
 
Examine and correct the following error(s), then retry the operation.
Destination Global Database Name - The specified database name exceeds 8 characters. 

You Last Clone Page Display like
 Setup  Preferences  Help  Logout 
 
  
     
 
 

   
  
  
  
  
  
  
  
  
  
  
  
   
 Source Working Directory  Select Destination  Destination Options  Schedule  Review  
 

Clone Database: Review 
 

The database oracleoracle on host ALwarid-Taj.fakhruddin.local will be cloned to database database_ALwarid-Taj.fakhruddin.local on host ALwarid-Taj.fakhruddin.local in Oracle Home D:\oracle\product\10.1.0\Db_2.     Step 5 of 5   
 


Job Name  DBClone_oracleoracle_2 
Scheduled  Dec 24, 2006 6:15 PM 

 
 Details 
 
 
 
 
 Source Database 
 
 
 
Global Database Name  ORACLEOR 
Instance Name  oracleoracle 
Database Version  10.1.0.2.0 
Oracle Home  D:\oracle\product\10.1.0\Db_2 
Host  ALwarid-Taj.fakhruddin.local 
Operating System  Microsoft Windows XP Workstation5.1 
Host Username  m.taj 
Working Directory Location  D:\oracle\product\10.1.0\Db_2\database 
Database Username  SYSTEM 
Target Database Name  oracleoracle 
Retain Working Directory  No 
Archiving Mode  ARCHIVELOG 
 
 
   
 Destination Database 
 
 
 
Global Database Name  database 
Instance Name  database 
Oracle Server Version  10.1.0.2.0 
Oracle Home  D:\oracle\product\10.1.0\Db_2 
Host  ALwarid-Taj.fakhruddin.local 
Operating System  Microsoft Windows XP Workstation5.1 
Host Username  m.taj 
Working Directory Location  D:\oracle\product\10.1.0\Db_2\database 
Share Source Working Directory  Yes 
Configuration File Location  D:\oracle\product\10.1.0\Db_2\network\admin 
Database Username  SYSTEM 
 
 
  
 
 
 Destination Database File Locations 
 
 
 
 
 Datafiles 
 
 
 
Name Status Size (KB) 
D:\oracle\product\10.1.0\Db_2\oradata\database\SYSTEM01.dbf SYSTEM 450560 
D:\oracle\product\10.1.0\Db_2\oradata\database\UNDOTBS01.dbf ONLINE 25600 
D:\oracle\product\10.1.0\Db_2\oradata\database\SYSAUX01.dbf ONLINE 215040 
D:\oracle\product\10.1.0\Db_2\oradata\database\USERS01.dbf ONLINE 5120 
 
 
 

 
 Control Files 
 
 
 
Name 
D:\oracle\product\10.1.0\Db_2\oradata\database\CONTROL01.ctl 
D:\oracle\product\10.1.0\Db_2\oradata\database\CONTROL02.ctl 
D:\oracle\product\10.1.0\Db_2\oradata\database\CONTROL03.ctl 
 
 
 

 
 Log Files 
 
 
 
Group Member Size (KB) 
1 D:\oracle\product\10.1.0\Db_2\oradata\database\REDO01.log 10240 
2 D:\oracle\product\10.1.0\Db_2\oradata\database\REDO02.log 10240 
3 D:\oracle\product\10.1.0\Db_2\oradata\database\REDO03.log 10240 
 
 
 

 
 Tempfiles 
 
 
 
Name Status Size (KB) 
D:\oracle\product\10.1.0\Db_2\oradata\database\TEMP01.dbf ONLINE 20480 
 
 
 
 
 
 
 

 
  
 
 
     Step 5 of 5   
  
 

Database   |   Setup   |   Preferences   |   Help   |   Logout 
Copyright � 1996, 2004, Oracle. All rights reserved.  
About Oracle Enterprise Manager 10g Database Control

Report message to a moderator

Re: Problem with SID [message #210977 is a reply to message #210974]

Sun, 24 December 2006 08:28

oraclesg2006
Messages: 5
Registered: December 2006

Junior Member

Hi, Taj,

for your example, after the clone, the new sid will be database. but i want to make the new sid longer than 8 characters. is it impossible for oracle enterprise manager?

thanks,
keane

Report message to a moderator

Re: Problem with SID [message #210978 is a reply to message #210977]

Sun, 24 December 2006 08:35

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

No,

Or It is better you can choose database name is 8 char.

When i was specify Database name more than 8 char. i got below error message.

Examine and correct the following error(s), then retry the operation.
Destination Global Database Name - The specified database name exceeds 8 characters.

Regards
Taj

[Updated on: Sun, 24 December 2006 08:36]

Report message to a moderator

Re: Problem with SID [message #210985 is a reply to message #210978]

Sun, 24 December 2006 10:28

oraclesg2006
Messages: 5
Registered: December 2006

Junior Member

Thanks Taj. But I do need the sid to be longer than 8 characters. Guess I need to find another way instead of using EM to do cloning. Anyone got idea?

Report message to a moderator

Previous Topic:	Building database from hot backup
Next Topic:	databasestatus -metric collection error- in Oracle OEM RAC

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 07:39:53 CST 2024