|
This section covers the procedure to create and configure databases in Oracle. See the steps below:
This procedure assumes that Oracle is installed, with created instances, and that TNSNames is duly configured on the server where SoftExpert Suite will be installed.
|
This procedure requires the Oracle Provider and OJDBC components to be installed on the server where SoftExpert Suite will be installed.
|
1.Start SQLPlus.
2.Connect to the server using a DBA user.
Creating the tablespaces
3.Create a tablespace called SOFTEXPERT_DATA:
CREATE TABLESPACE SOFTEXPERT_DATA LOGGING DATAFILE '<tablespaces_directory>\SOFTEXPERT_DATA.DBF' SIZE 2000M AUTOEXTEND ON NEXT 200M MAXSIZE UNLIMITED;
|
Substitute the <tablespaces_directory> for the path where the tablespace must be created on the Oracle server.
|
2000M is the initial size recommended for the data tablespace.
|
4.Create a tablespace called SOFTEXPERT_INDEXES:
CREATE TABLESPACE SOFTEXPERT_INDEXES LOGGING DATAFILE '<tablespaces_directory>\SOFTEXPERT_INDEXES.DBF' SIZE 200M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;
|
Substitute the <tablespaces_directory> for the path where the tablespace must be created on the Oracle server.
|
200M is the initial size recommended for the indexes tablespace.
|
Creating a user for SoftExpert Suite
5.To create a user for SoftExpert Suite and define the necessary permissions, execute the following steps:
6.Create a user for SoftExpert Suite:
CREATE USER <SESUITE> PROFILE DEFAULT IDENTIFIED BY <PASSWORD> DEFAULT TABLESPACE SOFTEXPERT_DATA ACCOUNT UNLOCK;
|
Substitute <SESUITE> and <PASSWORD> for the user's name and password respectively.
|
7.Define the necessary Grants for the user created in step 5:
ALTER USER <user> QUOTA UNLIMITED ON SOFTEXPERT_DATA;
ALTER USER <user> QUOTA UNLIMITED ON SOFTEXPERT_INDEXES;
GRANT CREATE SESSION TO <user>;
GRANT CREATE TABLE TO <user>;
GRANT CREATE VIEW TO <user>;
GRANT CREATE SEQUENCE TO <user>;
GRANT CREATE PROCEDURE TO <user>;
GRANT CREATE TRIGGER TO <user>;
GRANT SELECT_CATALOG_ROLE TO <user>;
|
8.Exit the SQLPlus.
9.Click on the Windows Start menu.
10. Right-click on My Computer and select Properties.
11. Select the Advanced tab and click on Environment.
12. In System Variables, click on New.
13. Fill in the Variable Name field with NLS_LANG.
14. Open SQLPlus.
15.Type in the following commands to return the NLS parameters: ▪VALUE1:
SELECT VALUE FROM NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_LANGUAGE';
|
▪VALUE2:
SELECT VALUE FROM NLS_SESSION_PARAMETERS WHERE PARAMETER = 'NLS_TERRITORY';
|
▪VALUE3:
SELECT VALUE FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';
|
16. Fill out the Variable Value field with the information returned by the SQLPlus in the order of the previous step: VALUE1_VALUE2.VALUE3 Example: AMERICAN_AMERICA.WE8MSWIN1252
17. Click on OK.
18. Click on OK to close the System properties screen.
19. Exit SQLPlus.
|
