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

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

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

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

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 voting diskand the OCR on shared storage.

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 location to be added is inaccessible on nodes Node203.

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
 

acehints.com Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google