Before you upgrade to SAS Business Rules Manager
2.2, you should record the database settings in your current environment.
You must enter this information in SAS Deployment Wizard.
-
If you are using the
SAS Web Infrastructure Platform Data Server for your SAS Business Rules Manager
2.1 database, record the database name and the user name for your
database. The default database name is brmdb.
-
If
you are using Oracle for your database, record the following information:
-
fully qualified host name of the
database server
-
port number of the database server
-
Oracle Site Identifier (SID)
-
user ID of the database user whose
credentials are used to access SAS Business Rules Manager data
on the server
-
password of the database user whose
credentials are used to access SAS Business Rules Manager data
on the server
You can find the Oracle
SID in the tnsnames.ora file. You can also determine the SID by running
the following query using a database user ID on your Oracle instance:
select instance from v$thread
You
must enter the SID in the
Database name field
in the
SAS Decision Manager Database JDBC Properties dialog
box in SAS Deployment Wizard.
If
you are using Oracle for your database, ensure that
the Oracle client is installed on your server tier and that there
is a matching tnsnames.ora file for the SAS Decision Manager
database.
See
SAS Deployment Wizard Information for Oracle for information
about the tnsnames.ora file.