Minggu, 28 Februari 2010

Penambah table extente database

waktu kita check tcode db02 ternyata pas check space statistic table spacenya sudah sampe 95% tandanya kita harus extent table space server databasenya....
di db13 juga seh biasanya juga muncul erornya kalo udah lebih dari 95% tapi itu sangat
ga di sarankan kalo sampe 95% ga di extent table spacenya,

oke langsung aja kita buka BRTOOLS nya startdartnya SAP:
logikanya kalo soal database yang masalah maka server databasenya yang mesti kita lakukan perbaikan
1.Loggin ke database server

login: root
Password:
Last login: Mon Dec 3 11:01:04 from 172.17.102.76:0
Sun Microsystems Inc. SunOS 5.9 Generic May 2002
You have mail.
Sourcing //.profile-EIS.....

2. loggin ke adm
itu SAP nya punya kita
contoh saya pake di sini sech pakenya adalah tpr
root@tasdb1 # su - tpradm
Sun Microsystems Inc. SunOS 5.9 Generic May 2002

3. jalankan BRTOOLS

tasdb1:tpradm 1% brtools
BR0651I BRTOOLS 6.40 (39)

BR0280I BRTOOLS time stamp: 2007-12-04 10.59.52
BR0656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu

1 = Instance management
2 - Space management
3 - Segment management
4 - Backup and database copy
5 - Restore and recovery
6 - Check and verification
7 - Database statistics
8 - Additional functions
9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
------------------------------------------------------------------------------
dari logika kita akan benerin spacenya bearti kita pilih nomer 2

BR0662I Enter your choice:
2
BR0280I BRTOOLS time stamp: 2007-12-04 11.00.02
BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2007-12-04 11.00.02
BR0656I Choice menu 5 - please make a selection
-------------------------------------------------------------------------------
Database space management

1 = Extend tablespace
2 - Create tablespace
3 - Drop tablespace
4 - Alter tablespace
5 - Alter data file
6 - Move data file
7 - Additional space functions
8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------

dari sana kita pilih nomer 1 karena kita akan meng-extent table space

BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2007-12-04 11.00.03
BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2007-12-04 11.00.03
BR0657I Input menu 81 - please check/enter input values
-------------------------------------------------------------------------------
BRSPACE options for tablespace extension

1 - BRSPACE profile (profile) ...... [initTPR.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... []
4 - Confirmation mode (confirm) .... [yes]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initTPR.sap -s 20 -l E -f tsextend]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------

untuk Table space name dapat di lihat dari tcode db02


nah setelah kita tau tabel spacenya maka kita pilih tabel spacenya

BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2007-12-04 11.00.18
BR0663I Your choice: '3'

BR0280I BRTOOLS time stamp: 2007-12-04 11.00.18
BR0681I Enter string value for "tablespace" []:
PSAPTPR
BR0280I BRTOOLS time stamp: 2007-12-04 11.00.27
BR0683I New value for "tablespace": 'PSAPTPR'

BR0280I BRTOOLS time stamp: 2007-12-04 11.00.27
BR0657I Input menu 81 - please check/enter input values
-------------------------------------------------------------------------------

BRSPACE options for tablespace extension

1 - BRSPACE profile (profile) ...... [initTPR.sap]
2 - Database user/password (user) .. [/]
3 ~ Tablespace name (tablespace) ... [PSAPTPR]
4 - Confirmation mode (confirm) .... [yes]
5 - Scrolling line count (scroll) .. [20]
6 - Message language (language) .... [E]
7 - BRSPACE command line (command) . [-p initTPR.sap -s 20 -l E -f tsextend -t PSAPTPR]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2007-12-04 11.02.12
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initTPR.sap -s 20 -l E -f tsextend -t PSAPTPR'

BR0280I BRTOOLS time stamp: 2007-12-04 11.02.12
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2007-12-04 11.02.23
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

###############################################################################

BR1001I BRSPACE 6.40 (39)
BR1002I Start of BRSPACE processing: sdwsvmvv.tse 2007-12-04 11.02.23

BR0280I BRSPACE time stamp: 2007-12-04 11.02.26
BR1009I Name of database instance: TPR
BR1010I BRSPACE action ID: sdwsvmvv
BR1011I BRSPACE function ID: tse
BR1012I BRSPACE function: tsextend

BR0280I BRSPACE time stamp: 2007-12-04 11.02.27
BR0657I Input menu 303 - please check/enter input values
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPTPR (1. file)

1 * Last added file name (lastfile) ....... [/oracle/TPR/sapdata4/tpr_15/tpr.data15]
2 * Last added file size in MB (lastsize) . [2000]
3 - New file to be added (file) ........... [/oracle/TPR/sapdata4/tpr_16/tpr.data16]
4 ~ Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [2000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [10000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPTPR add datafile '/oracle/TPR/sapdata4/tpr_16/tpr.data16' size 2000M autoextend on next 20M maxsize 10000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
setelah kita sudah yakin dengan besarnya space yang akan kita gedein maka kita pilih continue

BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2007-12-04 11.03.56
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-12-04 11.03.56
BR1091I Next data file can be specified now
BR0675I Do you want to perform this action?
BR0676I Enter 'y[es]' to perform the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2007-12-04 11.04.26
BR0257I Your reply: 'c'
BR0678I The action will be skipped...
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-12-04 11.04.27
BR0370I Directory /oracle/TPR/sapreorg/sdwsvmvv created

BR0280I BRSPACE time stamp: 2007-12-04 11.04.28
BR0319I Control file copy created: /oracle/TPR/sapreorg/sdwsvmvv/cntrlTPR.old 6791168

BR0280I BRSPACE time stamp: 2007-12-04 11.04.28
BR0370I Directory /oracle/TPR/sapdata4/tpr_16 created

BR0280I BRSPACE time stamp: 2007-12-04 11.04.28
BR1088I Extending tablespace PSAPTPR...

BR0280I BRSPACE time stamp: 2007-12-04 11.05.25
BR1016I SQL statement 'alter tablespace PSAPTPR add datafile '/oracle/TPR/sapdata4/tpr_16/tpr.data16' size 2000M autoextend on next 20M maxsize 10000M' executed successfully
BR1051I Tablespace PSAPTPR extended successfully with file: /oracle/TPR/sapdata4/tpr_16/tpr.data16 2000M

BR0280I BRSPACE time stamp: 2007-12-04 11.05.25
BR0340I Switching to next online redo log file for database instance TPR ...
BR0321I Switch to next online redo log file for database instance TPR successful

BR0280I BRSPACE time stamp: 2007-12-04 11.05.28
BR0319I Control file copy created: /oracle/TPR/sapreorg/sdwsvmvv/cntrlTPR.new 6791168

BR0280I BRSPACE time stamp: 2007-12-04 11.05.28
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2007-12-04 11.06.11
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2007-12-04 11.06.11
BR1020I Number of tablespaces processed: 1
BR1003I BRSPACE function 'tsextend' completed

BR1008I End of BRSPACE processing: sdwsvmvv.tse 2007-12-04 11.06.11
BR0280I BRSPACE time stamp: 2007-12-04 11.06.11
BR1005I BRSPACE completed successfully

###############################################################################

BR0292I Execution of BRSPACE finished with return code 0
BR0280I BRTOOLS time stamp: 2007-12-04 11.06.11

kalo udah setesai pilih aja contingu lagi aja

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRTOOLS:
c
BR0280I BRTOOLS time stamp: 2007-12-04 11.06.21
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2007-12-04 11.06.21
BR0656I Choice menu 5 - please make a selection
-------------------------------------------------------------------------------
Database space management

1 + Extend tablespace
2 - Create tablespace
3 - Drop tablespace
4 - Alter tablespace
5 - Alter data file
6 - Move data file
7 - Additional space functions
8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
b
BR0280I BRTOOLS time stamp: 2007-12-04 11.06.29
BR0663I Your choice: 'b'
BR0673I Going back to the previous menu...

BR0280I BRTOOLS time stamp: 2007-12-04 11.06.29
BR0656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu

1 = Instance management
2 + Space management
3 - Segment management
4 - Backup and database copy
5 - Restore and recovery
6 - Check and verification
7 - Database statistics
8 - Additional functions
9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------

BR0662I Enter your choice:
9
BR0280I BRTOOLS time stamp: 2007-12-04 11.06.31
BR0663I Your choice: '9'
BR0280I BRTOOLS time stamp: 2007-12-04 11.06.31
BR0680I Do you really want to exit BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2007-12-04 11.06.37
BR0257I Your reply: 'y'

BR0280I BRTOOLS time stamp: 2007-12-04 11.06.37
BR0652I BRTOOLS completed successfully

keluar dari BRTOOLS
tasdb1:tpradm 2% exit

Logout dari SAP administrator
tasdb1:tpradm 3% logout

root@tasdb1 #

Selesai........
coba check di tcode db02 nya dengan klik refesh



Kamis, 11 Februari 2010

koneksi antara lotusnotes dan zimbra

Untuk koneksi global address di zimbra biar bisa replikasi bareng address book lotusnotes maka kita bisa gunakan LDAP server bawaanya Zimbra tapi sarat khususnya adalah LDAP server di lotusnotesnya haruslah sudah hidup...

langkah awal kita check apakah servernya udah idup pa blom...

masuk ke lotusnotes administrator -->server-->server task
nah liat apakah lpad servernya apakah Udah listening atau blum,...
kalo belum tinggal di start aja.... servicenya...



tinggal kita setting di LDAP nya zimbrakita asumsikan kita udah masuk ke adminnya zimbra

trus pilih domain--> klik domain yang akan kita replicate ke lotusnotes
trus pilih conf GAL
nah sekarang kita mulai untuk setting GAL nya zimbra






nah kita pilih yang both karena kita setting zimbra kita supaya baca address booknya dia sendiri dan menbaca punya lotusnotes juga




Untuk External Server name kita tulis IP add server Lotnot kita portnya ga usah di ganti
Untuk LDAP filter Tulis aja standarnya zimbra
(|(cn=%s*)(sn=%s*)(gn=%s*)(mail=%s*))
Autocomplite Filter tulis aja stardartnya zimbra
externalldapAutocomplete

LDAP search base tulis O= slasnya Organisai kita di lotusnotes misal alamt kita di lotusnotes
IT support/ITE/NN nah yang di Tulis di LDAP searchnya itu yang NN

trus klik next.....
maka akan datang kaya gini....
pada bing DN nya di tulis
CN= nama user di lotusnotes/OU=group di lotusnotes/O= perusahaan kita
contoh: CN=IT support/OU=ITE/O=NN
nah untuk password kita gunakan password web broser di lotusnotesnya.....
setelah selesai kita klik next lagi....
maka dia akan mencoba replikasi dengan lotusnotesnya,pabila semuanya lancar maka akan muncul kaya ini...

kalo udah dateng kaya ini maka sukseslah kita nyambungin address book lotusnotes dan addressbooknya zimbra....
ini hasilnya...
masuk ke acount zimbra kita
trus simulasikan kita akan composes email
lalu ceklah pasti alamt emailnya akan nongol yang biasa kita pake di zimbra+lotusnotes....