Results 1 to 5 of 5

Thread: Oracle RAC

  1. #1
    Join Date
    Jan 2013
    Posts
    3

    Unanswered: Oracle RAC

    Hi All,

    First of all i would like to start off by saying that i'm sorry if i raised any NOOB questions. I have just basic knowledge of Oracle and database systems

    I own the application but not the DB. The DB is being configured by the DB team i could not obtain any information from them (reason cannot be disclosed here)

    I have a environment which ORACLE RAC has been configured. At first my application does not support Oracle RAC setup. As an interim solution, i created the tables locally and connect directly to the machine by-passing the SCAN hostname.

    The application now supports RAC. the steps i have to do now is shift my tables from local into the cluster.
    The problem is
    1) i do not know where is the cluster file system is
    2) how do i shift my database data to the cluster system

    Any help is much appreciated

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    expdp & impdp would be one way to move the data between the databases.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2013
    Posts
    3
    Hi anacedent, thx for the reply

    yeah expdp and impdp would be a good way to move the data. But now i still currently do not know which cluster location was the RAC assigned to. Or it does not matter as long as is a cluster file system?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >But now i still currently do not know which cluster location was the RAC assigned to
    I do not understand this statement above.
    Either you can connect to the RAC or you can't connect to it.
    If you can not connect to it, then no options exist for you.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jan 2013
    Posts
    3
    Correct me if i'm wrong but Oracle RAC's configuration is having a few listeners depending on how many nodes you have, and all of them connected to a shared storage which the database will be stored on?

    if the answer to the above question is yes. during the oracle RAC installation, is there a need to specify the path or location of the shared storage?

    and the answer is yes, where can i find this configuration.

    and if the answer is no, does that mean that i can put the database anyway as long as it is in the shared storage maintained by the OS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •