[
https://issues.apache.org/jira/browse/AMBARI-4463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Myroslav Papirkovskyy resolved AMBARI-4463.
-------------------------------------------
Resolution: Fixed
> Need better instruction when ambari-server upgrade fails as sql client is not
> available
> ---------------------------------------------------------------------------------------
>
> Key: AMBARI-4463
> URL: https://issues.apache.org/jira/browse/AMBARI-4463
> Project: Ambari
> Issue Type: Bug
> Components: controller
> Affects Versions: 1.4.3
> Reporter: Myroslav Papirkovskyy
> Assignee: Myroslav Papirkovskyy
> Priority: Critical
> Fix For: 1.4.4
>
>
> *Upgrade schema*
> sqlplus -S
> 'user/pass@(description=(address=(protocol=TCP)(host=oraclehost)(port=1521))(connect_data=(SID=db_SID)))'
> @/var/lib/ambari-server/resources/upgrade/ddl/Ambari-DDL-Oracle-UPGRADE.sql
> *Update local repo uri*
> sqlplus -S
> 'user/pass@(description=(address=(protocol=TCP)(host=oraclehost)(port=1521))(connect_data=(SID=db_SID)))'
>
> @/var/lib/ambari-server/resources/upgrade/dml/Ambari-DML-Oracle-INSERT_METAINFO.sql
> <key> <value>
> key: is the key for the local repo url – of the form
> "repo:/HDP/<version>/<os>/<repoid>:baseurl"
> Example: repo:/HDP/1.3.3/centos6/HDP-1.3.3:baseurl
> value: the value of the local repo url
> *Update usage of HDPLocal- to HDP-*
> sqlplus -S
> 'user/pass@(description=(address=(protocol=TCP)(host=oraclehost)(port=1521))(connect_data=(SID=db_SID)))'
>
> @/var/lib/ambari-server/resources/upgrade/dml/Ambari-DML-Oracle-FIX_LOCAL_REPO.sql
> For all commands, ensure that appropriate values for "user", "pass",
> "oraclehost", "db_SID" is used.
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
