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 »ORACLE
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 »How To Create Oracle Profiles
We will create oracle profile and explain with all details. What are Oracle SQL Profiles? Oracle Profiles allow us to manage users according to certain …
Read More »How To Change User Profile in Oracle
We will change user profile in Oracle in this article. Its very easy and simple step. Profiles allow us to manage users according to certain …
Read More »How To Detect and Repair Block Corruption in Oracle
In this article, we will see how to fix block corruption when there is a block corruption on a data file. If Block Corruption is …
Read More »How To Change The Password Of The Oracle User
You may want to change an Oracle user’s password for a number of reasons. Sometimes this process may be needed for the user to forget …
Read More »