Easy way to understand oracle concepts

Easy way to understand oracle concepts:

Here I have attached the excel sheet for complete reference. Please let me know in case of further inputs.

Oracle Overview

Regards,

Sabarish Vasudevan

Advertisements

SQL 2005 Installation Steps

Prerequisites:

  • Download the SQL 2005 Dump into the server.
  • Before kickoff the Installation, go through the SQL 2005 guide in sap market place. [server.sap.com]

Installation Steps:

Step 1: Double click on setup.exe file.

Step 2:Click to accept the terms & conditions

ScreenHunter_4

 

ScreenHunter_5

ScreenHunter_6

 

ScreenHunter_8

Step 3:Fill the registration information.

ScreenHunter_9

 

Step 4:According to SQL 2005 guide we need to select below option to implement SAP in it.

ScreenHunter_10

 

ScreenHunter_11

 

Step 5:User Name must be SIDADM and provide strong password for your SQL DB.

ScreenHunter_131

 

And provide password for mixed mode authentication.

 

ScreenHunter_141

 

Step 6:Just follow the SQL 2005 guide and set the below Collation settings

ScreenHunter_15

 

ScreenHunter_16

 

ScreenHunter_17

 

ScreenHunter_18

 

Step 7:SAP recommendation, DB installation should be in J drive, and follow the guide and make the below changes.

ScreenHunter_19

 

ScreenHunter_20

 

ScreenHunter_21

 

Step 8: Finally we have successfully installed SQL 2005 in required server. PFB

ScreenHunter_26

 

ScreenHunter_27

 

I have faced one Major issues during my installation. the SQL service is not coming up while installing, i have fixed as followed by Microsoft articles.

 

WORKAROUND

Method 2

Before you install SQL Server 2005, temporarily change the number of logical processors to one. This makes the computer appear to be a single-processor system, and SQL Server 2005 is installed successfully. To do this, follow these steps:

Windows Server 2003

  1. To change the number of logical processors in Windows Server 2003, follow these steps:
    1. Click Start, click Run, type msconfig, and then click OK.
    2. In the System Configuration Utility dialog box, click the BOOT.INI tab.
    3. On the BOOT.INI tab, click Advanced Options.
    4. In the BOOT.INI Advanced Options dialog box, click to select the /NUMPROC= check box.
    5. In the list that is next to the /NUMPROC= check box, click 1, and then click OK.
    6. In the System Configuration Utility dialog box, click OK.
    7. Restart the server.
  2. Install SQL Server 2005.
  3. Install the latest service pack for SQL Server 2005.

    For more information about how to obtain the latest SQL Server 2005 service pack, click the following article number to view the article in the Microsoft Knowledge Base:

    913089 How to obtain the latest service pack for SQL Server 2005
  4. Restart the server by using all the processors. To do this, follow these steps:
    1. Click Start, click Run, type msconfig, and then click OK.
    2. In the System Configuration Utility dialog box, click the General tab.
    3. On the General tab, click Normal Startup – load all device drivers and services, and then click OK.
    4. Restart the server.

Thanks & Regards,

Sabarish Vasudevan.