Search This Blog

Monday, January 27, 2014







Thursday, September 19, 2013

Don't know how to install Oracle 11g release 2?Here is the installation process...

Assalamualaikum and hi to all the readers..

First of all, we need to check our system properties before we install the oracle 11g release 2 software. How to check it?Here it is..
  1. You can go to your start windows
  2. Then go to control panel and click it
  3. In control panel, click on system and security
  4. In there, there is 'system' and click it. Here will show your notebook or desktop properties.It is easy isn't it?haha...
Do you know why you have to check your notebook properties? Because you have to know does your notebook is 32-bit or that when you want to install the oracle software, you will not install the wrong version. It brings trouble when you do that..hopefully you check it out first..hoho

 My notebook is Lenovo and I use 64-bit system. Cause of that, i need to install Oracle 11g release 2 with 64-bit. My notebook is using Windows 7. Here is the picture of it~~

Here is the installation process

1. Find the setup for Oracle 11g release 2 in the installation folder.

2. Click on the setup and wait for this command to appear.

3. Next, wait until the command disappear. Then, wait for an Oracle 11g picture to appear.

4. There it goes the pop-up window for Oracle 11g release 2. From here we can start the installation process. There is step 1 until 9. This step is depend on your notebook. In this pop-up window, you have to provide your email address to be informed of security issues, install the product and initiate the manager.

5. This pop-up window state 'Email Address Not Specified', if you have not provided the email address and want to continue.

6. Next step is you have to create a database. Tick on create and configure a database. There are other options also, such as install database software only, and upgrade an existing database.

7. Choose desktop class instead of server class. Desktop class is for installing on a laptop or desktop class system. This option includes a starter database and allows minimal configuration. 

8. For this typical install configuration, you have to make sure the location to create base and software location have enough space. For example, you have to state the location whether you want to install the database in location C:\ or in D:\ . 

9. This time you have to insert the password. 

10. Because last time I didn't change the Oracle base location, there is error before it can be proceed. The pop-up window state that the directory is already in use.

11. I change the Oracle base location into C:\ directory. Then, I can proceed.

12. The next step is perform prerequisite checks. 

13. This is summary. You can click on finish. However, the installation process is not done yet.

14. This install product takes a quite some time to be done.

15. Then at some point, there are pop-up windows for Windows Security Alert that mentioned Windows Firewall has blocked some features in this program. You have to click on allow access to proceed.

16. Another pop-up window of Windows Security Alert come up. You have to click again on allow access.

17. After that, there is a pop-up windows of database configuration assistant. This pop-up windows is for installing the listener for database.

18. Another pop-up windows. This is for confirmation for database configuration assistant. Click OK on the windows.

19. This shows that you have successfully install the Oracle 11g release 2 in your notebook. Close the pop-up windows.

20. For checking if the Oracle can be use or not, you have to go to the starts. Click on all programs and find oracle folder.

21. Click on Database Control-orcl.

22. Google chrome will open the localhost. Click on 'Proceed anyway' . This is to check if the listener can be use or not.

23. Enter your username and password. Then login.

24. This shows that the listener is successfully installed and the installation is finish completely.

That's all for the installation process for Oracle 11g release 2. 
Thank you~~~

Thursday, January 5, 2012

Harvard Business School Case Study (HBS)..

This Harvard Business School case study is an article about Symbian, Google and Apple in the Mobile Space (A). As a computer science student we need to do presentation. So we did it!!hahaha...i'm so relieved that we already done it..buttttt...I still got a report about to do..So here is my report about HBS..

On 14th December 2011, at BK2(Bilik Kuliah 2),N28 at faculty of science computer. We started our presentation at 2.30 pm. Before we started, each group were given a question and thirty minutes to come up with the answer.We are combine with section 1 and section 2.Section 1 is bioinformatic student while Section 2 is database student.There are 10 questions present that day which are:

  1. Strategies taken by Symbian, Google, Apple in striving to lead the mobile industry.
  2. Lesson learned from Harvard Business School Case Study.
  3. New entry company such as Google & Apple become threat to Symbian company. How?
  4. Discuss the key players in mobile phones industries and how they influence each other.
  5. As the future IT professional, how this case study case change your view about your career?
  6. What innovations can be introduce in improving mobile phone industries in terms of community uses and work?
  7. Discuss the Symbian's situation based on Porter's 5 Forces model. What are your recommendation ?
  8. Analyse Symbian's situation using SWOT analysis technique. What is your opinion about company  situation?
  9. Discuss on key Symbian Executive (exhibit 3). What is your opinion about them? Give suggestions.
  10. Discuss on the mobile market share based on the statistics given. 
Here is my group members:
  • Fairuz Amalina
  • Afifah 
  • Fatin Razali
  • Shakila Shoki
  • Fatin Zulaikha
  • Nadia Samsudin 
  • Nurhidayah Salleh
~Our question~
What innovations can be introduce in improving mobile phone industries in term of communities user and work?
While looking for the answers we find that we learn more about mobile phones.Every member need to give an answers.Here are our group answers:
-New mobile phone invention of detecting voices.This innovation is for the blind people. With only using their voices, the mobile phones while do exactly as the owner want. For example, typing the message for the owner and send it according to owner request.Therefore, blind people can have easier access on using the phone.
-This innovation is for security. We suggest to use fingerprints or voice to lock the phone so that no one can access to your personal info from the phones.
-We also suggest to install Autocat application. This can help architect to do their work anywhere, anytime . It make works become easier and architect does not need to bring their laptop.
-Global Positioning System (GPS). Use GPS by using our voices because it is hard when you have to drive and need to search for the places you want at the same time.
-Charge mobile phone using solar energy.
-Use mobile phone as credit card. Does not requires wallet anymore.
-Make mobile phone as projector.

This is our group pictures when we were doing discussion before the presentation...

What they do?

A database administrator could.....

1) Design a digital database for medical records that can be instantly transferred between clinics, unlike paper patient records.

2)Protect a bank accounts from hackers by adding security features to bank's financial database.

3) Make an inventory database for a chain of candy stores to help them keep the most popular candies in stock.

4)Create a database of DNA from people with multiple sclerosis to help researchers pinpoint the genes involved in the disease.

Saturday, December 24, 2011

Mind map....

This is about oracle DBA...

Top 5 things need to know about database as beginners

1. SQL Forms the Core of Relational Databases

2. Selecting Primary Keys is an Extremely Important Decision

3. NULL Is Not Zero or the Empty String

4. Converting Spreadsheets to Databases Saves Time

5. All Database Platforms Are NOT Created Equal

Another DBA~~~

Phil Mcmillan
IT Specialty:
Database Administration
Job Title:
Database Systems Administrator
Major Insurance Company
B.S. in Finance and finishing M.S. in Information Technology
Q.  How does someone go about getting a job in this field?
A. Typically a degree in Computer Science/Information Technology is required, although there are some exceptions to that. I would recommend taking as many data and database classes as possible. In my particular position, one would need to have some experience, but there are many database-related entry-level positions that would be good stepping stones. My past experience was mostly in the arena of data design. But, experience with general technical support and operating systems is also valuable.
Q.  What are ways to advance in your field?
A. Experience is probably the most important element. But, technical certifications are also looked upon favorably. It shows that you are taking initiative and striving to expand your base of knowledge and expertise. In my arena, IBM offers a range of database certifications. 3.  What is the most enjoyable thing about your job? There are new challenges every day. Seldom does a day go by that I don’t learn something new.
Q.  What is the biggest challenge regarding your job?
A. In our area, we deal with a lot of different areas, networking, scripters, etc. That can become difficult as various areas use different terminology and have different perspectives.
Q.  What are your daily tasks like?
A. There are two distinct aspects to my job. One is the service aspect. That would be dealing with problems as they arise. Here I would be troubleshooting problems, talking to business areas experiencing problems, and discussing issues with IBM. The second aspect pertains to project work. This involves working on future upgrades of the DB2 database system, helping business areas improve current functionality, and build new functionality. So a typical day would involve a blend of those activities. Some days are more oriented toward project work. On other days, I’m entirely involved in dealing with current issues and problems.
Q.  What skills do you use at work?
A. I use both technical skills and people skills. I must be able to troubleshoot complex problems and build new solutions for business problems; those things require technical skills. I also must work with various areas in and out of IT. This requires people skills.
Q.  What percentage of your day do you spend working independently or in a group?
A. In my position, I spend approximately 60% of my time working independently and 40% of my time working collaboratively.
Q.  What is one thing you didn’t know about your field before getting into it that you wish you had known?
A. I think in IT, generally, you can never have too much technical knowledge. In my area, specifically, I wish had known more about how applications interact with DB2. We spend a lot of time dealing with application errors that are encountered when accessing the databases.