[
https://issues.apache.org/jira/browse/AMBARI-2450?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13689438#comment-13689438
]
Sumit Mohanty commented on AMBARI-2450:
---------------------------------------
The behavior of setup is as follows:
{noformat}
Enter advanced database configuration [y/n] (n)? y
Select database:
1 - Postgres(Embedded)
2 - Oracle
[1]:2
Hostname [localhost]:
Port [1521]:
Select type of id to use:
1 - Service Name
2 - Service ID
[1]:1
Service Name [ambari]:
Username [ambari]:
Password []:
{noformat}
Using parameters:
{noformat}
ambari-server setup --database=oracle --databasehost=localhost
--databaseport=1661 --databasename=x23 --databaseusername=ambari
--databasepassword=pwd --sidorsname=sid
{noformat}
Help message
{noformat}
WARNING: Valid values for sid_or_sname are 'sid' or 'sname'. Use 'sid' if the
db identifier type is Service ID. Use 'sname' if the db identifier type is
Service Name
Usage: ambari-server.py [options] action [stack_id]
Options:
-h, --help show this help message and exit
-f INIT_SCRIPT_FILE, --init-script-file=INIT_SCRIPT_FILE
File with setup script
-r DROP_SCRIPT_FILE, --drop-script-file=DROP_SCRIPT_FILE
File with drop script
-u UPGRADE_SCRIPT_FILE, --upgrade-script-file=UPGRADE_SCRIPT_FILE
File with upgrade script
-t UPGRADE_STACK_SCRIPT_FILE,
--upgrade-stack-script-file=UPGRADE_STACK_SCRIPT_FILE
File with stack upgrade script
-j JAVA_HOME, --java-home=JAVA_HOME
Use specified java_home. Must be valid on all hosts
-v, --verbose Print verbose status messages
-s, --silent Silently accepts default prompt values
--database=DATABASE Database to use postgres|oracle
--databasehost=DATABASE_HOST
Hostname of database server
--databaseport=DATABASE_PORT
Database port
--databasename=DATABASE_NAME
Database/Schema/Service name or ServiceID
--databaseusername=DATABASE_USERNAME
Database user login
--databasepassword=DATABASE_PASSWORD
Database user password
--sidorsname=SID_OR_SNAME
Oracle database identifier type, Service ID/Service
Name sid|sname
{noformat}
> Check for SID/Service input for ambari server setup with Oracle since the
> user can provide both.
> ------------------------------------------------------------------------------------------------
>
> Key: AMBARI-2450
> URL: https://issues.apache.org/jira/browse/AMBARI-2450
> Project: Ambari
> Issue Type: Bug
> Components: controller
> Affects Versions: 1.2.4
> Reporter: Sumit Mohanty
> Assignee: Sumit Mohanty
> Fix For: 1.2.4
>
> Attachments: AMBARI-2450.patch
>
>
> Oracle has both options SID and service name, we need to ask for either one-
> right now the only option is servicename. Also the jdbc url link for SID is
> different.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
