tag:blogger.com,1999:blog-18356159574578366952024-03-05T17:21:17.027-06:00DBA University BlogDBA University Bloghttp://www.blogger.com/profile/02732216803583907073noreply@blogger.comBlogger131125tag:blogger.com,1999:blog-1835615957457836695.post-73354880489304322552021-12-12T23:00:00.004-06:002021-12-12T23:03:25.373-06:00adop prepare phase fails with TNS-12542 TNS-12560 TNS-00512 Address already in useDid your adop phase=prepare fail in Oracle E-Business Suite 12.2.x version with the following error messages ? Error listening on: (ADDRESS=(PROTOCOL=TCP)(Host=application-server)(Port=xxyy))TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in useSolutionUnder usual circumstances, DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-54483989625800579682021-12-11T22:50:00.004-06:002021-12-11T22:53:13.868-06:00Oracle EBS online patching abort after adop prepare phaseIf your Oracle E-Business Suite (Oracle EBS) online patching process failed only at the adop phase=prepare phase, then you can abort the online patching process by running the following commands. adop -status (Shows that it failed at the prepare or apply phase) Set the RUN file system echo $FILE_EDITION (Must show run) adop phase=abortadop phase=cleanup cleanup_mode=full The DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-18578862682542755482021-10-24T10:31:00.000-05:002021-10-24T10:31:04.146-05:00How to share VNC Viewer screenLaunch VNC ViewerClick on OptionsChoose Misc.Check the Shared (don't disconnect other viewers) DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-30254948681651698362021-10-22T19:20:00.003-05:002021-10-22T19:46:50.440-05:00How to delete log files in Oracle Applications 12.2.xIt is recommended to delete log files in Oracle Applications (Oracle E-Business Suite) periodically to get some free space in the file system. All the files in the below directories can be deleted as part of the Oracle Applications 12.2.x dual file system. This article assumes your Oracle Applications file system is hosted on Linux.1) Login to the Oracle Applications server.2) Set the DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-52633360567873637902021-10-21T18:47:00.002-05:002021-10-21T18:47:47.142-05:00How to restart Output Post Processor in Oracle ApplicationsIntroductionOutput Post Processor (OPP) concurrent managers in Oracle Applications help convert output of a concurrent program into well formatted output such as an Excel file or a PDF file etc.Occasionally, due to heavy data processing, the OPP concurrent managers may stop working for reasons such as "java.lang.OutOfMemoryError" etc. This requires the OPP concurrent managers to be restarted. DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-57965633658814393922021-10-17T16:11:00.027-05:002021-10-17T20:00:42.142-05:00How to login to AWS Linux servers without EC2 key pairIntroductionIn AWS EC2, we can login to Linux servers using SSH and a key pair (public key/private key pair). The initial login will be to ec2-user and then we can sudo su - root (administrator access).But for production servers that require secure access, this is not a good option to have for DBAs (database administrators). For example, a production server that is S-OX complaint usually requiresDBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-57833345202766734342021-10-08T20:23:00.003-05:002021-10-08T20:23:38.491-05:00Oracle Applications R12 - FND_LOG_MESSAGES and APPS_TS_TX_DATA tablespaceFND: Debug Log Enabled profile option value must be set to "No" at the Site level. If it is set to "Yes" it can result in huge space consumption in the APPS_TS_TX_DATA tablespace and the APPS_TS_TX_IDX tablespace (index tablespace) through the FND_LOG_MESSAGES table.Once the site level profile option value is set to "No", you can truncate this table and reclaim space.1) Login as applsys database DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com1tag:blogger.com,1999:blog-1835615957457836695.post-69307204396089744062021-06-23T17:32:00.015-05:002021-09-19T21:20:41.382-05:00Linux tutorialHello Readers,In this article, you will find some of our favorite Linux tutorials. They are very easy to understand and we recommend these tutorials for our students as well. Linux tutorials (complete) Tutorial 1 http://www.doc.ic.ac.uk/~wjk/UnixIntro/ Tutorial 2 http://www.ee.surrey.ac.uk/Teaching/Unix/ vi Editor tutorial https://engineering.purdue.edu/ECN/Support/KB/Docs/DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-12707162301637987822021-05-02T22:09:00.006-05:002021-09-19T21:18:59.531-05:00Oracle database auditing This diagram shows database administrator (DBA) login session and SQL statement auditing as well as non-DBA login session and SQL statement auditing. So, it covers 4 different database audit settings. This diagram is valid for Oracle 19c, Oracle 12c R2 and Oracle 12c R1 versions.DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-44444229978678759652021-04-18T14:20:00.006-05:002021-04-18T14:21:40.075-05:00Oracle VirtualBox - Failed to open create the internal network - VERR_INTNET_FLT_IF_NOT_FOUNDAre you getting the error "Oracle VM VirtualBox - Failed to open/create the internal network" with VERR_INTNET_FLT_IF_NOT_FOUND for the VirtualBox Host-Only Ethernet Adapter while logging into a virtual machine created in Oracle VirtualBox with Windows 10 operating system ? If so, we already had one solution article in http://blog.dbauniversity.com/2016/02/DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-30182465546751742402021-01-16T16:12:00.010-06:002021-01-16T16:14:27.725-06:00MySQL 8 installation using binary distribution on Oracle Enterprise Linux 7 (OEL 7)Most Oracle Enterprise Linux (OEL) operating systems may already be having an existing MySQL installation. It is important that any existing MySQL server process be terminated before attempting to start the MySQL server process from a new installation.Also, one should update the PATH environment variable to refer to the new installation's bin folder before performing the new MySQL server DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-53257874890287956392021-01-02T10:21:00.022-06:002021-01-03T05:18:38.829-06:00Oracle 19c installation on Oracle Linux 7 in Amazon AWS EC2 instanceThis article provides all the details on how to install Oracle 19c database software on Oracle Enterprise Linux (OEL) 7 in an Amazon AWS EC2 instance. Additionally, the installation option chosen below creates a starter Oracle 19c database as well.Note: For easier identification purposes, all Operating system (OS) commands and Oracle database commands that are to be executed in the Linux server DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-26388862508384295002020-03-27T18:56:00.000-05:002020-03-27T18:56:34.835-05:00Oracle Data Guard - How to rebuild PRIMARY after a Failover
If the primary database is not available for a long duration or suffered a permanent failure, then we have to consider a failover (not switchover) to the standby database to make it as the new primary database. Later, we also have to rebuild the old primary database and make it the new standby database.
Assumptions :
a) The FLASHBACK database feature is turned on.
b) Oracle DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-14623807515601388132020-03-27T18:00:00.000-05:002020-03-27T18:00:16.291-05:00Oracle database 8i to 12c R1 upgrade
This blog post provides the overall approach to upgrade from Oracle 8i (specifically 8.1.7.4) to Oracle 12c R1 (specifically 12.1.0.2)
Is your current version 8.1.7.4 (8i R3) ?
If so, this is the approach. You have to perform two upgrades. The first one is called an intermediate upgrade.
We recommend you to use dbua tool (database upgrade assistant GUI tool) instead of export and DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-10467042005070286602020-02-03T00:05:00.001-06:002020-02-03T00:09:03.739-06:00Best R Tutorial for beginners
If you are new to the R programming language (a beginner), then the best tutorial that we recommend is https://www.tutorialspoint.com/r/index.htm. It is free and very interactive. There are LIVE DEMOs for most examples and you can practice them using your web browser.
DBA University Bloghttp://www.blogger.com/profile/02732216803583907073noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-48308226072388236842020-02-01T09:31:00.001-06:002020-02-02T23:57:42.566-06:00VirtualBox Error in supR3HardenedWinReSpawn VBoxHardening
Problem
One of our students was getting the error VirtualBox Error in supR3HardenedWinReSpawn with log details in VBoxHardening.log while starting a virtual machine.
This issue happens even after uninstalling VirtualBox and reinstalling using a different version. It happens both with version 6.x and 5.x respectively.
Solution
This problem was resolved after uninstalling "DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-29876566284418955402020-01-25T13:54:00.001-06:002020-01-25T21:33:41.169-06:00AWS certification training
Hello all,
DBA University has started Amazon Web Services (AWS) Training courses in 2020. We now have two courses that will help students gain rich practical skills and pass AWS certification exams.
Both the courses are live training courses and can be registered using the below links
1) AWS certified cloud practitioner
https://dbauniversity.com/course/aws-certified-cloud-practitioner
DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-82079329917824046772019-11-10T09:32:00.001-06:002019-11-10T09:32:09.607-06:00How to setup Oracle Data Guard in AWS
This article helps you set up Oracle Data Guard 12c R1 (12.1.0.2) in Amazon Web Services (AWS) with 2 node configuration (primary and standby) along with Oracle Automatic Storage Management (ASM). This article assumes that you have basic knowledge how to work with the Amazon cloud https://aws.amazon.com
1) Setup an account in https://aws.amazon.com (if you don't have one DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-18518327545248741242019-11-02T13:48:00.005-05:002020-02-11T18:40:21.497-06:00Oracle 19c database upgrade
Oracle Corporation released database version 19c in 2019. 19c is considered a long term release from Oracle Corporation and its extended support date is till March 2026.
Oracle Corporation does not recommend you to upgrade to 18c if you are already on one of the Oracle 12c database releases. So, if you are on either Oracle 12c R1 or Oracle 12c R2, then the recommended upgrade is to upgrade DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-67770959772439925372019-06-30T17:16:00.004-05:002019-06-30T17:16:19.893-05:00oraenv unary operator expected
If you are getting the error unary operator expected while setting the environment of an Oracle instance using the oraenv command, then one reason could be that the path of the ORACLE HOME inside the /etc/oratab file must have been a symbolic link. oraenv works with only real paths, not symbolic links. You can still have symbolic links to ORACLE HOME, but the /etc/oratab must only have the realDBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-8495192890479878912018-08-18T14:19:00.001-05:002018-08-18T14:19:20.266-05:00How to remove Data Guard Broker configuration in Oracle 12c R1
Introduction
Though all of the Data Guard management and administration operations can be performed using SQL*Plus, it is recommended to use the separate Data Guard Broker interface (dgmgrl). There may be special circumstances in your organization to just use SQL*Plus alone and not use the dgmgrl utility anymore.
This blog post provides the list of steps to be performed to disable DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-60471172797180475332018-05-31T19:10:00.003-05:002018-05-31T19:14:38.618-05:00aws is not recognized as an internal or external command
If you get the 'aws' is not recognized as an internal or external command error message in Windows Command Prompt (cmd) even after installing the AWS Command Line Interface (CLI) 64-bit using the Windows Installer, then please Log off and Login to your Windows computer again. This simple trick will help solve the problem.
After login to your Windows computer again, open cmd (Windows DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0Chicago, IL, USA41.8781136 -87.62979819999998241.4995241 -88.275245199999986 42.256703099999996 -86.984351199999978tag:blogger.com,1999:blog-1835615957457836695.post-89110987150959483072018-05-31T19:03:00.000-05:002018-06-06T19:57:56.209-05:00Oracle DBA Training and MS SQL Server DBA Training course fee reduced
We have reduced our Oracle DBA Training and MS SQL Server DBA Training course fees by 30%. Now, each of these courses is only $349.
Click here to know how DBA University is different from other training providers such as Udemy, Simplilearn, Intellipaat etc.
DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-77710421047548335352017-08-05T15:09:00.001-05:002017-08-05T15:11:44.293-05:00How to login to SQL Server if all logins with sysadmin role are disabled
Introduction
SQL Server 2016 creates a built-in login called "sa" with sysadmin server role. Additionally, several other built-in logins such as NT Service\MSSQLSERVER and NT Service\SQLSERVERAGENT are also created with the sysadmin fixed server role during the instance creation process (SQL Server installation).
Because it is not recommended to perform database administration with the "saDBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0tag:blogger.com,1999:blog-1835615957457836695.post-62494169911229427782017-07-08T14:35:00.000-05:002017-07-08T14:37:50.146-05:00Oracle 12c R2 upgrade dbua ORA-00837
Introduction
Oracle 12c R2 base release (12.2.0.1) supports direct upgrade from Oracle 11.2.0.3, 12.1.0.1 and 12.1.0.2 respectively.
While we were performing a non-CDB database upgrade from 12.1.0.2 to 12.2.0.1, we were facing the ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET error during the Pre Upgrade step. Our database name is CORPDB and when we checked DBA Universityhttp://www.blogger.com/profile/00304904932321276645noreply@blogger.com0