Change hostname in OCI
Blog for DBA, RAC, EBS DBA
by admin
1M ago
https://medium.com/@priyashanmadusanka99/how-to-change-hostname-in-oci-compute-instance-on-oracle-linux-permanently-9fd01a09eadd ..read more
Visit website
RTO RPO
Blog for DBA, RAC, EBS DBA
by admin
3M ago
RTO and RPO in Disaster Recovery Planning The terms RTO and RPO are often thrown about in the tech world. But, like many acronyms, they are often misunderstood. RTO (Recovery Time Objective) and RPO (Recovery Point Objective) are key factors in determining database backup and disaster recovery scenarios. People think of them as technical terms, and there is nothing wrong with that. However, it is important to think of them in a business sense as well. Let’s talk about each of these terms and discuss what they mean in a technical as well as a business sense.   RTO: Recovery Time Objective ..read more
Visit website
Oracle RAC 19c in OEL8
Blog for DBA, RAC, EBS DBA
by admin
5M ago
https://infohub.delltechnologies.com/l/design-guide-oracle-rac-database-on-powerstore-t-storage/deploying-oracle-19c-rac-with-red-hat-enterprise-linux-8-2-on-vsphere-7 ..read more
Visit website
VDI File & How to Open VDI File
Blog for DBA, RAC, EBS DBA
by admin
5M ago
Manual Way to Open VDI File in VirtualBox Copy the VDI file into VirtualBox’s virtual hard disk repository Launch VirtualBox and create a new virtual machine. Choose an operating system among the choices given and click on the Next button Under Virtual Hard Disk, select Use existing hard disk and then click on the folder icon on the right Now, a Virtual Media Manager window is opened. In that, click on the Add button and then select the VDI file which you want to open Again, a Virtual Hard Disk window is opened in which your new ..read more
Visit website
Provision EBS with Reverse Proxy, DNS URL in Oracle Cloud
Blog for DBA, RAC, EBS DBA
by admin
6M ago
https://medium.com/@Maheshwar888/provision-ebs-with-reverse-proxy-with-dns-url-in-oracle-cloud-45a163281d44 ..read more
Visit website
DNS Configuration
Blog for DBA, RAC, EBS DBA
by admin
6M ago
https://www.youtube.com/watch?v=ddRMrfxM3Eg cat > /etc/named.conf // // named.conf // // Provided by Red Hat bind package to configure the ISC BIND named(8) DNS // server as a caching only nameserver (as a localhost DNS resolver only). // // See /usr/share/doc/bind*/sample/ for example named configuration files. // // See the BIND Administrator’s Reference Manual (ARM) for details about the // configuration located in /usr/share/doc/bind-{version}/Bv9ARM.html options { listen-on port 53 { 127.0.0.1; 192.168.1.7;}; listen-on-v6 port 53 { ::1; }; directory “/var/named”; dump-file “/var/named ..read more
Visit website
Configure Active Directory
Blog for DBA, RAC, EBS DBA
by admin
6M ago
https://docs.rackspace.com/docs/configure-active-directory-with-integrated-dns ..read more
Visit website
Virtual box installation on OEL7
Blog for DBA, RAC, EBS DBA
by admin
7M ago
https://phoenixnap.com/kb/how-to-install-virtualbox-centos-7 sudo wget http://download.virtualbox.org/virtualbox/rpm/el/virtualbox.repo -P /etc/yum.repos.d sudo yum install VirtualBox-6.0 sudo systemctl status vboxdrv yum install SDL-1.2.15-17.el7.x86_64 cd /var/cache/yum/x86_64/7Server/virtualbox/packages rpm -Uvh VirtualBox-6.0-6.0.24_139119_el7-1.x86_64.rpm ..read more
Visit website
Query – User sessions
Blog for DBA, RAC, EBS DBA
by admin
8M ago
select distinct s.inst_id, s.status, s.username, s.sid, s.serial#, s.schemaname, s.osuser, f.user_name, p.spid, f.request_id, s.process, s.module, s.action, s.machine, s.program, u.value || ‘/’ || lower(n.value) || ‘ora‘ || p.spid || ‘.trc’ Trace_File, t.sql_text from gv$session s, gv$process p, gv$sql t, (select u.user_name, r.* from apps.fnd_concurrent_requests r, apps.fnd_user u where r.requested_by = u.user_id and phase_code = ‘R’) f, (select inst_id, value from gv$parameter where name = ‘user_dump_dest’) u, (select inst_id, value from gv$parameter where name = ‘instance_name’) n where s.p ..read more
Visit website
Troubleshooting SSO logfiles
Blog for DBA, RAC, EBS DBA
by admin
8M ago
/d01/oracle/fs2/FMW_Home/webtier/instances/EBS_web_OHS1/diagnostics/logs/OHS/EBS_web tail -f EBS_web.log access_log vi /d01/oracle/fs2/FMW_Home/webtier/instances/EBS_web_OHS1/config/OHS/EBS_web/mod_wl_ohs.conf /d01/oracle/fs2/FMW_Home/user_projects/domains/EBS_domain/servers/oaea_server1/logs cd $EBS_DOMAIN_HOME/servers/oaea_server1/logs oaea_server1.out oaea_server1.log R12 E-Business Suite AccessGate User Login Fails After SSO Setup With Error ‘SsoUser updateUserGuid SEVERE exception’ And java.sql.SQLException: ORA-31203: DBMS_LDAP: PL/SQL – Init Failed. ORA-06512: at “APPS.FND_OID_UTIL” (Do ..read more
Visit website

Follow Blog for DBA, RAC, EBS DBA on FeedSpot

Continue with Google
Continue with Apple
OR