Hostname change on SAP Sytem running on SAP 4.7,SUSE 9.1 Max db 7.4

[Former Member]

hi Gurus

Iam trying to do a hostname change on a system running SAP 4.7 on SUSE Enterprise 9.1 and Maxdb 7.4.

At os level i know i should change in:

/etc/hosts

the profile parameters

the enviroment for SIDadm e.g .sapsrc_BST1.sh files

So is there anywhere else i need to change the hostname on the Database side?

Any ideas welcome

[markus_doehr2]

You need to change also all .XUSER62 files (for <SID>adm and sqd<SID>) - I'm not sure if the "xuser" tool is already in 7.4.

I suggest you upgrade to MaxDB 7.5 or 7.6.

Markus

[Former Member]

Hi,

i think xuser is available since 7.3. (i remember working with xuser on an 7.3 1,5 Years ago).

Switch to user SIDadm sqdSID like Markus said.

In the homedir of the user (/home/SIDadm/.XUSER62) edit this file with the xuser command.

Change the "Server" Parameter vor all Users in this File. Do not delete any User. (Hint. 39439)

Regards

Manuel

[Former Member]

Thanks for the response.

I have changed the files mentioned.As for the XUSER which xuser command should i use as i used vi to edit it?

I have tried to bring up the system but there is a connection problem somewhere and an entry of the old host system.I can start the database vi DBMGUI without a problem.but now when i want to start it as SIDADM it fails.here are the logs:

dev_w0:

Tue Jan 8 08:43:42 2008

M *** ERROR => ThGwMon: unknown OPCODE 48 [thxxgmon.c 430]

M *** ERROR => ThGwMon: unknown OPCODE 48 [thxxgmon.c 430]

M *** ERROR => ThGwMon: unknown OPCODE 48 [thxxgmon.c 430]

M *** ERROR => ThGwMon: unknown OPCODE 48 [thxxgmon.c 430]

M *** ERROR => ThGwMon: unknown OPCODE 48 [thxxgmon.c 430]

M *** ERROR => ThGwMon: unknown OPCODE 48 [thxxgmon.c 430]

M *** ERROR => ThGwMon: unknown OPCODE 48 [thxxgmon.c 430]

M *** ERROR => ThGwMon: unknown OPCODE 48 [thxxgmon.c 430]

M *** ERROR => ThGwMon: unknown OPCODE 48 [thxxgmon.c 430]

M *** ERROR => ThGwMon: unknown OPCODE 48 [thxxgmon.c 430]

M

M Tue Jan 8 08:48:41 2008

M in_ThErrHandle: 1

M ThIErrHandle: I'm during shutdown

M Entering ThSetStatError

C CANCEL rejected, because there is no SQL statement active

M ThIErrHandle: don't try rollback again

M ThIErrHandle: normal shutdown

M

M Tue Jan 8 08:48:42 2008

M ThCallHooks: call hook >ASTAT-collect commit handling< for event BEFORE_COMMIT

M ThCallHooks: call hook >rsts_before_commit< for event BEFORE_COMMIT

M ThCallHooks: call hook >ThNoClearPrevErr< for event AFTER_COMMIT

M ThCallHooks: call hook >rsts_after_commit< for event AFTER_COMMIT

M ThCallHooks: call hook >SpoolHandleHook< for event AFTER_COMMIT

M ThCallHooks: call hook >ASTAT-collect commit handling< for event BEFORE_COMMIT

M ThCallHooks: call hook >rsts_before_commit< for event BEFORE_COMMIT

M ThCallHooks: call hook >ThNoClearPrevErr< for event AFTER_COMMIT

M ThCallHooks: call hook >rsts_after_commit< for event AFTER_COMMIT

M ThCallHooks: call hook >SpoolHandleHook< for event AFTER_COMMIT

M Entering ThReadDetachMode

M call ThrShutDown (1)...

B Disconnecting from ALL connections:

B Wp Hdl ConName ConId ConState TX PRM RCT Date Time DBHost

B 000 000 R/3 000000000 INACTIVE NO YES NO 20071222 195731 bpsdev1

B 000 001 BD1 000004401 INACTIVE NO NO NO 20071222 200323 bpsdev1

C Disconnecting from connection 0 ...

C 01: DB_001 *bdtdev1-*BD1, conn=1, since=20071222200323

C ABAP= SAPLSADB (11991)

C include= LSADBF02 (18)

C Now I'm disconnected from SAP DB

B Disconnected from connection 0

C Disconnecting from connection 1 ...

C

C Tue Jan 8 08:48:44 2008

C Now I'm disconnected from SAP DB

B Disconnected from connection 1

B statistics db_con_commit (com_total=216199, com_tx=59221)

B statistics db_con_rollback (roll_total=2798, roll_tx=0)

M ***LOG Q02=> wp_halt, WPStop (Workproc 0 1997) [dpuxtool.c 316]

bdtdev1 -

---

is my old hostname still appearing

2.trans.log

4 ETW000 [dev trc ,00000] Precompiler runtime is SAP DB 7.3.1.015 29 0.016028

4 ETW000 [dev trc ,00000] Try to connect (DEFAULT) on connection 0 ... 31 0.016059

4 ETW000 [dbslada. ,00000] *** ERROR => Connect to database failed : sqlcode=-709 (CONNECT: (database not accessible))

4 ETW000 246 0.016305

4 ETW000 [dblink ,00419] ***LOG BY2=>sql error -709 performing CON [dblink#1 @ 419]

4 ETW000 65 0.016370

4 ETW000 [dblink ,00419] ***LOG BY0=>CONNECT: (database not accessible) [dblink#1 @ 419]

4 ETW000 30 0.016400

2EETW169 no connect possible: "DBMS = ADABAS D --- DBNAME = ''"

any ideas welcome

[markus_doehr2]

Don´t use "vi" - use the program "xuser" (or x_user) to change the data.

Markus

[hannes_kuehnemund]

The commands are:

/path/to/xuser -U DEFAULT -u sap<sid>,<password> -d <SID> -n <hostname> -S SAPR3 -t 0 -I 0 set

/path/to/xuser -U c -u control,<password> -d <SID> -n <hostname> -S SAPR3 -t 0 -I 0 set

/path/to/xuser -U w -u superdba,<password> -d <SID> -n <hostname> -S SAPR3 -t 0 -I 0 set

I strongly recommend you to attend one of the MaxDB training courses provided by SAP University to get basic knowledge about MaxDB administration. The course ADM515 (MaxDB administration basics) fits very well.

Thanks,

Hannes