IBM AIX

How to Resolve ORA-31640: unable to open dump file

by Ed Chen
July 25, 2023July 26, 2023

ORA-31640 Tried to import data into the database from a dump file, but it failed with ORA-31640. Linux [oracle@test ~]$ impdp system/password@orcl full=yes directory=BACKUP2 dumpfile=full.dmp… Read More »

Enable Non-Oracle User Run SQL*Plus

by Ed Chen
June 29, 2023September 6, 2023

Let's see how we enable an user other than the owner of Oracle product to run SQL*Plus. Windows In Windows platform, once oracle database has… Read More »

Which Process Listening to Specific Port

by Ed Chen
March 24, 2023March 25, 2023

To check which process is listening to a specific port on Linux or AIX, we use commonly supported command netstat to know it: Check Port… Read More »

Installation Guide on AIX for All Releases of Oracle Database

by Ed Chen
March 23, 2023April 20, 2023

In this post, we collect installation guides on AIX for all database releases. You may bookmark this page by pressing Ctrl + d. There're 2… Read More »

How to Resolve ORA-27302: failure occurred at: skgpspawn3

by Ed Chen
March 13, 2023March 14, 2023

ORA-27302 skgpspawn3 One of RAC instances crashed in the night and we saw ORA-27300, ORA-27301 and ORA-27302 in the alert log before crashing. 2022-11-21T22:28:01.339829-08:00 Process… Read More »

Where is oraInst.loc Location

by Ed Chen
February 28, 2023June 17, 2023

oraInst.loc oraInst.loc stores Oracle product inventory path and installation group. For different OS, the location of oraInst.loc could vary. Here is the list to show… Read More »

How to Resolve rtld: 0712-001 Symbol CreateIoCompletionPort was referenced

by Ed Chen
January 30, 2023March 13, 2023

After restoring the operating system of an Oracle database server from tape, we saw something wrong. Could not load program sqlplus [oracle@test oracle]$ sqlplus /… Read More »

How to Resolve PRVF-7573 : Sufficient swap size is not available on node

by Ed Chen
January 23, 2023January 17, 2023
2 Comments

PRVF-7573 or PRVF-07573 Saw an error PRVF-7573 when Oracle Universal Installer (OUI) 19c perform a prerequisite check. PRVF-7573 : Sufficient swap size is not available… Read More »

How to Resolve PRVF-7566 : User "oracle" does not belong to group "oper" on node

by Ed Chen
January 20, 2023January 24, 2023

PRVF-7566 or PRVF-07566 Saw an error PRVF-7566 when Oracle Universal Installer (OUI) 19c perform a prerequisite check. PRVF-7566 : User "oracle" does not belong to… Read More »

SSH Remote "Command not found"

by Ed Chen
December 27, 2022January 2, 2023

Remote: command not found Tried to execute a command on a remote server simply by using SSH tunnel, but it failed with "command not found".… Read More »

JavaScript is not enabled. Please enable it and reload the page.