Another newbie question 1

[cmptrnerd]

I was given the following project and I have a few questions.

First here was the project

1) Create and ODBC Data Source Connection called "Siebsrvr_Siebel"

2) Create a SQL*Net Connect String called SiebelProd

3) Create a table owner username/password of "Siebel"/"Siebel"

4) Create an index Tablespace area for Siebel called "SiebelIndex". The
Tablespace should be 200 MB in size with an initial extent of 2 blocks or 8
KB and a next extent of 100 KB.

5) Create a data Tablespace area for Siebel called "SiebelData". The
Tablespace should be 200 MB in size with an initial extent of 2 blocks or 8
KB and a next extent of 100 KB.

6) Please make the following changes to init.ora
a) Optimizer_Mode should be set to rule based optimization
b) DB_BLOCK_BUFFERS should be set to 10,000
c) SHARED_POOL_SIZE should be set to 20 MB
d) DB_FILE_MULTIBLOCK_READ_COUNT should be set to 32
e) SORT_AREA_SIZE should be set to 512,000
f) SORT_AREA_RETAINED_SIZE should be set to 65,536
g) OPEN_CURSURS should be set to 2,000
h) DB_BLOCK_SIZE should be set to 4 KB
i) NLS_DATE_FORMAT should be set to DD-MON-RR
j) PROCESSES should be set to 150
k) SESSIONS should be set to a number greater than 1 if it is
not already

7) Temporary tablespaces should have INITIAL and NEXT EXTENT parameters
set to 14 KB

8) Create 4 Rollback Segments with an initial extent set to 100 KB, and
next set to 100 KB in a dedicated Rollback Segment Tablespace.

9) Create 1 Large Rollback segment called BigRollback with an initial
extent of 51200 KB and a next extent of 51200 KB in the Rollback Segment
Tablespace created above.

10) Remove all other Rollback segments.

Here are my questions

1) How do you create Create a SQL*Net Connect String called SiebelProd

2) I went into DBA studio and created user siebel, but what do you have to do to make them a table owner or is that a tablespace owner.

3)4 on the rollback segments, should I make them for the SIEBELDATA table space or the Default Rollback tablespace.

Thanks in advance
mark
mark@acsconsult.com

 

[carp]

1) Use the Net8 Configuration Assistant to create the connect string (this will actually be a TNS alias).
2) If you have created the user siebel, then any tables siebel creates will be owned by siebel. This will probably happen during the Siebel install process.
3) I would put the Siebel rollback segments either in your default RBS tablespace or create an siebelRBS tablespace and put them in there. I DEFINITELY wouldn't put them in the same tablespace as my data!

 

[siree]

Hi cmptrnerd
When you are creating user seibel dont forget to mention
default tablespace as seibeldata and
temporary tablespace temp.
If you dont mention the above all the schema's created in user seibel will stored in system tablespace.

When you want to create rollback segments.
First create a seperate tablespace for rollback segs.
And then create rollback segs .
bring them online.
If you dont need any roolback segs , you can offline them.

And give the values for roolback_segments parameter in the init<sid>,ora file.

for eg


Rollback_segments=(rbs01,rbs02.rbs03,rbs04,bigrollback)

I hope this will help you.