Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
The Oracle password file is a file that is created automatically during installation. Users defined in this file can connect to oracle via sqlplus without …
Read More »
ORACLE
How To Create Tablespace On Oracle
Tablespaces are areas dedicated to storing objects in the database. Tablespaces are logical constructs. However, it contains physical data files or temp files. There are …
Read More »How To Create a User/Schema On Oracle
User and schema creation operations are the same in Oracle. When you create a user, a schema is automatically created for the user. Each …
Read More »How To Add Datafile To Tablespace On Oracle
As the Oracle database grows, the existing data files in the tablespace will fill up. In such a case, you will need to add …
Read More »How To Connect To RMAN
In this article, I will tell you how to connect to RMAN. We are doing ssh with server as root user. You can use …
Read More »How To Create a .profile File To Connect The Oracle
To connect to Oracle with sqplus you need to load the environment. You need to use the .oraenv or .profile file to load the …
Read More »How To Connect To Oracle With sqlplus
In this article, I will tell you how to connect to the oracle database with sqlplus after connecting to server with ssh. We are …
Read More » How To Connect To Oracle With Toad
To connect to Oracle with Toad, you need to download and install Toad. TNS Information You must write the tns information of the database you …
Read More »
How To Find Oracle Database Service Name (SERVICE_NAME parameter on TNS)
We can find oracle service name with two method. TNS information is required to connect to Oracle. In the service_name parameter in the TNS information, …
Read More »
How To Remove Database Target From oem
In this article we will see how to remove a database from oem. You should remove deleted databases from oem. First connect to oem and …
Read More »