Thursday, September 22, 2011

In 32-bit Linux operating system, Memory utilization limit for oracle database

In 32 bit Linux operating system, the default maximum size of the SGA is 1.7GB. For this SHMMAX value needed lager of 1.7GB .
On a 32-bit Linux operating system, without Physical Address Extension (PAE), the physical memory is divided into a 3GB user space and a 1GB kernel space. It is therefore possible to create a 2.7GB SGA, but you will need make several changes at the Linux operating system level by changing the mapped base. In the case of a 2.7GB SGA, you would want to set the SHMMAX parameter to 3GB.

Maximum value of the SHMMAX parameter is 4GB In 32-bit Linux operating system .

Wednesday, September 21, 2011

ORA-03115:unsupported network datatype or representation in toad 9.6

Cause: A user bind or define, or an Oracle function, is not supported by this heterogeneous Net8 connection.

Action: Upgrade the older version of Oracle and try again.


Problem:-
i am connecting remote oracle database 10g using oracle developer 6i home as a "installed clients" conncetion location in Toad.
its give me this above error, when i am trying to execute AWR report via toad.


Solution:
after then I change the conncetion location home to "oraDB10g_home" in replace of developer 6i home.
then above error is gone.

so this problem is happen for lower version of installed clients net8 connection home.