How to uninstall Oracle database software

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

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.
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
   
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.
   
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.
   
   
   
   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.
   
   
   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.
   
   
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 .

SA password in SQL 2000

How to verify if the SA password is blank

On the computer that is hosting the instance of MSDE to which you are connecting, open a command prompt window.

At the command prompt, type the following command, and then press ENTER:

osql -U sa

This connects you to the local, default instance of MSDE by using the sa account. To connect to a named instance installed on your computer type:

osql -U sa -S servername\instancename

You are now at the following prompt:

Password:

Press ENTER again. This will pass a NULL (blank) password for sa.

If you are now at the following prompt, after you press ENTER, then you do not have a password for the sa account:

1>

We recommend that you create a non-NULL, strong password to conform with security practices.

However, if you receive the following error message, you have entered an incorrect password. This error message indicates that a password has been created for the saaccount:

"Login Failed for user 'sa'."

The following error message indicates that the computer that is running SQL Server is set to Windows Authentication only:

Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.

You cannot verify your sa password while in Windows Authentication mode. However, you can create a sa password so that your sa account is secure in case your authentication mode is changed to Mixed Mode in the future.

If you receive the following error message, SQL Server may not be running or you may have provided an incorrect name for the named instance of SQL Server that is installed:

[Shared Memory]SQL Server does not exist or access denied.

[Shared Memory]ConnectionOpen (Connect()).

How to change your SA password

On the computer that is hosting the instance of MSDE to which you are connecting, open the command prompt window.

Type the following command, and then press ENTER:

osql -U sa

At the Password: prompt, press ENTER if your password is blank or type the current password. This connects you to the local, default instance of MSDE by using the saaccount. To connect by using Windows authentication, type this command: use osql -E

Note If you are using SQL Server 2005 Express, avoid using the Osql utility, and plan to modify applications that currently use the Osql feature. Use the Sqlcmd utility instead.

Type the following commands, on separate lines, and then press ENTER:

sp_password @old = null, @new = 'complexpwd', @loginame ='sa' go

Note Make sure that you replace "complexpwd" with the new strong password. A strong password includes alpha-numeric and special characters, and a combination of upper and lower case characters.

You will receive the following informational message, which indicates that your password was changed successfully:

Photoshop error -- Could not initialize Photoshop because file is locked

It is a corrupt Adobe Pref’s …
to fix delete your Adobe PS CSx profile from your PC

C:\Documents and Settings\”username”\Application Data\Adobe folder and all it’s contents.