Answers to questions posed by the ADVISOR Users are now available online and will be updated regularly. Whether searching for a technical answer to a current problem, tips on how to perform a specific function or tricks to minimize effort needed to carry out a task, check out BNH’s responses below. If you cannot find what you are looking for, then email your question to question@bnhexpertsoft.com:
Install ADVISOR
Yes, by installing the Oracle Client and SQL Developer on your computer (workstation).
No. You should run the installation program on the server on which the database should be installed.
Yes, you can run the scripts through SQL Developer on your computer (workstation) connected to the ADVISOR database.
Two steps are involved in the upgrade ADVISOR.
1. Upgrade Database. The following information is needed for this step:
- Database Link
- Database Name
- Password for the user “client”
2. Upgrade ADVISOR program/Java Code. The following information is needed for this step:
- Database Link/URL. To link to database. In general, it has the following format – dbhost:dbport:dbname, where – dbhost:dbport:dbname, where:
dbhost – Database host/computer name
dbport – Database port (for example 1521)
dbname – Database name (for example adv) - Password for the user “client”
- Destination Directory – i.e. where ADVISOR is currently installed
- The web server that ADVISOR is running on and web server directory
- Computer/Notebook with 4 GB RAM or higher
- 200 MB of free Hard Disk Space
- Windows 10, 11, 2016, 2019, 2022; or Oracle Solaris 9.0 or higher
- Microsoft Edge, Google Chrome, Firefox, or Safari
- Plug-ins are not required
In the advisor.properties file located under …/BNH/Advisor/adv/WEB-INF/classes directory.
- 2 CPU Processor with 16 GB RAM
- 50 GB of free Hard Disk Space
- Windows 2016, 2019, 2022, 10, 11 or Oracle Solaris 9.0 or higher, or Linux
- Web Application Server capable of running Java Servlet such as Tomcat 9.x or higher
Yes, the modifications are maintained in all future releases. Each client is assigned a unique ID number. When we customize a feature, we tag the customization to the client ID number. This will in-turn ensure that the customizations (a) are only available to the client and (b) are part of the ADVISOR system and in-turn included all future releases.
ADVISOR supports Oracle version 11g, 12c, 18c, 19c or 21c. If access to Oracle is not available, Oracle 21x Express Edition (XE) may be used at no additional cost. Please note that although XE can be installed on any host, XE limits user data storage to 11 GB of data, only uses 1 GB of memory and one CPU on the host machine. Oracle Standard Edition Two License can also be purchased from BNH. Limited to computers with two processors.
Only Oracle version 11g, 12c, 18c, 19c or 21c is required. If access to Oracle is not available, Oracle 21x Express Edition (XE) may be used at no additional cost. Please note that although XE can be installed on any host, XE limits user data storage to 11 GB of data, only uses 1 GB of memory and one CPU on the host machine. Oracle Standard Edition Two License can also be purchased from BNH. Limited to computers with two processors
- ADVISOR Enterprise is hosted on MS Azure. In addition to comprehensive security, privacy, compliancy & resilience, all US Azure Regions are approved for FedRAMP High Impact Level.
- BNH is certified under the “Controlled Goods Registration Program” (#020638) that entitles BNH to examine, possess or transfer controlled goods in accordance with Defense Production Act and the Controlled Goods Regulation.
- All data sent/received is encrypted using Transport Layer Security (TLS) / Secure Socket Layer (SSL) 3rd part solutions, protecting against disclosure to 3rd parties.
- Comprehensive procedures are in place to detect and prevent unauthorized access, including blocking (denying all requests from) IP where requests are being generated after unsuccessful number of attempts, and notifying system administrator.
- Only two individuals have access to database where client data is stored. Procedures are in place to monitor each access.