Wednesday, September 22, 2010
Server Related Questions
1. How to check disk performance? How to troubleshoot that problem? What is the procedure?
2. How to delete software errors? What is that?
3. if the server has slow how to check the server performance?
How to check server performance what is the procedure?
4. if the server is down, how to bring up the server?
5. if one server is down, whenever restart the machine we get ok prompt what is the problem?
6. one server is down it doen't display anything what you do?
7. in vcs, which network[private or public] channel bandwidth is high?
8. why we r going to freezing service group and system, what are the freezing steps & how to freezing service group?
9. whenever we give #metastat cmd in svm, it display output "need to maintain" state, what u do?
10. in solaris file sysrm is full what u do?
11. whenever install patch cluster, system will be restart what is the problem?
12. how to check or see device port number?
13. how to know how many samba users in solaris?
14. how to merge solaris partition?
15. diff between /etc/inetd and smf?
16. how to set kernal parameters in solaris 10&9?
17. how do I disable dmp?
18. how to add a new host to DNS?
19. what is the diff between LLT,GAB&TCP/IP?
20. what is vcs seeding & jeopardy & purpose?
21. I am using solaris box, I need to delete a file from path /usr/tmp/ which r older than 24 hours?
22. which server we can update first in DNS?
2. How to delete software errors? What is that?
3. if the server has slow how to check the server performance?
How to check server performance what is the procedure?
4. if the server is down, how to bring up the server?
5. if one server is down, whenever restart the machine we get ok prompt what is the problem?
6. one server is down it doen't display anything what you do?
7. in vcs, which network[private or public] channel bandwidth is high?
8. why we r going to freezing service group and system, what are the freezing steps & how to freezing service group?
9. whenever we give #metastat cmd in svm, it display output "need to maintain" state, what u do?
10. in solaris file sysrm is full what u do?
11. whenever install patch cluster, system will be restart what is the problem?
12. how to check or see device port number?
13. how to know how many samba users in solaris?
14. how to merge solaris partition?
15. diff between /etc/inetd and smf?
16. how to set kernal parameters in solaris 10&9?
17. how do I disable dmp?
18. how to add a new host to DNS?
19. what is the diff between LLT,GAB&TCP/IP?
20. what is vcs seeding & jeopardy & purpose?
21. I am using solaris box, I need to delete a file from path /usr/tmp/ which r older than 24 hours?
22. which server we can update first in DNS?
Wednesday, September 1, 2010
Oracle -10G Installations
ProgrammerWorld.NET
* Reviews
* Parent Site
* Amazon Deals
* Advertise
* About us
Search
Web This Site
Submit search form
Database
* Offer for Programmerworld users 40% off
* Installing Oracle 10g – step by step guide
* SQL Interview Questions and Answers
* FAQs about MS-SQl server
Main Menu
* Money Making Tips
* Microsoft Windows
* Web Publishing
* The Web
* Miscellaneous
* VoIP
* Database
* Programming
* Coolest Gadgets
* Networking / Hardware
* Resume Tips
* Interview Tips
* Career Tips
* PC
* Linux/Unix
* Fun & Time-pass Stuff
* Reviews Section
* SiteMap
Sister Sites
* ProgrammerWorld
* DevelopersVoice
* Faq.ProgrammerWorld.Net
* Health.ProgrammerWorld.Net
* Tips.DevelopersVoice.Com
Installing Oracle 10g – step by step guide
Introduction:
This article is a step-by-step instruction for those who want to install Oracle 10g database on their computer. This document provides guidelines to install Oracle 10g database on Microsoft Windows environment. If you use other operating system other than Microsoft Windows, the process is not too much different from that of Microsoft Windows, since Oracle uses Oracle Universal Installer to install its software.
For more information about installing Oracle 10g under operating systems other than Microsoft Windows, please refer to this URL :
http://www.oracle.com/pls/db102/homepage
How to get Oracle 10g :
You can download Oracle 10g database from www.oracle.com. You must registered and create an account before you can download the software. The example in this document uses Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows.
How to uninstall Oracle database software :
1. Uninstall all Oracle components using the Oracle Universal Installer (OUI).
2. Run regedit.exe and delete the HKEY_LOCAL_MACHINE/ SOFTWARE/ORACLE key. This contains registry entire for all Oracle products.
3. Delete any references to Oracle services left behind in the following part of the registry: HKEY LOCAL MACHINE/ SYSTEM/ CurrentControlsSet/ Services/Ora*. It should be pretty obvious which ones relate to Oracle
4. Reboot your machine.
5. Delete the C: \Oracle directory, or whatever directory is your Oracle_Base.
6. Delete the C:\Program Files \Oracle directory.
7. Empty the contents of your c:\temp directory.
8. Empty your recycle bin.
Installing Oracle 10g database software :
1. Insert Oracle CD , the autorun window opens automatically. If you are installing from network or hard disk, click setup.exe in the installation folder.
2. The Oracle Universal Installer (OUI) will run and display the Select Installation Method Window.
oracle10g installation
3. Choose Basic Installation:
Select this option to quickly install Oracle Database 10g. This method requires minimal user input. It installs the software and optionally creates a general-purpose database based on the information you provide.
For basic installation, you specify the following:
Oracle Home Location — Enter the directory in which to install the Oracle Database 10g software. You must specify a new Oracle home directory for each new installation of Oracle Database 10g. Use the default value, which is :
c:\oracle\product\10.2.0\db_1
Installation Type — Select Enterprise Edition :
If you have limited space, select standard edition. Personal edition installs the same software as the Enterprise Edition, but supports only a single-user development and deployment environment.
Create Starter Database — Check this box to create a database during installation. Oracle recommends that you create a starter database for first Create Starter Database — time installations. Choose a Global Database Name, like cs157b, or just use the default value.
Type a password. Don’t lose this password, since you will need it to connect to the database server.
Click next
4. The Product-Specific Prerequisite Checks window appears: Click next
oracle10g installation
5. A summary screen appears showing information such as your global settings, space requirements and the new products to be installed. Click Install to start the installation..
6. The Install window appears showing installation progress.
oracle10g_installation
7. At the end of the installation phase, the Configuration Assistants window appears. This window lists the configuration assistants that are started automatically.
If you are creating a database, then the Database Configuration Assistant starts automatically in a separate window.
oracle 10g installation
oracle 10g installation
At the end of database creation, you are prompted to unlock user accounts to make the accounts accessible. The SYS and SYSTEM accounts are already unlocked. Click OK to bypass password management.
oracle 10g installation
Note: Oracle 10g still keeps scott / tiger username and password (UID=scott, PWD=tiger) from the old version of oracle. In the old version of oracle, scott/tiger user ID is available by default, but not in oracle 10g. If you want to use scott /tiger account, you must unlock it by clicking “Password Management” at the last window.
Password Management window will appear like the one shown below. Find the user name “Scott” and uncheck the “Lock Account?” column for the user name.
8. Your installation and database creation is now complete. The End of Installation window displays several important URLs, one of which is for Enterprise Manager.
oracle 10g installation
9. You can navigate to this URL in your browser and log in as the SYS user with the associated password, and connect as SYSDBA. You use Enterprise Manager to perform common database administration tasks
Note : you can access Oracle Enterprise Manager using browser by typing the URL shown above in your browser. Instead of typing the IP address, you can also access the Enterprise Manager by typing http://localhost:1158/em or “http://[yourComputerName]:1158/em” or by clicking “Start >> All Programs >> Oracle – [YourOracleHome_home1] >> Database Control – [yourOracleID]” in Windows menu.
By default, use user ID “SYSTEM”, with the password that you have chosen at the beginning of installation, to connect to database, SQLPlus, etc. If you want to use other user ID, you may create a new user .
AddThis
Contact or send us suggestions at : Admin@ProgrammerWorld.NET
For any business and Advertisement related queries contact us on : Admin@ProgrammerWorld.NET
Copyright © 2009 ProgrammerWorld.NET. All Rights Reserved.
Ads By infinityads.comClose
* Reviews
* Parent Site
* Amazon Deals
* Advertise
* About us
Search
Web This Site
Submit search form
Database
* Offer for Programmerworld users 40% off
* Installing Oracle 10g – step by step guide
* SQL Interview Questions and Answers
* FAQs about MS-SQl server
Main Menu
* Money Making Tips
* Microsoft Windows
* Web Publishing
* The Web
* Miscellaneous
* VoIP
* Database
* Programming
* Coolest Gadgets
* Networking / Hardware
* Resume Tips
* Interview Tips
* Career Tips
* PC
* Linux/Unix
* Fun & Time-pass Stuff
* Reviews Section
* SiteMap
Sister Sites
* ProgrammerWorld
* DevelopersVoice
* Faq.ProgrammerWorld.Net
* Health.ProgrammerWorld.Net
* Tips.DevelopersVoice.Com
Installing Oracle 10g – step by step guide
Introduction:
This article is a step-by-step instruction for those who want to install Oracle 10g database on their computer. This document provides guidelines to install Oracle 10g database on Microsoft Windows environment. If you use other operating system other than Microsoft Windows, the process is not too much different from that of Microsoft Windows, since Oracle uses Oracle Universal Installer to install its software.
For more information about installing Oracle 10g under operating systems other than Microsoft Windows, please refer to this URL :
http://www.oracle.com/pls/db102/homepage
How to get Oracle 10g :
You can download Oracle 10g database from www.oracle.com. You must registered and create an account before you can download the software. The example in this document uses Oracle Database 10g Release 2 (10.2.0.1.0) for Microsoft Windows.
How to uninstall Oracle database software :
1. Uninstall all Oracle components using the Oracle Universal Installer (OUI).
2. Run regedit.exe and delete the HKEY_LOCAL_MACHINE/ SOFTWARE/ORACLE key. This contains registry entire for all Oracle products.
3. Delete any references to Oracle services left behind in the following part of the registry: HKEY LOCAL MACHINE/ SYSTEM/ CurrentControlsSet/ Services/Ora*. It should be pretty obvious which ones relate to Oracle
4. Reboot your machine.
5. Delete the C: \Oracle directory, or whatever directory is your Oracle_Base.
6. Delete the C:\Program Files \Oracle directory.
7. Empty the contents of your c:\temp directory.
8. Empty your recycle bin.
Installing Oracle 10g database software :
1. Insert Oracle CD , the autorun window opens automatically. If you are installing from network or hard disk, click setup.exe in the installation folder.
2. The Oracle Universal Installer (OUI) will run and display the Select Installation Method Window.
oracle10g installation
3. Choose Basic Installation:
Select this option to quickly install Oracle Database 10g. This method requires minimal user input. It installs the software and optionally creates a general-purpose database based on the information you provide.
For basic installation, you specify the following:
Oracle Home Location — Enter the directory in which to install the Oracle Database 10g software. You must specify a new Oracle home directory for each new installation of Oracle Database 10g. Use the default value, which is :
c:\oracle\product\10.2.0\db_1
Installation Type — Select Enterprise Edition :
If you have limited space, select standard edition. Personal edition installs the same software as the Enterprise Edition, but supports only a single-user development and deployment environment.
Create Starter Database — Check this box to create a database during installation. Oracle recommends that you create a starter database for first Create Starter Database — time installations. Choose a Global Database Name, like cs157b, or just use the default value.
Type a password. Don’t lose this password, since you will need it to connect to the database server.
Click next
4. The Product-Specific Prerequisite Checks window appears: Click next
oracle10g installation
5. A summary screen appears showing information such as your global settings, space requirements and the new products to be installed. Click Install to start the installation..
6. The Install window appears showing installation progress.
oracle10g_installation
7. At the end of the installation phase, the Configuration Assistants window appears. This window lists the configuration assistants that are started automatically.
If you are creating a database, then the Database Configuration Assistant starts automatically in a separate window.
oracle 10g installation
oracle 10g installation
At the end of database creation, you are prompted to unlock user accounts to make the accounts accessible. The SYS and SYSTEM accounts are already unlocked. Click OK to bypass password management.
oracle 10g installation
Note: Oracle 10g still keeps scott / tiger username and password (UID=scott, PWD=tiger) from the old version of oracle. In the old version of oracle, scott/tiger user ID is available by default, but not in oracle 10g. If you want to use scott /tiger account, you must unlock it by clicking “Password Management” at the last window.
Password Management window will appear like the one shown below. Find the user name “Scott” and uncheck the “Lock Account?” column for the user name.
8. Your installation and database creation is now complete. The End of Installation window displays several important URLs, one of which is for Enterprise Manager.
oracle 10g installation
9. You can navigate to this URL in your browser and log in as the SYS user with the associated password, and connect as SYSDBA. You use Enterprise Manager to perform common database administration tasks
Note : you can access Oracle Enterprise Manager using browser by typing the URL shown above in your browser. Instead of typing the IP address, you can also access the Enterprise Manager by typing http://localhost:1158/em or “http://[yourComputerName]:1158/em” or by clicking “Start >> All Programs >> Oracle – [YourOracleHome_home1] >> Database Control – [yourOracleID]” in Windows menu.
By default, use user ID “SYSTEM”, with the password that you have chosen at the beginning of installation, to connect to database, SQLPlus, etc. If you want to use other user ID, you may create a new user .
AddThis
Contact or send us suggestions at : Admin@ProgrammerWorld.NET
For any business and Advertisement related queries contact us on : Admin@ProgrammerWorld.NET
Copyright © 2009 ProgrammerWorld.NET. All Rights Reserved.
Ads By infinityads.comClose
Subscribe to:
Posts (Atom)