Home / Errors/Workarounds10g / How To Find Oracle Database 32 bit or 64 bit

How To Find Oracle Database 32 bit or 64 bit

How To Find Oracle Database 32 bit or 64 bit

Finding Oracle Database Version on your system through Operating System

$ cd $ORACLE_HOME

$ cd bin

$ file oracle

oracle:         ELF-64 executable object file – IA64

 

Finding Oracle Database Version on your system through SQL Prompt

SQL> select metadata from sys.kopm$ ;

METADATA

——————————————————————————–

0000006001240F050B0C030C0C0504050D0609070805050505050F05050505050A05050505050405

0607080823472347081123081141B0470083000107D0130000000000000000000000000000000000

0000000000000000000000000000000000000000

Here As you can See the Output Contains B4047 which means Database is 64-Bit Version.

If the Output contains B4023 then the Database is 32-Bit Version.

 

 

........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old

ERROR ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old More from my siteHow To …

Leave a Reply