Oracle Login

[Former Member]

HI Masters,

I am new to SAP.

I have installed 4.7 IDES on Win2k and Oracle database.

I would like to login into database and play around with deleting of SAP* user and stuff using the sql statements , but i don't know the login details to enter into Oracle. Can you please guide me what the login details will be.

The sid i have given is ERP.

Thanks in Advance.

Sachin.

[Former Member · Accepted solution]

Hello,

go to command promt

1) sqlplus /nolog

2) connect / as sysdba

[Former Member · Accepted solution]

Thanks Maheswer for the quick response. I could enter into Oracle.

One more question..when i am entering the sql command select uflag from usr02 where mandt=777 and bname = 'sap'* it is saying

that the view or table (USR02) does not exist.

Can you provide me the correct sql statement to access this table.

Thanks in Advance,

sachin.

[markus_doehr2 · Accepted solution]

If you logon as sysdba you need to give the schma ID:

sqlplus / as sysdba
select uflag from sapr3.usr02 where mandt=777 and bname = 'sap*

If you logon with the real used user you don´t need to do that:

sqlplus /@<SID>

You can, however, browse tables easier using SE16.

Markus

[Former Member · Accepted solution]

Markus,

Actually i have logged into Oracle with the details provided by maheswer.

go to command promt

            1) sqlplus /nolog
           
            2) connect / as sysdba

Even then also i am getting thew same message saying

the view or table (USR02) does not exist

.

Is this the way you were asking me to login into Oracle.

Thanks,

Sachin.

[markus_doehr2 · Accepted solution]

As said - you need to give the SCHEMA with the SQL-Statement (see my examples).

Markus

[Former Member · Accepted solution]

Markus,

I have entered the command

select  uflag from sapr3.usr02 where mandt=777 and bname = 'sap*';

as you said.

Even then i am getting the same error saying that the table or view doesn't exist.

Sachin.

[markus_doehr2 · Accepted solution]

The you are using the wrong schema ID. SAPR3 is the default, depending on the installation CD setup you used this can also be SAPSR3 or SAP<SID> - what did you choose?

Markus

[Former Member · Accepted solution]

When i gave the command

select uflag from saperp.usr02 where mandt=777;

(where sid = erp in my case) it worked fine.

Thanks Markus for the guidance and patience u have shown.

Sachin.