Home » RDBMS Server » Server Administration » Problem with SID
Problem with SID [message #210949] Sun, 24 December 2006 01:28 Go to next message
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
Re: Problem with SID [message #210953 is a reply to message #210949] Sun, 24 December 2006 02:13 Go to previous messageGo to next message
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
Re: Problem with SID [message #210969 is a reply to message #210953] Sun, 24 December 2006 07:03 Go to previous messageGo to next message
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
Re: Problem with SID [message #210974 is a reply to message #210969] Sun, 24 December 2006 08:15 Go to previous messageGo to next message
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 
Re: Problem with SID [message #210977 is a reply to message #210974] Sun, 24 December 2006 08:28 Go to previous messageGo to next message
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
Re: Problem with SID [message #210978 is a reply to message #210977] Sun, 24 December 2006 08:35 Go to previous messageGo to next message
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 Go to previous message
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?
Previous Topic: Building database from hot backup
Next Topic: databasestatus -metric collection error- in Oracle OEM RAC
Goto Forum:
  


Current Time: Sun Dec 11 04:24:31 CST 2016

Total time taken to generate the page: 0.14375 seconds