Myroslav Papirkovskyy created AMBARI-4463:
---------------------------------------------
Summary: 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)
