We now want to login to the Oracle schema that was created through Part 2 SAP Install on Windows Server 2003.
We will start off by starting Oracle Enterprise Manager off of the Start Menu
This will take us to the main screen:
Once we select our database, we will be asked to login under a user.
What is confusing is that the schema created by SAP does not have a password. However, you did assign a password to the default schema. In our case we used:
user: system
password: na*****
Once in, there is a huge amount of detail in this Oracle Enterprise Manager. Its beneficial to go through the different screens and understand what has been setup.
Here you can use the Schema selection to import data into a schema.
The next step is to create a user for the SAP data to be installed in. You can use the OEM to do this or use SQLPlus. We will show both ways.
To create a user in the OEM, select the green cube in the upper left corner. Then scroll down and select the user item.
Then fill in the necessary information
The other way is to use SQLPlus. In addition you will need to grant the user privileges:
Even though the user has now been created, you will find that there are no tables defined in the schema.
