Can We install Oracle client (intstead server) and can use existing oracle database(which is on another remote server) as Metadata repository? Or do I need to install exclusively Oracle (server) on the same machine where I am installing Infosphere 8.1?
Is there any dependency in any case that I need to bring down Metadata Repository before Infosphere Information server?(in such cases where I need to get down Infosphere Information server)
I am new to administration part of Infosphere.How frequently we will bring down the Datastage server? and why?
Can you please clarify?
Thanks
Kiran
Reg:Oracle as MetadataRepository for Infosphere 8.1 install
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 110
- Joined: Mon Jan 11, 2010 4:22 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can install only Oracle client on the engine tier for Information Server. Note that there are special considerations if you want to use an Oracle RAC for your repository.
The correct order for shutdown is engine tier, services tier, repository tier (the last being your Oracle database).
It is rare that Information Server needs to be brought down all the way. To reconfigure the engine tier you only need to shut down that tier; the services and repository tiers may be left running most of the time.
The correct order for shutdown is engine tier, services tier, repository tier (the last being your Oracle database).
It is rare that Information Server needs to be brought down all the way. To reconfigure the engine tier you only need to shut down that tier; the services and repository tiers may be left running most of the time.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 110
- Joined: Mon Jan 11, 2010 4:22 am
Thanks Ray
As per my understanding,we will be installing oracle client on the machine
first and then install Infosphere 8.1 information server on the same machine.
Hence,we will be using the same oracle database(on another server) for our metadata repository as wellas to maintain our own project related data(project specific source and target tables).Is that fine?
If suppose we need bring down Datastage server.
Is there any dependency that I need to bring down Metadata Repository first and then Information server?
Thanks
Kiran
As per my understanding,we will be installing oracle client on the machine
first and then install Infosphere 8.1 information server on the same machine.
Hence,we will be using the same oracle database(on another server) for our metadata repository as wellas to maintain our own project related data(project specific source and target tables).Is that fine?
If suppose we need bring down Datastage server.
Is there any dependency that I need to bring down Metadata Repository first and then Information server?
Thanks
Kiran
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 110
- Joined: Mon Jan 11, 2010 4:22 am
Thanks Ray.
one more question.
Is it advisable to use the same oracle database for our metadata repository(but different schema) as well as to maintain our own project related data(project specific source and target tables)?
Or should we have two different databases each for Metadata repository and project specific (source and target tables)?
Thanks
Kiran
one more question.
Is it advisable to use the same oracle database for our metadata repository(but different schema) as well as to maintain our own project related data(project specific source and target tables)?
Or should we have two different databases each for Metadata repository and project specific (source and target tables)?
Thanks
Kiran
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Either is OK, but don't use the reserved schema name XMETA for your corporate data. I would prefer separate databases, but it will work if they're in the same database.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 110
- Joined: Mon Jan 11, 2010 4:22 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It is not mandatory but I'd strongly recommend that you do so, so as not to violate the Law of Least Astonishment when your administrators have to communicate with IBM Support.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.