Rate this Content

 
 
 
 
 
 
 
Rate
 
 
 
 
 
 
0 Rates
0 %
1
5
0
 

SA Server/IDConfirm 1000 installer (in the SetupPortal Web page) cannot reach my Oracle database previously created by the official SQL scripts

Applies to

SA Server v5.2/IDConfirm 1000

Content

Once SA Server/IDConfirm 1000 installed, in the SetupPortal Web page the database can be automatically created This database can also be created previously and separately by the Database team in your organization for example by using official SQL scripts (these script can be provided by support). In the first creation script, you have to replace some names by yours, but it is important to have the name of the tablespace equal to the name of the user (or schema), like below:

CREATE TABLESPACE "sas52" LOGGING DATAFILE 'E:\OracleDataFiles\sas52.DBF' SIZE 200M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
ALTER DATABASE DATAFILE 'E:\OracleDataFiles\sas52.DBF' AUTOEXTEND ON;
CREATE USER sas52 IDENTIFIED BY sas52password DEFAULT TABLESPACE "sas52";
GRANT ALL PRIVILEGES TO sas52; ALTER SESSION SET CURRENT_SCHEMA = sas52;

The name here is "sas52" for example and must be used for the naming of the tablespace and the usern

To top

No comments
Add comment

* - required field

*




CAPTCHA image for SPAM prevention If you can't read the word, click here.

*
*

Latest updated pages