| Table of Contents | ||||||
|---|---|---|---|---|---|---|
|
Introduction
What’s in this Guide
...
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 userUSERNAMEidentified byPASSWORD;
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> connUSERNAME/PASSWORD
Result: Connected.
SQL>exit
2. Import Data in DB User Schema
...
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
...
VA Data Import - PostgreSQL
Please follow below steps if you are going to use PostgreSQL Version 12 only and not Oracle DB.
Create VA User in PostgreSQL
Connect to DB via PSQL or PGAdmin4 with postgres user and execute below commands.
postgres=# Create Database DBNAME;
Result: CREATE DATABASE
postgres=# Create user USERNAME with ENCRYPTED PASSWORD 'PASSWORD’;
Result: CREATE ROLE
postgres=# Grant ALL PRIVILEGES ON DATABASE DBNAME TO USERNAME;
Result: GRANT
postgres=# Exit
2. Import Data in created database
Open command prompt in administrator mode and execute below command to import VA Data in database
psql -U USERNAME DBNAME < "DB-Dump-File-Path.sql“
Note: Please change USERNAME & Password in above commands as per your requirement
...
VA Website Hosting in IIS
...
The VIENNA advantage application is now hosted successfully in the system.
...
About VIENNA Advantage Market
...