Table of Contents | ||||||
---|---|---|---|---|---|---|
|
...
Extract Application and Database dump-file
ViennaAdvantage Database Import
VIENNA Advantage website IIS Hosting instructions
Edit configuration file with database information
Access VIENNA Advantage Application.
Register VIENNA Advantage application.
Install/Update Application/Module.
...
1. Extract
Extract Application files from Archive (here we assume to "C:\Tmp\")
Move or copy Folder "C:\Tmp\VIENNA_Advantage_ERP_CRM_HTML5_4_6_3_Oracle\ViennaAdvantageHtml5_HostingFiles\
...
ViennaAdvantage"
...
TO
Webroot (here we assume "C:\inetpub\wwwroot\")
...
2. ViennaAdvantage Database Import
VA Data Import - Oracle
Please follow below steps if you are going to use Oracle Database 12cR2 or above only and not PostgreSQL.
Create VA User in Oracle
Connect to DB via SQLPLUS or SQLDeveloper with sys or system user and execute below commands.
...
(
...
For pluggable database change to the
...
appropriate container first for example using Oracle 21XE: alter session set container = xepdb1)
SQL> alter session set "_ORACLE_SCRIPT"=true;
Result: Session altered.
SQL> create user USERNAME identified by PASSWORD;
Result: User created.
SQL> grant dba, connect, resource , create view to USERNAME;
Result: Grant succeeded.
SQL> alter user USERNAME default tablespace users;
Result: User altered.
SQL> conn USERNAME/PASSWORD
Result: Connected.
...
SQL>exit
...
Import Data in DB User Schema (Assuming you extracted to "C:\Temp" the oracle dump will be
in"C:\Temp\VIENNA_Advantage_ERP_CRM_HTML5_4_6_3_Oracle\ViennaAdvantageHTML5_DB\vacommunity.DMP" )
Open command prompt in administrator mode and execute below command to import VA Data in DB user
imp USERNAME/PASSWORD File=’DB-Dump-File-Path.dmp’ Full=Y
Note: Please change USERNAME & Password in above commands as per your requirement