Errors/Workarounds11g
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.
How to rename a Datafile with Extension .dbf?
For example we have added a datafile but we forgot to give the extension .dbf
Step 1. Shut down the Database
SQL> shutdown immediate;
Step 2. Startup the Database in Mount State
SQL> startup mount
Step 3. Now copy the datafile by renaming it with .dbf extension
$cp /u01/app/oracle/user2 /u01/app/oracle/user2.dbf
Step 4. Now rename database file at Database Level
SQL> alter database rename file ‘/u01/app/oracle/user2’ to ‘/u01/app/oracle/user2.dbf’;
Step 5. Now Open the Database
SQL> alter database open;