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.

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleDBconfig

Upgrade Time Zone File And Timestamp With Time Zone Data

Upgrade Time Zone File And Timestamp With Time Zone Data   Upgrading the time zone …

Leave a Reply