How to logon oracle plus?

[Former Member]

hi,

i have a administrator account in the sap system.

but now, i want to logon oracle plus in the local host of the sap system

but i do not know user, password, and host string.

who can give me some hints? thank you in advance.

can i get some informations from the sap system?

thanks and regards.

chu

[Former Member]

i learned the many many skills of ORACLE.

thank you very much for everyone.

[ajjunit84]

Hello,

You should have access to SIDADM and to the host server.

Then try this from the command prompt

sqlplus /"as sysdba"

Regards

Ajay

[JPReyes]

Oracle plus?.... you mean sqlplus i presume...

You will need access to <ora>sid to use sqlplus.... you can also run statements from program RSORADJV

Regards

Juan

[Former Member]

HI

RSORADJV is a good program that execs sql statement.

i execed the next statement select * from usr02

but error is out The following table has not owner PUBLIC or SYS: USR02

then , i changed the statement select * from sys.usr02

but can not exec

thanks and regards

chu

[sunny_pahuja2]

Hi,

What exactly you want to do ?

Thanks

Sunny

[JPReyes]

You need to use the schema before the table.

select * from SCHEMA.TABLE;

But this is not an SQL course so if your question is answered please close the thread.

Regards

Juan

[Former Member]

hi

i want to log on oracle plus .then i exec my sql statement in sap host .

thanks and regards

chu

[Former Member]

Try following

go to command prompt them execute following commands

sqlplus / as sysdba

SQL > select * from sapsr3.usr02

Please replace sapsr3 from above statement if your schema name is different

Hope this helps.