Oracle Database Starting Error - ORA-00845: MEMORY_TARGET not supported on this system [SOLVED]

Guys

I got this error when I start oracle instance.

"ORA-00845: MEMORY_TARGET not supported on this system"

Some of the forum said about of tmpfs size which is mounted on /dev/shm.
Then I saw this post.
So I suspected it isn't enough space of share memory.

I checked with "df" command.

That space is currently amount mounted on /dev/shm. So I think that 5.9G isn't enough.
It's need to set a mount which over 5.9G manually.

Then I changed at /etc/fstab  as below. (changed "default" to "size=6g" )

Then, have restarted the host and checked the size with "df" again.

Then , try to start the instance again.

#sqlplus / as sysdba
SQL>startup

This time nothing error occur. :)

>>

UTEE

 Ref: http://www.oracle-base.com/articles/11g/automatic-memory-management-11gr1.php

Oracle Listener Can't Start Error - Linux Error: 29: Illegal seek [SOLVED]

Hi Guys,

I'm want to share how to solve to Oracle Listener Error "Linux Error: 29: Illegal seek" .

This Error occur when starting listener on linux box.

This Listener must support to the remote connection also.
On the First, I checked on the /etc/hosts file.

If I configured to /etc/hosts file with " 127.0.0.1 localhost localhost.localdomain" (only one-line), I can start oracle listener as well.
But If I put other hostname for remote connection at /etc/hosts like "192.168.1.2 localhost localhost.localdomain" , I can't start listener anymore and got above error.

I tried a few changes on /etc/hosts. But It isn't working.
Then, I read at the oracle wiki about of listener. I decided to change the name at the listener.ora file.

So go to the listener file location .

 

 I changed as putting IP (192.168.1.2) at HOST.

Then, save the file and start the listener.

#lsnrctl start

It's working without any error. :)

>>

UTEE

Ref : http://docs.oracle.com/cd/E11882_01/network.112/e10836/listenercfg.htm

DB2 972 x86_64 installaing on Centos 6.4 x86_64

I'll installing DB2 on Centos 6.4. Before start installation step, must follow below step:

Do update

#yum update

Install "libstdc++.so.6" Note: This 32bit library file is needed.

#yum install libstdc++.so.6

Disable the firewall,

#service iptables stop
#service ip6tables stop

I'm uploaded the DB2 tar.gz file under /mnt. and extract the file.

#cd /mnt
#tar xzvf db2.tar.gz

Now to start to install db2 execute the  "db2setup"

#cd  db2
#./db2setup

Then, it will pop-up the "DB2 Setup Launchpad".

You may be check the installation requirements by clicking on the "Installation Requirement".

To start the installation, click "Install a Product" and click "Install New".

Then, follow the instruction,  click "Next" , choose "Accept" and click "Next" .
At the Installation Type, choose the "Typical" , you can check the features as clicking " View Features"

At Installation action, choose default and click "Next"

Installation directory, leave by the default and click "Next"

 At SA MP section, I'm not need the SA MP, So choose "Do not install SA MP" and click "Next"

At "DAS user", specify the db2 user password, then click "Next"

Then, Instance Setup, choose "Create a DB instance" and click "Next"

At the partitioning options, choose default (Single partition instance) and click "Next" 

At Instance owning section, specify the password for instance owner, then click "Next"

 

And specify the password for fenced user and click "Next"

At Tools catalog, choose default (Do not prepare the tools catalog) and click "Next"

Then, you may be setup the smtp notification at "Notification setup" section, and click "Next"

After that, put the notification contact at "Contact" section and click "Next"

Finally, at the Summary, click "Finish"

Note:
After the installation, you must backup the "Summary" which will show the all of the specified data for db2 server installation. Summary file location is "/root/db2ese.rsp"

 Now server is installing.

Now DB2 server installation is finished.

 >>

UTEE

Ref : http://publib.boulder.ibm.com

Proper way of Startup/Shutdown Oracle Database Instance (Solaris) ..

Guys.. I am not a DBA. I am just a SA. But SA role is related with Database environment also. And I think that every SA should know about basic of Database as like how to Start/Shutdown the database service properly.

Let's say.. you need to shutdown the Oracle Database server machine for your maintainance of hardware or other purpose. If you are going to shutdown the server before shutdown the database , Man .. It will be like that you find the risk by yourself and call phone to DBA .. :)

Ok .. Here is the start and shutdown process of the orcale database which is running on solaris .

Startup
If you are already login to solaris terminal with root , change to orcale user

#su - oracle

Enter the following command to start SQL Command Line

#sqlplus

It will ask to type user name type " / as sysdba"

#Enter user-name: / as sysdba
(note: you can use only one command to login SQL command line "#sqlplus / as sysdba" )

To start the database , type follow command : "STARTUP"

 SQL>STARTUP

And type "exit" for leave the sql command line.

SQL>exit

Then, Start the Oracle listener : (If Orcale Database is for remote clients, you will need this step)

#lsnrctl start
Shutdown
If you are already login to solaris terminal with root , change to orcale user

#su - oracle

Enter the following command to start SQL Command Line

#sqlplus

It will ask to type user name type " / as sysdba"

#Enter user-name: / as sysdba

To shutdown the database , type follow command : "SHUTDOWN IMMEDIATE"

SQL> SHUTDOWN IMMEDIATE

And type "exit" for leave the sql command line.

SQL>exit

Then, Stop the Oracle listener : (If you Orcale Database is for remote clients, you will need this step)

#lsnrctl stop

OK now switch back to root user and process to shutdown the solaris OS

#shutdown -y -g0 -i5

>>

UTEE

Ref :http://docs.oracle.com/cd/B25329_01/doc/admin.102/b25107/startup.htm