Oracle
Oracle is a DBMS designed to be incorporated into corporate distributed data processing networks (Enterprise Grid). It allows you to reduce IT expenses thanks to automated management, the use of inexpensive modular components and clustered servers, with the aim of using resources as efficiently as possible. The Oracle architecture is designed to work with large volumes of data and huge teams of users; it demonstrates unrivalled capabilities to provide high reliability, efficiency, scalability, security and self-management. This DBMS can be implemented effectively on any platform, from small blade servers to large symmetrical multiprocessor servers and multisite clusters of any size.
Oracle The Oracle DBMS is supplied in four different versions, designed for different working scenarios and deployment of applications (and also differing in price).
| Edition | Rastriction | OS |
| Enterprise Edition | - | - |
| Standard Edition | cannot be installed on systems with more than four processor sockets | - |
| Standard Edition One | cannot be installed on systems with more than two processor sockets | - |
| Personal Edition | one user | - |
| Lite | for mobile and built-in devices | - |
| Express Edition | free version; physical working memory —1 Gb, maximum volume of user data — 4 Gb | Windows 32-bit, Linux x86 |
Configuring Oracle
Installation and configuration of the Oracle server should be carried out by the administrator themselves.
All described operations were carried out in Oracle Database 10g Express Edition.
Oracle Database 10g Express Edition can be downloaded from the official Oracle site: http://www.oracle.com/technology/software/products/database/xe/index.html
During installation, you must enter the system administrator password (the user with login system).
Immediately after installation, the program will launch the database homepage.
On the authorization page, you must enter login system and the password chosen during installation, as shown in Figure 1.
Figure 1.On the page that is open, select Administration.
Figure 2.On the page that is open, select Database Users.
Figure 3.On the Database Users page, shown in Figure 4, a list of all existing users is displayed.
To find a user by name, simply enter the name in the Search Username field and click Go.
You can adjust the view of the user list by using the View, Show and Display settings.
View – users displayed in icon or list view
Show – show all users, only database users, only external users
Display – maximum number of users displayed in the list
To create a new user, click Create>.
Figure 4.On the create new user page that opens, you must complete all fields, as specified in Figure 5. You will need to enter a name for the new user, a password, and confirm the password.
Besides this, you will need to assign the user all the required privileges. To assign the user the required privileges, simply click Check All in the select privileges section.
If the Expire Password option is set up, this user’s password will have a time limit. Once the time limit has expired, the user will need to change their password.
The Account Status option allows you to set the status of an account (blocked/unblocked). By using this option, you can temporarily disable unused accounts.
Once you have entered all the required information, click Create to begin the user creation procedure.
Figure 5.On completion of the user creation procedure, the page shown in Figure 6 will open. If everything has been done correctly, and the user was created successfully, their name will appear in the list.
Figure 6.On the computer with Data Center, you will need to set up Oracle Database Instant Client.
Oracle Database Instant Client can be downloaded here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
To provide access to the database, simply download the Instant Client Package - Basic Lite package.
Once it has downloaded, unzip the contents of the package to any folder, for example C:\Oracle\InstantClient.
Next, copy the file tnsnames.ora from the: c:\oraclexe\app\oracle\product\10.2.0\server\NETWORK\ADMIN\ folder of the computer where the Oracle database server is installed to the C:\Oracle\InstantClient folder of the client’s computer.
Data Center Configuration
Once the new database is created, Data Center should be set up in order to work with it. For this, you must open the program’s management console, go to the Configuration page shown in Figure 7, and select Data Storage Settings.
Figure 7.In the window that opens, you will need to select a database type (in our case, Oracle).
Figure 8.On the second tab, you must specify the parameters for connecting to the database (Figure 9),
where,
192.168.0.166 - IP address of Oracle server
User name - name of user with privileges to connect to the database (all necessary privileges assigned to user Activity earlier)
Password - password for user Activity
C:\Oracle\InstantClient\ - Oracle Instant Client install directory
Figure 9.Once you have pressed Test Connection the program will attempt to connect to the database, and if the connection settings have been specified correctly, the message shown in Figure 10.
Figure 10.Next, click OK.
A message will appear notifying you that Data Center must be restarted for the new parameters to be applied (Figure 11).
Figure 11.Click Yes, and Data Center will restart automatically. Once Data Center is restarted, all changes will take effect and the program will begin using the new database to store information.
To test the efficiency of the new database, simply print any document so that it prints to the database (on a virtual printer, or from a computer with an agent working in Client Side Monitoring mode installed). If the actions described above have been carried out correctly, the program will allow you to format a report displaying information about the printed text document.
The status of the database can be viewed on the Statistics tab of the data storage management dialog (Figure 12).
Figure 12.Conclusion:
Oracle is the largest professional DBMS with a multitude of options and settings. This DBMS is designed to be incorporated into corporate distributed data processing networks.
The Oracle architecture is designed to work with large volumes of data. Due to its complex setup and high price, this DBMS is not recommended for use on smaller networks.
