Profile cover photo
Profile photo
Shony Thomas
94 followers -
Oracle Admin Professional
Oracle Admin Professional

94 followers
About
Posts

Post has attachment
WARNING: Your password has expired. Password change required but no TTY available.
Problem Description Scp command
fails with following error message scp /tmp/11204.tar oracle@prod:/tmp oracle@prod's password: WARNING: Your password
has expired. Password change required
but no TTY available. lost connection $ Solution Description Even tho...
Add a comment...

Post has attachment
How to Enable or Disable the Supplemental Logging in Oracle Database
Steps to
Enable the supplemental logging SQL>
set timing on time on 08:42:21
SQL> select    SUPPLEMENTAL_LOG_DATA_MIN,    SUPPLEMENTAL_LOG_DATA_PK,    SUPPLEMENTAL_LOG_DATA_UI from    v$database; SUPPLEME
SUP SUP -------- --- --- NO       NO 
NO 08:42:33
SQ...
Add a comment...

Post has attachment
Startup command fails with ORA-27102: out of memory, Linux-x86_64 Error: 28: No space left on device
Error Description Oracle
startup command fails with following error. SQL>
startup ORA-32004: obsolete or deprecated
parameter(s) specified for RDBMS instance ORA-27102: out of memory Linux-x86_64 Error: 28: No space left
on device Additional
information: -1...
Add a comment...

Post has attachment
Oracle relink all command failed with ld: 0706-006 Cannot find or open library file: -l java
Error Description Oracle
binaries copied / cloned from different server with different ORACLE_HOME path.
Then relink
all command fails with following error.   ld: 0706-006 Cannot find or open
library file: -l java      ld:open(): A file or directory in the ...
Add a comment...

Post has attachment
Expdp failed with ORA-39047 ORA-39047: Jobs of type TRANSPORTABLE cannot use multiple execution streams
Error Description: Data Pump
export (expdp) with transport_tablespace failed with following error. date;expdp
dumpfile=TTS.dmp%u logfile=TTS.log directory=TTS transport_tablespaces =USERS PARALLEL 16;date Fri Jul
21 05:00:39 CUT 2017 Export:
Release 11.2.0....
Add a comment...

Post has attachment
How to Copy and Multiplex Oracle OCR into Different Disk Group
[root@]#
ocrcheck Status of
Oracle Cluster Registry is as follows :          Version                  :          4          Total space (kbytes)     :    
409568          Used space (kbytes)      :      
1712          Available space (kbytes) :     407856  ...
Add a comment...

Post has attachment
Check/Find Location and Status of Oracle OCR and VOTEDISK
What is OCR and Voting disk: The voting disk is a file that manages information about node
membership, and the OCR is a file that manages cluster and Oracle
RAC database configuration information. The Oracle Clusterware
installation process creates the voti...
Add a comment...

Post has attachment
PROC-50 PROT-30: The Oracle Cluster Registry location to be added is not usable
Error Description Oracleasm
listdisks shows the disk but Ocrconfig -add command failed with following error
message. [root@]#
ocrconfig -add +DATA PROT-30:
The Oracle Cluster Registry location to be added is not usable PROC-50:
The Oracle Cluster Registry l...
Add a comment...

Post has attachment
Settings to Run SQLPLUS from Other or Non-Oracle User
Add a new
unix user as readuser [root@Test]#
useradd readuser [root@Test]#
passwd readuser Changing
password for user readuser. New
password: Retype
new password: passwd:
all authentication tokens updated successfully. [root@Test]#
exit Connect to
readuser ...
Add a comment...

Post has attachment
Steps to Remove / Deinstall Oracle OEM, OMS from Unix Server
You have to use OUI with deinstall option to remove the components
installed by the OEM or OMS. See the steps below. Step 1: Go to em12c installation directory and invoke the runInstaller
with deinstall option. $ pwd /u01/installs/em12cr5 $ ./runInstaller -...
Add a comment...
Wait while more posts are being loaded