Connecting with SYS and SYSTEM database user

[Lachlann]

Hello

I am unable to connect with oracle SYS user on windows XP system and running with oracle 9i database.After exporting the database SID when I enter the sqlplus command with user name and password,it occur some error and showing me a list of options,I am so confused to connect with my database.As earlier I was using oracle on Linux. Everything was fine there but now...If you have any suggestions please just post me as soon as possible.

Thank you

[Reegan]

SYS and SYSTEM database user :

The database requires some high privileged user who can perform the configuration,maintenance and management of database.

The SYS and SYSTEM are those two users who belongs that category and perform the maintenance task of database and hold a lot of privileges. They are database defined user and have privileges to access the database for another user of database. But one thing I would mention here, The SYS user is one of highest privileged user of database and on other hand, the SYSTEM user has some less privilege in the comparison of SYS user.

[opaper]

Connecting with SYS and SYSTEM on Windows :

The connection method is some like different on windows operating system than other.To connect with these users in the Windows environment would be as follows :

1- Go to Start menu and click .
2- Click on RUN and type Command in the text box.
3- The windows prompt would be opened and export the database with the SID
C:\Set Oracle_sid=<name_of_database>
4- And execute the following :
C:\sqlplus /NOLOG
5- After executing this command,you would be prompted with SQL prompt and type the following command :
Conn sys/sys as sysdba;
6- Now you are in SYS schema .

[MindSpace]

Connecting with SYS and SYSTEM on Linux :

The connection method on Linux is somewhat different from other systems.If you are going to be connect with SYS or SYSTEM then you need to perform following steps :

• Open the terminal and connect with Oracle user for which DBMS was installed using below statement :
  #su - Oracle
  
• Now export the name of the database as a SID
  $ Export ORACLE_SID=<name_of_database>
• And execute the following statement to connect with SYS user.
  $ sqlplus 'sys/sys as sysdba'

Now you are in the schema of sys user.

[Modifier]

Issues in Connecting :

If you are getting problem yet then make sure the parameter that you have configured for your database. The statement that you are entering regarding the exporting of database,may be wrong some where.Check it properly.

The statement for exporting the SID for database would be as follows :

 $ Export ORACLE_SID =<Name_of_database>