Adminer – Database management in a single PHP file

A phpmysql alternative that is actually only 1 php file and can also be used with oracle and mongodb

Adminer – Database management in a single PHP file.

Create user and Grant access in Oracle

Create a new user in oracle:

Grant in oracle:

Drop an user in Oracle

Exporting in ubuntu

Situation: I am going to export the ORACLE_SID

Solution: in terminal type export ORACLE_SID=’XE’
you can see the result if you type echo $ORACLE_SID

QnA: where LSNRCTL command can be found?

The question is, where LSNRCTL command can be found?

Answer is, it is under bin folder of your oracle directory. If you have installed oracle in ubuntu successfully, then it can be found under $ORACLE_HOME/bin.

A small point to remember, always store the information about how you installed oracle in your ubuntu mechine.

Start up Oracle XE in Ubuntu

Here i got a nice article about starting oracle xe in ubuntu. here is the link:
Well, here is the main point:
There one problem in starting up oracle 10g in Ubuntu after you restart the computer, which is it wouldn’t start(if you didn’t enable the “Start Oracle on logon” option) unless you login as Oracle user account. One way I found out to start the listener and database, without login as Oracle, is to run the restart command.

sudo /etc/init.d/oracle-xe restart

I don’t know whether this is a security bug because firing the command start and stop doesn’t work using your own login.

Check the database status using the following code:

sudo /etc/init.d/oracle-xe status

Sometimes, the database won’t start after firing the restart command even the listener is active. Start the database using the menu path and check the status again.

Oracle 10g reference site

The following site from Stanford has a full reference about oracle. Also it hosts some nice document about oracle 10g.

If you are a oracle DBA, I hope you have already seen this, if not, please see this site. | Bangladesh’s first bilingual 24/7 news provider in any medium opened its content to public free of charge on 23 Oct 2006

সম্প্রতি জানা গেছে, কপিরাইট ভঙ্গের অভিযোগে গুগলকে দোষী সাব্যস্ত করেছে যুক্তরাষ্ট্রের এক আদালত। জানা গেছে, ওরাকলের প্রোগ্রামিং ল্যাঙ্গুয়েজ জাভার কপিরাইট আইন ভঙ্গ করেছে তারা। খবর বিবিসির।

সূত্র জানিয়েছে, ১০০ কোটি ডলার ক্ষতিপূরণের দাবি করেছে ওরাকল, যা প্রযুক্তির ইতিহাসে সবচেয়ে বড় অঙ্কের মামলা বলে মন্তব্য করেছে বিবিসি।

via | Bangladesh’s first bilingual 24/7 news provider in any medium opened its content to public free of charge on 23 Oct 2006.