NO BACKUP: Ağustos 2013

Oracle 11g Grid Uninstall

By Unknown zaman: 07:45 26 Ağustos 2013 Pazartesi |

You can uninstall oracle grid infrastructure via two way ;

Run the following commands with root user

Rac Node1
cd /oracle/app/11.2.0/grid/crs/install
perl rootcrs.pl -deconfig -force

Rac Node2
cd /oracle/app/11.2.0/grid/crs/install
perl rootcrs.pl -deconfig -force -lastnode

Or (again need root user ) ;

Continue » | 0 yorum

Compressing Export Dump File On The Fly

By Unknown zaman: 05:10 12 Ağustos 2013 Pazartesi |

If you don't have enough storage to keep export dump file on server , you can compress your dump file when export is running.

mkfifo pipe.dmp
gzip < pipe.dmp > expdat.dmp.z &
exp user/passwd full=y file=pipe.dmp

0 yorum

Redolog File Block Corruption Database Recovery Without Any Backup

By Unknown zaman: 01:18

First Error with oracle database -

UDE-01034: operation generated ORACLE error 1034
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Solaris-AMD64 Error: 2: No such file or directory
UDE-00003: all allowable logon attempts failed

Related memory error in alert.log file
-------------------------------------

Starting ORACLE instance (normal)
WARNING: The system does not seem to be configured
optimally. Creating a segment of size 0x000000004c000000
failed. Please change the shm parameters so that
a segment can be created for this size. While this is
not a fatal issue, creating one segment may improve
performance

We check the memory because of kernel parameters not configured properly.

oracle@xxxx:/data/oracle:>prtconf | grep Mem
Memory size: 4096 Megabytes

oracle@xxxx:/data/oracle:>id -p
uid=610(oracle) gid=610(dba) projid=100(user.oracle)

Continue » | 0 yorum

Determine Endian Format When Migration Oracle Database Across OS Platform

By Unknown zaman: 00:57 1 Ağustos 2013 Perşembe |

When migrating Oracle Database to different platform , first of all you should check your endian format for both platforms (old and new ). You can determine via sqlplus with below command.

SQL> COLUMN PLATFORM_NAME FORMAT A32
SQL> SELECT * FROM V$TRANSPORTABLE_PLATFORM;

PLATFORM_ID PLATFORM_NAME ENDIAN_FORMAT
----------- -------------------------------- --------------
1 Solaris[tm] OE (32-bit) Big
2 Solaris[tm] OE (64-bit) Big
7 Microsoft Windows IA (32-bit) Little
10 Linux IA (32-bit) Little
6 AIX-Based Systems (64-bit) Big
3 HP-UX (64-bit) Big
5 HP Tru64 UNIX Little
4 HP-UX IA (64-bit) Big
11 Linux IA (64-bit) Little
15 HP Open VMS Little
8 Microsoft Windows IA (64-bit) Little
9 IBM zSeries Based Linux Big
13 Linux 64-bit for AMD Little
16 Apple Mac OS Big
12 Microsoft Windows 64-bit for AMD Little
17 Solaris Operating System (x86) Little

If you are not sure ;
You can use this command on unix shell

echo I | tr -d [:space:] | od -to2 | head -n1 | awk '{print $2}' | cut -c6

IF return 0 -> Big Endian
IF return 1 -> Little Endian

After determination endian format , you can choose your methodology for migration operation.Check Oracle Support Note:Migration Of An Oracle Database Across OS Platforms (Generic Platform) (Doc ID 733205.1)

0 yorum