BMC Communities Banner
Up to Discussions in Performance Monitoring and Management

This Question is Possibly Answered

1 "correct" answer available (10 pts) 2 "helpful" answers available (5 pts)
3 Replies Last post: Nov 3, 2009 9:11 PM by gotonz  
Bashar Sawaked Enthusiast
Bashar Sawaked
49 posts since
May 30, 2005
Currently Being Moderated

Jul 1, 2008 8:26 AM

Datastore installation on SAN

Hello,

A new question, I wish this will be as a discussion to get the best idea,

I have two SUN servers, I will install Datastore and CDE on one server while the Portal (App server and webserver) will be installed on the server.

The datastore server does not have much space on the local drive, a SAN storage will be attached to the server.

The datastore installation does not give the option to install the binary files of Oracle DB (Engine) on a specific path and the data and log files on another, and this is making me a problem as the SAN storage will be specified.
This means the oracle will be started from the exteral storage which might reflect negatively on the performance!!!

** Is there any way to install the binary files of oracle on a local drive and the data files in a different location? how to configure that if the installation does not give the option?

** Will there be significant degradation in the performance if everything was installed on the external storage of SAN ?

** Can I make a local installation and choose "TRIAL" option in order to get successful installation of the datastode and CDE (this requires 12 GB only)  then I move the data files to the SAN storage? What should be changed in order to change the trial size to medium? is there a specific procedure to do this?


PLEASE HELPPPPP, this is URGENT

Thanks folks

Bashar Sawaked Enthusiast
Bashar Sawaked
49 posts since
May 30, 2005
Currently Being Moderated
1. Jul 12, 2008 8:26 AM in response to: Bashar Sawaked
Re: Datastore installation on SAN

Hello guys,

For those who has the same question, I have consulted BMC Software on this issue, and here are the answers I could get from BMC and from other resources:

Q) Is there any way to install the binary files of oracle on a local drive and the data files in a different location? how to configure that if the installation does not give the option?
A) No, the installation wizard does not have any option to set the binaries localtion and the data files path.

Q) Will there be significant degradation in the performance if everything was installed on the external storage of SAN ?
A) BMC did not do any benchmarking but they believe that there will not be any noticeable degradation in performance if everything has been run on the SAN.

Q) Can I make a local installation and choose "TRIAL" option in order to get successful installation of the datastode and CDE (this requires 12 GB only) then I move the data files to the SAN storage? 
This option will work, the only different between the size options is some configuration, sizes, and number of data files. you can change and configure these differences after moving the datafiles to the SAN. This options works fine, but it depends on good Oracle knowledge.

Q) What should be changed in order to change the trial size to medium? is there a specific procedure to do this? PLEASE HELPPPPP, this is URGENT
A) I could find a list of tablespaces to be configured in the installation manual. I am not sure of the full list of configuration files to be changed.

Hope it helps somebody!!!

Report Abuse
metcalfep Participant
metcalfep
5 posts since
Jun 10, 2008
Currently Being Moderated
2. Jun 16, 2009 11:34 AM in response to: Bashar Sawaked
Re: Datastore installation on SAN

When you install the Portal Application during setup you are asked what type of installation you are doing

Trial, Small or Large which is based on the number of elements(servers,switches, etc)

The database is sized accordingly

There is also a sizing document on the BMC website in the documenation section for Portal

 

Patrick

Report Abuse
gotonz Enthusiast
gotonz
53 posts since
Apr 24, 2008
Currently Being Moderated
3. Nov 3, 2009 9:11 PM in response to: metcalfep
Re: Datastore installation on SAN

Hi,

 

You can setup BMC Datastore without creating any instance. it will setup Oracle database engine only.

after this you can create the instance using oracle tools ./dbca , you will have Oracle database installation GUI.

you can specify specific directory there for data files (SAN storage that already attached to the server).

after the instance created successfully, you need to setup the instance using sqlscript from BPM_Support_Script folder.

For setting up the tablespace, user and system resource.

in this case the tablespace will have auto increase setting.

 

Rgds,

Report Abuse

Advertisement

More Like This

  • Retrieving data ...