How to work with the Oracle RDBMS in an SAP system

Spread the love

Hands on experience of working with oracle RDBMS in an SAP system is most useful skill for an SAP Basis administrator. Once you are confident in managing oracle database from a command prompt, it will be easy for you to administer any type of SAP system. There are many commands to manage oracle database from a command prompt on windows server. Some of them are given below.

How to connect to oracle RDBMS:

Start – Programs – Accessories – Command Prompt or click Run and enter cmd Command prompt will be displayed

Enter sqlplus /nolog at the command prompt and hit enter EX: C:Documents and settingseh4adm>sqlplus /nolog (EH4 is SAPSID in my system)

SQL> prompt will be displayed, Hit the following command at prompt

SQL>connect /as sysdba
Connected. Will be displayed

That’s it you have connected to the database management system as SYSDBA privilege

Enter the following command at sql prompt to start the Oracle instance:

SQL>connect /as sysdba
Connected to an idle instance.
SQL>startup

Oracle instance will be started; database will be mounted and opened. System Global Area (SGA) is allocated

Enter the following command at sql command prompt to shutdown the oracle instance

SQL>shutdown abort
Oracle instance shut down. Message will be displayed once the database is completely shutdown.

Note: The next start-up of the database will require instance recovery procedures.

Note: there are other shutdown commands available to avoid instance recovery (Ex: SHUTDOWN IMMEDIATE, SHUTDOWN TRANSACTIONAL, and SHUTDOWN NORMAL)

How to ping the database

Enter TNSPING DBSID at command prompt. EX: C:TNSPING EH4 (SAPSID)

It will show you the TNS Ping utility version number, used parameter files and OK message

If it is not showing OK message, there is some error, Please check ORACLE_HOME environment variable is correct or not.

How to get the list of users registered in the database

SQL> connect /
Connected.
SQL> select username from dba_users;

(Visited 579 times, 1 visits today)

1 Comment

Leave a Reply

Your email address will not be published. Required fields are marked *