Readmeout Oracle DBA Blog Specifically Focusing on database administration, RMAN Backup and recovery, restore, cloning, performance tuning and sharing best practices.
Introduction:- In this article, we will learn how to configuring hugepages on linux. Create a file called “hugepages_setting.sh” to Configuring HugePages with the mentatory contents. HugePages:- The operating system keeps each 4 KB of memory as a page. When it allocates pages to the database System Global Area (SGA), the operating system kernel must continually … Read more
In this article, we will know how to enable personalization page link in OAF pages. We will set the some profile in frontend to enable. To Enable Personalization Page link in OAF Pages. We need to be set the below profile for on site or user level. In order to set these profile option Navigate … Read more
In this article, we will know how to find PID by SID in oracle. To know about PID, we need to exucute the sql query to identify. On daily basis we are checking the os pid from sid to check the performance issue. Some time user session got hung or blocked any objects and that … Read more
In this post we will learn how to find SID from Concurrent Request to identify the slowness issue. What is SID in Oracle Database session:- SID is session identifier. Used to identify uniquely for session, after the session is over, this sid can be used for other session. Sid is analogy of pid in OS. … Read more
In this post we will learn how to fix “internal manager does-not start-status actual 1 target 0′ issue in EBS. Some time Internal Manager not started properly due to this issue it shows actual 1 and target 0. In this scenario we will learn how to fix this issue. First of all we need … Read more
Introduction: – In this article, we will discuss how to fix ‘ ORA 1116 ORA 1110 and ORA-27092 Errors in oracle database’. Enter Password: REP-1401: ‘cf_policyformula’: Fatal PL/SQL error occurred. ORA-01116: error in opening database file 95. In alert log file below error are reported. ERROR:- Check the current status of ulimit. #ulimit -Sa core file size … Read more
In alert log file error ORA-609 TNS-12537 and TNS-12547 or TNS-12170 reported. We are going to resolve this error after change parameter in sqlnet.ora file. TNS-12537: TNS:connection closed ERROR:- Alert log shows below error. Fatal NI connect error 12537, connecting to: (LOCAL=NO) Thu Oct 29 11:14:13 2020 Thu Oct 29 11:14:13 2020 … Read more
Introduction:- We are Taking Oracle Database Rman backup Daily on our Production Instance. In this post we will learn how to configure RMAN backup jobs in Windows Servers. Follow the below given steps to create backup script and batch file to schedule task. 👉How to configure RMAN backup jobs? Here i will cover full steps … Read more
In this article , we will discuss how to setup password less ssh login on RedHat linux, OE linux and solaris. After enable password less ssh login on Linux,solaris or unix server. We can easily switch to another server without enter password. Setup Password less SSH in Linux Server :- SSH is an … Read more
In this article, we will see How to create and use alias command in linux . An alias is a short cut command for long command. We may type short alias name to run a longer command or sql. An alias is a short cut command for long command. We may type short alias … Read more