Showing posts with label Troubleshooting. Show all posts
Showing posts with label Troubleshooting. Show all posts

Thursday, 30 March 2017

ORA-00845: MEMORY_TARGET not supported on this system

Hi Friends,

Sometimes when we all try to connect 11g (newly installed software) and then trying to STARTUP the database, we faced below error message as shown below:

Friday, 3 March 2017

Install/Clone 32-bit 11GR2 Client On Linux x86_64 Fails With Error In Invoking Target 'Mkldflags ntcontab.o nnfgt.o' Of Makefile ins_net_client.mk (Doc ID 1473421.1)


In this Document


APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later
Linux x86-64
***Checked for relevance on 16-Dec-2013*** 
SYMPTOMS
Install/Clone 32-bit 11g R2 client on Linux RHEL 5 (64-bit) server fails with relinking errors.

INFO: (if [ "compile" = "compile" ] ; then \
/bb/bin/oracle/product/client/11.2.0.3/bin/gennttab > ntcontab.c ;\
/usr/bin/gcc -m32 -m32 -fPIC -c ntcontab.c ;\
rm -f /bb/bin/oracle/product/client/11.2.0.3/lib/ntcontab.o ;\
mv ntcontab.o /bb/bin/oracle/product/client/11.2.0.3/lib/ ;\
  /usr/bin/ar rv /bb/bin/oracle/product/client/11.2.0.3/lib/libn11.a /bb/bin/oracle/product/client/11.2.0.3/lib/ntcontab.o ; fi)

Error in invoking 'ntcontab.o' of makefile while installing 11gr2 client on Linux x86-64 bit server (Doc ID 1313504.1)

In this Document

APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Generic UNIX
***Checked for relevance on 16-Dec-2013***
SYMPTOMS
While installing 11gr2 (11.2.0.x) 64 bit client on a Linux x86-64 bit server the following errors occur during the relink phase of installation:

Wednesday, 1 March 2017

Oracle 12c Installation on RHEL 6.5 with VMWARE Java 132 error

AND FINALLY THE INFAMOUS JAVA:132 ERROR MESSAGE
 

$ ./runInstaller
Starting Oracle Universal Installer…
Checking installer requirements…
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
Passed
All installer requirements met.

Sunday, 21 February 2016

Data Guard Standby Archive Destination Full

You notice the following error in the alert.log of the Data Guard Standby database. Your Standby is configured to write its archive logs to the Fast Recovery Area.

ORA-12543: TNS:destination host unreachable

Connectivity errors are common questions on Oracle related forums and in many cases they are highly misunderstood by the poster of the questions and some responders.
This aim of this document is to show a method for diagnosis and resolution to a scenario in which an ORA-12543 is raised during the connection to a database.

ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

Connectivity errors are common questions on Oracle related forums and in many cases they are highly misunderstood by the poster of the questions and some responders. Many times the source of confusion lies in the similarity of this error number to ORA-12154.

ORA-16136: Managed Standby Recovery not active

Problem:
There is some problem in Oracle Dataguard. I want to switch the standby database to readonly mode. Firstly I cancel the standby managed recovery but it gave me this error:
SQL> alter database recover managed standby database cancel;
ORA-16136: Managed Standby Recovery not active

Saturday, 20 February 2016

Top 11gR2 RAC Installation Issues

Issue #1: Cluster Manager Integrity PRKC-1137 or PRVF-5434 when installing database software

Symptoms:

PRKC-1137 : Unable to find Version object with string value 11.2.0.2.0OR

PRVF-5434 : Cannot identify the current CRS software version

 Possible Causes:

Error 1031 received logging on to the standby

ISSUE

Error 1031 received logging on to the standby
ORA-01031: insufficient privileges
PING[ARC0]: Heartbeat failed to connect to standby 'dgp'. Error is 1031.

Data Guard Log Shipping Fails With Error Ora-16191 In 11g

Issue:

PING[ARC1]: Heartbeat failed to connect to standby ‘STANDBY’. Error is 16191.
Sat Aug 06 02:06:52 2011
Error 1017 received logging on to the standby
------------------------------------------------------------

Thursday, 18 February 2016

ORA -600 - What to do ?

ORA-600 is an internal error generated by the generic kernel code of the Oracle RDBMS software.

Step 1     
Check alert log for path to trace file.

ORA-12532: TNS:invalid argument

Solution : 1

This is the problem that caused the TNS-12532 error.  The SQL*Plus connect worked flawlessly and then started to throw the TNS-12532 error:
sqlplus user/password@devdb

SQL*Plus: Release 11.1.0.6.0 - Production on Wed May 19 15:32:40 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

ERROR:
ORA-12532: TNS:invalid argument
The resolution involved a system administration change.  The docs note this on the ORA-12532 error: