Shop

Your Notifications (0)

There are currently no notifications. You're all set!

Demos Trials
Knowledge Base
ChemDraw and ChemOffice+ Products Signals Notebook E-Notebook and ChemBioOffice Enterprise Spotfire and Signals Spotfire Products Columbus Signals Image Artist
Downloads
Downloads
Community
Support Forums Ideas Portal Product Basics
About Support
Legal Resources Support and Maintenance Plans Product Life Cycle Support News
Contact Support

Databases - Oracle 12c Stored Procedure Installation

Rich Talbot
  • Updated
Date Posted:
Product: TIBCO Spotfire®

Problem:

Databases - Oracle 12c Stored Procedure Installation


Solution:

Oracle 12c Stored Procedure Installation

Installing Spotfire Data Science Stored Procedures in an Oracle 12c Database on Linux

 Follow the steps below to install Spotfire Data Science stored procedures within an Oracle 12c Database on a Linux server.  

Note: These setup instructions assume that an Oracle database is already installed and running.

  1. Copy Spotfire Data Science Oracle setup folder (setup/Oracle) to Oracle database host. 
    1. $CHORUS_HOME/alpine-releases/<build>/database_setup.zip
    2. The Oracle database administrator must possess the ownership of the setup directory and all the content in it. 
    3. Issue the chown command as root user to reassign the ownership if necessary. For example:
      chown -R oracle:oinstall /home/oracle/alpine_miner/setup/Oracle
  2. Login to the system as Oracle database administrator (e.g. oracle) on the Oracle database host.
  3. Change to the setup/Oracle directory
    chmod 777 alpine_miner_setup_oracle_linux.sh
  4. run command:
    ./alpine_miner_setup_oracle_linux.sh
  5. Then input the requested Oracle database server information.  

  6. If the script fails complaining about the the user credentials, run a command like this and specify your own parameters:

    /oracle/product/12.1.0/db_1/bin/sqlplus SYS/oracle@oracle12c:1521/orcl AS SYSDBA < alpine_miner_setup_oracle.sql;
# where "SYS/oracle" is the username/password; "oracle12c" is the hostname of the Oracle server; 1521 is the port number; "orcl" is the database name.

Related articles