You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ambari.apache.org by "Myroslav Papirkovskyy (JIRA)" <ji...@apache.org> on 2014/01/30 21:06:09 UTC
[jira] [Commented] (AMBARI-4463) Need better instruction when
ambari-server upgrade fails as sql client is not available
[ https://issues.apache.org/jira/browse/AMBARI-4463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13887003#comment-13887003 ]
Myroslav Papirkovskyy commented on AMBARI-4463:
-----------------------------------------------
Committed to trunk and branch-1.4.4
> 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)