Apple iPhone Application for Oracle DBA’s -> Init.ora

Apple iPhone Application for Oracle DBA’s
Init.ora

It’s good news to iPhone users, who want to have a quick look at the parameters, handy. Last weekend I downloaded init.ora application from Apple Apps Store and it’s free of cost. It covered almost all the parameters from 7 to 11g and gives a brief description of what the parameter does. It as a search option as well, for a quick search.

It’s handy and easy to browse, application is free.

Filesize is around 0.5MB

Microsoft Windows 7 Upgrade for S$20?

Yes, you have an option to upgrade your Windows Vista if you Purchased your laptop on or after June 26^th 2009, your laptop is eligible for upgrade. I purchased my laptop ACER ASPIRE 4937G on June 28^th 2009 but shipped with Windows Vista Home Premium and was quite disappointed with a way its working and very keen to look for an upgrade which my search ended getting a Windows 7 Home Premium upgrade for Just $$20 dollars.

You can check the upgrade options at Microsoft http://www.microsoft.com/windows/windows-7/

Or visit your Laptop Manufacturer site like the one i tried here at ACER http://www.acer.com/windows7upgrade/ and for eligible models you can look below URL, http://www.acer.com/windows7upgrade/eligible.html

So get your copy now and give a try, its worth.

Adding Partition Table to Streams

Steps for adding a Partitioned table:

1. Stop the capture process(S)
2. Setup logging & supplemental logging for the table (S)
3. Add capture rules on the table (S)
4. Add propagation rules on the table(S)
5. Set Instantiation of table from Source(S)
6. Export, Import of table(Data) from Source(S) to Target (T)
7. Add apply rules to the table(T)
8. Start the capture process(S)

Refer krish-dba.blogspot.com for more details

ORA-00845: MEMORY_TARGET not supported on this system

ORA-00845: MEMORY_TARGET not supported on this system

[oracle@server02 ~]$ export ORACLE_SID=testdb

[oracle@server02 ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Mar 17 05:59:38 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup

ORA-32004: obsolete and/or deprecated parameter(s) specified

ORA-00845: MEMORY_TARGET not supported on this system

*** This Error occurred when I configured MEMORY_TARGET on a Centos 5.2 64BIT Server.

I found one Doc, which states the cause of the error and to solve the Issue.

The main reason for this error is MEMORY_TARGET or MEMORY_MAX_TARGET cannot be greater than the shared memory filesystem (/dev/shm) on the OS.

[root@bisserver02 ~]# df -h

Filesystem Size Used Avail Use% Mounted on

tmpfs 1.9G 0 1.9G 0% /dev/shm

As per the Document I increased the /dev/shm to 7GB.

[root@server02 ~]# mount -t tmpfs shmfs -o size=7g /dev/shm

[root@server02 ~]# df -h

Filesystem Size Used Avail Use% Mounted on

tmpfs 7.0G 0 7.0G 0% /dev/shm

shmfs 7.0G 0 7.0G 0% /dev/shm

[oracle@server02 ~]$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Tue Mar 17 06:14:18 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 2137886720 bytes

Fixed Size 2146112 bytes

Variable Size 1627390144 bytes

Database Buffers 503316480 bytes

Redo Buffers 5033984 bytes

Database mounted.

Database opened.

1) Reference: http://www.cyberciti.biz/tips/what-is-devshm-and-its-practical-usage.html - /dev/shm

2) Metalink - 465048.1