Home » RDBMS Server » Server Administration » how to use a DB from another Oracle System (Oracle 10g R2 standerd edition)
how to use a DB from another Oracle System [message #437211] Fri, 01 January 2010 11:31 Go to next message
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
Re: how to use a DB from another Oracle System [message #437212 is a reply to message #437211] Fri, 01 January 2010 11:38 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
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.
Re: how to use a DB from another Oracle System [message #437213 is a reply to message #437211] Fri, 01 January 2010 11:39 Go to previous messageGo to next message
babuknb
Messages: 1734
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
Re: how to use a DB from another Oracle System [message #437214 is a reply to message #437211] Fri, 01 January 2010 11:56 Go to previous messageGo to next message
BlackSwan
Messages: 24912
Registered: January 2009
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
Re: how to use a DB from another Oracle System [message #437215 is a reply to message #437212] Fri, 01 January 2010 12:02 Go to previous messageGo to next message
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

Re: how to use a DB from another Oracle System [message #437216 is a reply to message #437215] Fri, 01 January 2010 12:23 Go to previous message
BlackSwan
Messages: 24912
Registered: January 2009
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:
  


Current Time: Fri Sep 30 05:29:19 CDT 2016

Total time taken to generate the page: 0.11533 seconds