**HeiWe did copy the database (this was a 7.6.04 installation) to a new database-server, then did the installation/upgrade v901 on a new Linux server.In earlier versions of the installer you must specify install/upgrade/server-group, but with v 9 (and maybe also v8) the installer detects if there is a database responding with the information you specified.If you install v9 on a clean app-server using the GUI, you must specify Install option, even if your goal is to upgrade the database. The Upgrade option is only if an earlier version is present on the app-server.Regards,Jarl_ARSlist: "Where the Answers Are" and have been for 20 years_2016-01-05 8:19 GMT+01:00 vivek garg <email@example.com>:**Hi Jarl,Just to reconfirm before running the installer ,Did you also install after importing data(entire DB) from some other remedy env first and then install Remedy new version on top of that DB without specifying the value for field "-J BMC_DATABASE_OPTION= "If we do it this way, all tables of Remedy 7.1 will be upgraded to Remedy 9 ver. after installation?Thanks,VivekOn Tue, Jan 5, 2016 at 12:27 PM, Jarl Grøneng <firstname.lastname@example.org> wrote:**Hi1)When doing an upgrade, and installing on a new server I have used this option:
-J BMC_DATABASE_OPTION=2)Yes. And there is no need to specify these either:#-J BMC_DATABASE_DBA_LOGIN=#-J BMC_DATABASE_DBA_PASSWORD=Regards,Jarl2016-01-05 3:08 GMT+01:00 vivek garg <email@example.com>:**Hi Abhijeet,I am also doing the fresh Remedy 9 installation and having the same issue .I have came across following options in options.txt file :Database option # For Pre-created database and tablespaces, set BMC_DATABASE_OPTION to nothing Example: -J BMC_DATABASE_OPTION= # If Overwrite Option is used, tablespaces, Database Objects will be dropped and recreated. #-J BMC_DATABASE_OPTION=<Overwrite|Upgrade|ServerGroup>Database data file name # Enter the entire path name. #-J BMC_DATABASE_DBA_DATAFILE_NAME=<Database File Name> # Database data file size # Enter the value in MB. #-J BMC_DATABASE_DBA_DATAFILE_SIZE=<Database File Size> # New Temporary Tablespace required #-J BMC_DATABASE_ORACLE_NEW_TEMP_TABLESPACE=<NEW|OLD>Please help me with below queries :1. Shouldn't we need to give upgrade option while making entry for BMC_Database_Option as we have imported all tables and data from current prod env and now installing remedy 9 on top of it but instructions saying to keep it as Null.2. do you mean to say when specifying values for Oracle DB parameters in our case for silent installation, we should not provide any value for fields like DBA_DATAFILE_NAME, DATAFILE_SIZE OR BMC_DATABASE_ORACLE_NEW_TEMP_TABLESPACE.What values we should give for specifying oracle parameters now, our DB is ready with 200 GB data from Remedy 7.1 and we want to install remedy 9 with Upgrade option for DB so that it could update all table from Remedy 7.1 ?Thanks,Vivek_ARSlist: "Where the Answers Are" and have been for 20 years_On Mon, Jan 4, 2016 at 7:50 PM, Gadgil, Abhijeet <Abhijeet_Gadgil@bmc.com> wrote:**_ARSlist: "Where the Answers Are" and have been for 20 years_
In case of fresh install you can use pre-created database option, i.e. pre-create single tablespace with 8 data files and then follow steps mentioned under using precreated tablespace for installation
For upgrade you do not specify the data file path.
AbhijeetI think if you check, that part of the silent install is used when ARS is creating the database not installing into an existing database. It is used for setting the initial size of the data file(s).
From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Vikram_Betholi
Sent: Monday, January 04, 2016 7:54 AM
Subject: Issue with Data file and Data size while installing Remedy 9.0.01 in Linux
I am about to install the Remedy 9.0.01 using the Silent feature installation in Linux box.
Right now i have some issue with the DBA DataFile Name and its size.
As part of the Options file we need to give the DBA Data File Name path and in the next line we need to give its size.
But as we have got huge data DBA team has come up withe 8 Data files and the Data is 32GB.
How to map these 8 Data files to DBA Data File Name path and also please let me know whether we should give the Data size in MB or GB
B.Vikram Simha Reddy.
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
_ARSlist: "Where the Answers Are" and have been for 20 years__ARSlist: "Where the Answers Are" and have been for 20 years_