ODI 12c - Upgrade Procedure ODI 12.2.1.2.6 To 12.2.1.4

Di seguito gli step necessari all'Upgrade del software ODI dalla versione 12.2.1.2.6 alla versione 12.2.1.4.0

STEP	NOTA
Creazione clone macchina DB
Riconfigurazione /etc/hots	1.      Configurazione del file /etc/hosts
Riconfigurazione network DB	1.      Modifica configurazione listener.ora con nuovo <hostname> 2.      Modifica configurazione tnsnames.ora con nuovo <hostname> 3.      Avvio listener
Startup DB	1.      Avvio istanza di database METAINTA
Creazione clone macchina ODI
Riconfigurazione /etc/hots	1)Configurazione del file /etc/hosts
Eseguire riconfigurazione Repository ODI - Connettersi al Master Repository   SUPERVISOR/Welcome1$	1.      Modifica URL ODI STUDIO Connection Login INFOBOARD_SVIL con nuovo IP 2.      modificare i puntamenti del workrepository sulla macchina del DB clonato 1.      (Modifica Topology\Repositories\Work Repositories\WORKREP\JDBC\JDBC URL con nuovo IP)  3.      modificare i puntamenti dell'agent alla nuova macchina ODI clonata 4.      disabilitare tutte le schedulazione dell'agent sulla tabella SNP_PLAN_AGENT 1.      Backup tabella SNP_PLAN_AGENT 2) UPDATE a D : UPDATE SNP_PLAN_AGENT SET  STAT_PLAN        = 'D';
Riconfigurazione Dominio WebLogic	Modificare nel file config.xml  il nome del vecchio Hostname col nuovo clonato Modificare nel file nodemanager.properties il nome del vecchio hostname con quello clonato Eseguire config.sh sostituendo il nome del vecchio hostname db con quello clonato ed il nome del vecchio hostname odi con quello clonato. Al termine delle operazioni di riconfigurazione deve apparire quanto segue:      Admin Server URL:         http://<hostname_odi_clone>:7001
Start weblogic	cd <ODIDOM>/bin/ nohup ./startNodeManager.sh >nmout.log  & nohup ./startWebLogic.sh >out.log  &
Connettersi alla console di Weblogic e test agent ODI	Collegarsi alla console : 1.      https://<hostname_odi_clone>:7001/console 0.      Verificare che l'Admin sia RUNNING 1.      Start Managed Server di ODI
Shutdown di tutti i processi Weblogic	1)Stop di tutti i processi weblogic chiudendoli dalla console: ·        https://<hostname_odi_clone>:7001/console 2)  cd <ODIDOM>/bin ·        ./stopNodeManager.sh 3)Verifica dell'assenza di processi java attivi e riferibili a weblogic: ·        ps -ef | grep java
Installazione software ODI 12.2.1.4.0	JDK FMW 12.2.1.4.0 ODI 12.2.1.4.0
Verifica se il Repository può essere upgradato e stop di tutti i processi	Start the Upgrade Assistant. (UNIX) ./ua -readiness
Verifica degli schema presenti	SET LINE 120 COLUMN MRC_NAME FORMAT A14 COLUMN COMP_ID FORMAT A20 COLUMN VERSION FORMAT A12 COLUMN STATUS FORMAT A9 COLUMN UPGRADED FORMAT A8 SELECT MRC_NAME, COMP_ID, OWNER, VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY ORDER BY MRC_NAME, COMP_ID ;
Inizio Upgrade ODI alla 12.2.1.4.0	Settare i path della versione ODI 12.2.1.4.0 quando ci si collega alla macchina CLONE nel .bash_profile
Upgrading Product Schemas Using the Upgrade Assistant	Start the Upgrade Assistant. (UNIX) ./ua   select Individually Selected Schemas.   Save Response File
Verifica degli schema presenti upgradati	SET LINE 120 COLUMN MRC_NAME FORMAT A14 COLUMN COMP_ID FORMAT A20 COLUMN VERSION FORMAT A12 COLUMN STATUS FORMAT A9 COLUMN UPGRADED FORMAT A8 SELECT MRC_NAME, COMP_ID, OWNER, VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY ORDER BY MRC_NAME, COMP_ID ;   OPPURE   SELECT MRC_NAME, COMP_ID, OWNER, VERSION, STATUS, UPGRADED       FROM SCHEMA_VERSION_REGISTRY ORDER BY UPGRADED desc ;
Backing Up the Domain	Domain Location: <ODIDOM>   (UNIX) cp -rf mydomain mydomain_backup cp -rf <ODIDOM> <ODIDOM_20210630>
Reconfiguration Wizard Domain	Start Reconfig Assistant (UNIX) ./reconfig.sh  -log=<inserire path e file di log> -log_priority=ALL   where -log=log_file is the absolute path of the log file you'd like to create for the domain reconfiguration session. This can be helpful if you need to troubleshoot the reconfiguration process. The parameter -log_priority=ALL ensures that logs are logged in fine mode.   The Reconfiguration Progress screen displays the progress of the reconfiguration process. During this process: • Domain information is extracted, saved, and updated. • Schemas, scripts, and other such files that support your Fusion Middleware products are updated. When the progress bar shows 100%, click Next.
Upgrading Domain Component Configurations	Start the Upgrade Assistant. (UNIX) ./ua   Select All Configurations Used By a Domain. The screen name changes to WebLogic Components.
Starting Servers and Processes	Domain Location:         <ODIDOM>   Step 1: Start the Administration Server: (UNIX) NEW_DOMAIN_HOME/bin/startWebLogic.sh Step 2: Start Node Manager (UNIX) NEW_DOMAIN_HOME/bin/startNodeManager.sh Step 3: Start eventuali ORACLE Components (UNIX) NEW_DOMAIN_HOME/bin/startComponent.sh component_name Step 4: Start the Managed Servers - se necessario (UNIX)NEW_DOMAIN_HOME/bin/startManagedWebLogic.sh managed_server_name admin_url   Eseguire step 1 e 2 e poi collegarsi alla console per verifica servizi, processi e start managed server ODI:   https://<hostname_odi_clone>:7001/console http://titappocm11lits:7001/console/login/LoginForm.jsp   LOG: /u01/data/domains/ODI12INF/INF-ODIDOM_SVIL/servers/ODI_INF_SVIL_1/logs/ODI_INF_SVIL_1.log /u01/data/domains/ODI12INF/INF-ODIDOM_SVIL/servers/ODI_INF_SVIL_1/logs/oracledi/odiagent.log
	CHECK domain with line command:   cd /u01/app/oracle/middleware/ODI12214INF/oracle_common/common/bin [oracle@titappocm11lits bin]$ ./wlst.sh   Initializing WebLogic Scripting Tool (WLST) ...   Welcome to WebLogic Server Administration Scripting Shell   Type help() for help on available commands   wls:/offline> readDomain('/u01/data/domains/ODI12INF/INF-ODIDOM_SVIL') wls:/offline/INF-ODIDOM_SVIL>ls () drw-   AppDeployment drw-   CoherenceClusterSystemResource drw-   Credential drw-   EmbeddedLDAP drw-   JDBCSystemResource drw-   Keystore drw-   Library drw-   Machine drw-   NMProperties drw-   Security drw-   SecurityConfiguration drw-   Server drw-   ServerTemplate drw-   ShutdownClass drw-   StartupClass drw-   StartupGroupConfig drw-   WLDFSystemResource   -rw-   Active                                        false -rw-   AdminServerName                               AdminODI_INF_SVIL -rw-   AdministrationMBeanAuditingEnabled            false -rw-   AdministrationPort                            9002 -rw-   AdministrationPortEnabled                     false -rw-   AdministrationProtocol                        t3s -rw-   ArchiveConfigurationCount                     0 -rw-   AutoDeployForSubmodulesEnabled                true -rw-   BatchJobsDataSourceJndiName                   null -rw-   BatchJobsExecutorServiceName                  null -rw-   ClusterConstraintsEnabled                     false -rw-   ConfigBackupEnabled                           false -rw-   ConfigurationAuditType                        null -rw-   ConfigurationVersion                          12.2.1.4.0 -rw-   ConsoleContextPath                            console -rw-   ConsoleEnabled                                true -rw-   ConsoleExtensionDirectory                     console-ext -rw-   DbPassiveMode                                 false -rw-   DbPassiveModeGracePeriodSeconds               30 -rw-   DiagnosticContextCompatibilityModeEnabled     true -rw-   DomainVersion                                 12.2.1.4.0 -rw-   EnableEeCompliantClassloadingForEmbeddedAdaptersfalse -rw-   ExalogicOptimizationsEnabled                  false -rw-   Id                                            0 -rw-   InternalAppsDeployOnDemandEnabled             true -rw-   JavaServiceConsoleEnabled                     false -rw-   JavaServiceEnabled                            false -rw-   LastModificationTime                          0 -rw-   LogFormatCompatibilityEnabled                 false -rw-   MaxConcurrentLongRunningRequests              50 -rw-   MaxConcurrentNewThreads                       50 -rw-   MsgIdPrefixCompatibilityEnabled               true -rw-   Name                                          INF-ODIDOM_SVIL -rw-   Notes                                         null -rw-   OCMEnabled                                    true -rw-   ParallelDeployApplicationModules              false -rw-   ParallelDeployApplications                    false -rw-   PartitionUriSpace                             /partitions -rw-   ProductionModeEnabled                         false -rw-   RootDirectory                                 null -rw-   ServerMigrationHistorySize                    100 -rw-   ServiceMigrationHistorySize                   100 -rw-   SiteName                                      null -rw-   Tag
CHECK UPGRADE	CHECK con connessione ODI tramite ODISTUDIO versione 12.2.1.4.0 1.      Check OdiAgent