OraFAQ Forum: Server Administration » how to use a DB from another Oracle System

Home » RDBMS Server » Server Administration » how to use a DB from another Oracle System (Oracle 10g R2 standerd edition)

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

how to use a DB from another Oracle System [message #437211]

Fri, 01 January 2010 11:31

needee
Messages: 19
Registered: November 2009

Junior Member

I have two Linux machines(node1, node2), where I have installed Oracle10gR2 Standard Edition, with all same configuration.

On both machines(node1, and node2) complete oracle(binaries/DB) installed under /opt/oracle.

On node1, using dbca(Database Configuration Assistant) created a new DB(orcle_test) on a separate Disk/filesystem/mountpoint named '/u01', so the complete path of this new DB is '/u01/orcl_test'.
Then I shutdown Oracle, and node1. moved the /u01 disk from node1, and plug the disk on node2, then on node2 mount the disk under /u01. I can see the DB under /u01/orcl_test on node2.

Question
So how can I instruct/configure the Oracle running on node2, to use/recognize the new DB(created on node2 via dbca) .. i.e I want to use the DB(/u01/orcl_test) on node2.

Please help me(I just know Linux and not Oracle)
Regards

Report message to a moderator

Re: how to use a DB from another Oracle System [message #437212 is a reply to message #437211]

Fri, 01 January 2010 11:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>created a new DB(orcle_test) on a separate Disk/filesystem
>the complete path of this new DB is '/u01/orcl_test'

Computers are picky, picky, picky.

What is actual ORACLE_SID, "orcle_test" or "orcl_test"?
Ideally ORACLE_SID name length should be 8 characters or fewer.

You need to move spfileSID.ora file from node1 to node2.

Report message to a moderator

Re: how to use a DB from another Oracle System [message #437213 is a reply to message #437211]

Fri, 01 January 2010 11:39

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>So how can I instruct/configure the Oracle running on node2, to use/recognize the new DB(created on node2 via dbca) .. i.e I want to use the DB(/u01/orcl_test) on node2.

If your mount point structure same then you can create database in Server B & mount in Server A. (like /u01/<<DBNAME>>

-Babu

Report message to a moderator

Re: how to use a DB from another Oracle System [message #437214 is a reply to message #437211]

Fri, 01 January 2010 11:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Oracle is NOT consistent with DB_NAME (SID) length

  1* select table_name, data_length from dba_tab_columns where column_name = 'DB_NAME' and owner = 'SYS'
SQL> /

TABLE_NAME		       DATA_LENGTH
------------------------------ -----------
V_$LOGMNR_DICTIONARY			 9
V_$LOGMNR_LOGS				 8
GV_$LOGMNR_DICTIONARY			 9
GV_$LOGMNR_LOGS 			 8
V_$LOGMNR_LOGFILE			 8
V_$LOGMNR_SESSION		       128
GV_$LOGMNR_LOGFILE			 8
GV_$LOGMNR_SESSION		       128
GV_$ASM_CLIENT				 8
V_$ASM_CLIENT				 8
LOGMNRG_DICTIONARY$			 9
LOGMNRT_DICTIONARY$			 9
WRM$_DATABASE_INSTANCE			 9
DBA_HIST_DATABASE_INSTANCE		 9

Not everything works well when LENGTH > 8 & SIDs are similar

Report message to a moderator

Re: how to use a DB from another Oracle System [message #437215 is a reply to message #437212]

Fri, 01 January 2010 12:02

needee
Messages: 19
Registered: November 2009

Junior Member

Hi Thanks BlackSwan

>What is actual ORACLE_SID, "orcle_test" or "orcl_test"?
OOppps, typo. its 'orcltest' without underscore(_).

>You need to move spfileSID.ora file from node1 to node2.

on node1, search for "spfile*.ora" shows me the following result
/opt/oracle/product/10.2/db_1/dbs/spfileorcl.ora
/opt/oracle/product/10.2/db_1/dbs/spfileorcltest.ora

I think I should move the last 'spfileorcltest.ora' file

just copying 'spfileorcltest.ora' on node2 is enough ? or do I need to shutdown/start oracle on node2 to recognize new changes.

Regards

Report message to a moderator

Re: how to use a DB from another Oracle System [message #437216 is a reply to message #437215]

Fri, 01 January 2010 12:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>just copying 'spfileorcltest.ora' on node2 is enough ?
Ideally, yes; just copy should be enough.

[Updated on: Fri, 01 January 2010 12:23]

Report message to a moderator

Previous Topic:	Rename datafile in Production when using Physical Standby
Next Topic:	Unable to re-install oracle 11g rel2 on same oracle_home path

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 08:16:29 CDT 2024