Couple of question about Oracle with SAP

[Former Member]

I am Angeline Purnama,

I was looking your answer above question, your answer is soooooooo good, I like that.... I have some confousing about oracle datbase...

In SAP NW2004s

I forget username for sqlplus I never open that, so what is the normal user ID for sqlplus and password...

1. When I goto DataBASE instance in Windows Env. I can see some folder like sapdata1, sapdata2, sapdata3, sapdata4

it contance almost 20GB size of HDD what is basically inside ?

2. How to Use BR* Tools, thats really confouse and I read lot of sdn help but still confouse

how to setup step by step ?

3. I forget basically my sqlplus username and password: you said you can go to look at SAPUSER table... but when I see that using Tr: SE16 that table doesn't exist...

4. I want to get view one table name is XI_AF_MSG this is XML table I am not sure where is that table located...

5. Why everyday archived background job are running and keep archived data ?

Thanks in Advanced...

Angeline Purnama

[ashish_vikas · Accepted solution]

Hello Angeline Purnama,

And here r your short answers ..

1. When I goto DataBASE instance in Windows Env. I can see some folder like sapdata1, sapdata2, sapdata3, sapdata4

it contance almost 20GB size of HDD what is basically inside ?

: sapdata1, sapdata2 are oracle directory which contain datafiles. If you open any sapdata directory, you will agai find folders which will contain datafiles and these datafiles contain all data of sap like abap prog. or table dat.. so it's always take HDD space.

2. How to Use BR* Tools, thats really confouse and I read lot of sdn help but still confouse

how to setup step by step ?

: On windows, you can use BR*Tools on command prompt..just need to set environmental variables correctly

on CMD just type brtools .. you will get its interactive menu.

3. I forget basically my sqlplus username and password: you said you can go to look at SAPUSER table... but when I see that using Tr: SE16 that table doesn't exist...

: you can always login in SQLPLUS as sysdba as through command prompt on windows :

sqlplus "/as sysdba"

4. I want to get view one table name is XI_AF_MSG this is XML table I am not sure where is that table located...

: ya, you can use simple SQL to view it in SQLPLUS.

5. Why everyday archived background job are running and keep archived data ?

: probable you have scheduled it to run ..

Hope it will help ..

regards

Ashish

[Former Member · Accepted solution]

Hi Ashish

Thanks you very much for provided these answers, pretty much clear concept, but still i have to learn a lot for oracle...

Thanks again

[markus_doehr2]

> 1. When I goto DataBASE instance in Windows Env. I can see some folder like sapdata1, sapdata2, sapdata3, sapdata4

> it contance almost 20GB size of HDD what is basically inside ?

Those are the database files containing the data.

> 2. How to Use BR* Tools, thats really confouse and I read lot of sdn help but still confouse

> how to setup step by step ?

To do what?

I suggest:

Take an Oracle class first. It's crucial to understand, what "the database" is, what it is doing and how it work conceptually. Without knowing that everything will be nothing but a frustrating experience.

If you start with SAP systems then I highly suggest using a database that is easier to maintain and understand than Oracle.

Markus

[Former Member]

Hi Angeline,

What is your OS??

Try ora<SID> then go to sql prompt

SQL> connect sys / as sysdba;

SQL> select username from all_users;

Now you can select object prefix with username.

Use Master password for oracle sap user.

What you want see as given information 1.) --- its meaning less.

2.) Brtools - read below link

http://help.sap.com/saphelp_nw70/helpdata/EN/0c/cd271365debc42bef96ac7fd907787/frameset.htm

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d8fc1f3a-0d01-0010-1c84-ac8bee9f...

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/6049ab24-f948-2b10-929e-eda13ff1...

http://www.basisconsultant.com/docs/handbooks/homcopyv1.pdf

[original link is broken]

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm - Oracle

[Former Member]

Hello Surend,

O my god thanks a lot thats really good and nice help, I have to read a lot... but it good even very good... thanks again..

o yea, my OS is Windows 2003 Server...

Take care