I am getting below error : ORA-00904 : “OVERLAYGROUP” : Invalid identifier
and installer is still running, any ideas how should we proceed. Should we stop the installer in between now ? On Wed, Jan 6, 2016 at 3:46 PM, vivek garg <anupgar...@gmail.com> wrote: > what value we should give for our case for the below parameter : > > Required for DB Only Upgrade where No File System is present and DB > Version is older > #-J BMC_DBONLY_UPGRADE_CONFIRM=<true\false> > > On Wed, Jan 6, 2016 at 3:32 PM, vivek garg <anupgar...@gmail.com> wrote: > >> Hi Jarl, >> >> While running installer today, I gave the following option: >> >> J BMC_DATABASE_OPTION= >> >> But installer end up with an error message saying "Invalid >> DatabaseUpgardeOption". >> Please suggest what value we should in this case now ? >> >> Thanks, >> Vivek >> >> On Tue, Jan 5, 2016 at 7:26 PM, Jarl Grøneng <jarl.gron...@gmail.com> >> wrote: >> >>> ** >>> Hi >>> >>> Should not be an issue, but I would confirmed that upgrade from 7.1 to >>> V9 is supported, you may go via v7.6.04. >>> >>> The only option for Email Engine is if you want to run it in 32-bit mode >>> or not. Email Engine is installed default, same with flashboard. >>> >>> -J BMC_JAVA_EMAIL_ENGINE_SELECTED_FOR_32BIT=false >>> >>> -- >>> J >>> >>> >>> 2016-01-05 11:53 GMT+01:00 vivek garg <anupgar...@gmail.com>: >>> >>>> ** >>>> Hi, >>>> >>>> Ok, do you suggest that we should do it on Remedy data from 7.1 env. >>>> Also how shall I install Email engine also with this install ? >>>> >>>> What entry we should make for installing email engine ? >>>> Thanks, >>>> Vivek >>>> >>>> On Tue, Jan 5, 2016 at 2:56 PM, Jarl Grøneng <jarl.gron...@gmail.com> >>>> wrote: >>>> >>>>> ** >>>>> Hei >>>>> >>>>> We 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 >>>>> >>>>> >>>>> 2016-01-05 8:19 GMT+01:00 vivek garg <anupgar...@gmail.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, >>>>>> Vivek >>>>>> >>>>>> On Tue, Jan 5, 2016 at 12:27 PM, Jarl Grøneng <jarl.gron...@gmail.com >>>>>> > wrote: >>>>>> >>>>>>> ** >>>>>>> Hi >>>>>>> >>>>>>> 1) >>>>>>> >>>>>>> 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, >>>>>>> Jarl >>>>>>> >>>>>>> >>>>>>> 2016-01-05 3:08 GMT+01:00 vivek garg <anupgar...@gmail.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 >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Jan 4, 2016 at 7:50 PM, Gadgil, Abhijeet < >>>>>>>> abhijeet_gad...@bmc.com> wrote: >>>>>>>> >>>>>>>>> ** >>>>>>>>> >>>>>>>>> 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. >>>>>>>>> >>>>>>>>> Abhijeet >>>>>>>>> >>>>>>>>> >>>>>>>>> -----Original Message----- >>>>>>>>> *From:* Grooms, Frederick W [frederick.w.gro...@xo.com] >>>>>>>>> *Received:* Monday, 04 Jan 2016, 7:44PM >>>>>>>>> *To:* arslist@ARSLIST.ORG [arslist@ARSLIST.ORG] >>>>>>>>> *Subject:* Re: Issue with Data file and Data size while >>>>>>>>> installing Remedy 9.0.01 in Linux >>>>>>>>> >>>>>>>>> I 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). >>>>>>>>> >>>>>>>>> Fred >>>>>>>>> >>>>>>>>> -----Original Message----- >>>>>>>>> From: Action Request System discussion list(ARSList) [ >>>>>>>>> mailto:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>] On Behalf Of >>>>>>>>> Vikram_Betholi >>>>>>>>> Sent: Monday, January 04, 2016 7:54 AM >>>>>>>>> To: arslist@ARSLIST.ORG >>>>>>>>> Subject: Issue with Data file and Data size while installing >>>>>>>>> Remedy 9.0.01 in Linux >>>>>>>>> >>>>>>>>> Hi, >>>>>>>>> >>>>>>>>> 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 >>>>>>>>> >>>>>>>>> With regards, >>>>>>>>> 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_ >>>>>>>> >>>>>>> >>>>>>> _ARSlist: "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_ >>>>> >>>> >>>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>>> >>> >>> _ARSlist: "Where the Answers Are" and have been for 20 years_ >>> >> >> > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"