ORACLEENTERPRISE

Enterprise data management, application and data integration.

Category: resources

resources

How to Install Oracle Instant Client and Connect with SQL*Plus

Oracle Instant Client lets you connect to an Oracle Database without installing the full database software. Add the SQL*Plus package to run SQL statements and scripts from a terminal. This guide covers ZIP installations on Linux and Windows and a first connection using a database service name. Before you begin You need a supported operating…

Read the article: How to Install Oracle Instant Client and Connect with SQL*Plus
general

Oracle DBA Salary in Europe (2025): Country Comparison & Career Outlook

Oracle Database has been a core technology in enterprise IT for decades. Despite the growth of open-source and cloud-native databases, Oracle DBAs are still widely employed across Europe, especially in large organizations, regulated industries, and legacy-critical environments. In this article you’ll find a realistic and conservative analysis of Oracle DBA salaries in Europe in 2025,…

Read the article: Oracle DBA Salary in Europe (2025): Country Comparison & Career Outlook
general

Top 10 PeopleSoft Enterprise Modules and what they do

PeopleSoft Enterprise is a comprehensive enterprise resource planning (ERP) software that includes a wide range of modules to help businesses manage various business processes. Here are the top 10 PeopleSoft Enterprise modules, along with a brief description of what they do: There are many other modules. The specific modules that an organization uses will depend…

Read the article: Top 10 PeopleSoft Enterprise Modules and what they do
general

How do I connect to an Oracle database using SQL*Plus?

To connect to an Oracle database using SQL*Plus, you will need to have the following information: Once you have this information, you can connect to the Oracle database using the following steps: sqlplus username/password@//hostname:port/sid Replace "username" with your Oracle username, "password" with your Oracle password, "hostname" with the hostname or IP address of the server…

Read the article: How do I connect to an Oracle database using SQL*Plus?
general

How to create a Database in Oracle

To create a database in Oracle, you will need to do the following: CREATE DATABASE my_database USER SYS IDENTIFIED BY password USER SYSTEM IDENTIFIED BYpassword LOGFILE GROUP 1 ('/path/to/logfile1.ora') SIZE 50M, GROUP 2('/path/to/logfile2.ora') SIZE 50M DEFAULT TABLESPACE my_tablespace DATAFILE '/path/to/datafile.ora' SIZE 200M CHARACTER SET AL32UTF8 NATIONAL CHARACTER SET AL16UTF16 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; This command creates a database named my_database with a default tablespace my_tablespace and a datafile located at /path/to/datafile.ora. It also sets the character set and national character set for…

Read the article: How to create a Database in Oracle
general

Oracle 12c Client Download

The oracle 12c had its first release in July 2013. The ‘c’ here stands for the cloud. This is the first database offered to buy Oracle with cloud computing. It has a multitenant architecture that actually simplifies consolidation without doing any changes in the application. Other than this it has an In-Memory column store, SQL…

Read the article: Oracle 12c Client Download