Document Type | Technical Information
Category | Administration
Applicable Product Versions | 6FS07, 7FS02
Document Number | TADTI024
Overview
This guide explains how to change the DBNAME and SID values when using Tibero Windows binaries and a situation arises where these values must be changed.
Method
CautionPlease note that the example paths may vary depending on your environment.
1. Stop the DB
Run cmd as administrator.
C:\Windows\system32>tbdown immediate Tibero instance terminated (IMMEDIATE mode).
2. Start DB in mount mode
C:\Windows\system32> tbboot mount C:\Windows\system32> tbsql sys/tibero SQL> alter database rename to "tibero"; SQL> exit
3. Stop the DB
C:\Windows\system32>tbdown immediate
4. Delete Tibero registration information
C:\Windows\system32> cd C:\tibero6\bin C:\tibero6\bin> tbuninstall.vbs After input, select 'Open' Microsoft (R) Windows Script Host Version 5.812 Copyright (C) Microsoft Corporation. All rights reserved. Warning: TB_SID is not provided. TB_SID [DPWFMS] will be used. TB_HOME = C:\tibero6 TB_SID = DPWFMS service name = Tibero_DPWFMS Tibero_DPWFMS uninstalled successfully.
5. Modify environment variables
Modify the TB_SID value in Advanced System Settings > Environment Variables.
This variable was changed for both user variables and system variables.
- Previous: TB_SID=DPWFMS
- New: TB_SID=tibero
6-1. Open the *.tip file, modify the DB_NAME value, and save (C:\tibero6\config\DPWFMS.tip)
- Previous: DB_NAME=DPWFMS
- New: DB_NAME=tibero
6-2. Rename the file
- Previous: C:\tibero6\config\DPWFMS.tip
- New: C:\tibero6\config\tibero.tip
7. Open the tbdsn.tbr file, modify the connection information, and save (C:\tibero6\client\config\tbdsn.tbr)
- Previous
DPWFMS=(
(INSTANCE=(HOST=localhost)
(PORT=8629)
(DB_NAME=DPWFMS)
)
)- Changed
tibero=(
(INSTANCE=(HOST=localhost)
(PORT=8629)
(DB_NAME=tibero)
)
)
8. Run tbinstall.vbs
CautionTo apply environment variable changes, you must run cmd as administrator in a new window.
C:\Windows\system32> cd C:\tibero6\bin C:\tibero6\bin>echo %TB_SID% tibero C:\tibero6\bin>tbinstall.vbs %TB_HOME% %TB_SID% Microsoft (R) Windows Script Host Version 5.812 Copyright (C) Microsoft Corporation. All rights reserved. TB_HOME = C:\tibero6 TB_SID = tibero Service Name = Tibero_tibero service account = LocalSystem Tibero_tibero installed successfully.
9. Start Tibero and verify
Run cmd as administrator and verify that Tibero starts normally.
C:\tibero6\bin>tbboot Tibero 6 TmaxData Corporation Copyright (c) 2008-. All rights reserved. Tibero instance started up (NORMAL mode). C:\tibero6\bin>tbsql sys/tibero SQL> select name from v$database; NAME ---------------------------------------- tibero 1 row selected. SQL> select instance_name, status from v$instance; INSTANCE_NAME STATUS ---------------------------------------- ---------------- tibero NORMAL 1 row selected.
10. Verify the service
Check the status of the service in Control Panel > Administrative Tools > Services.
NoteReinstallation is required.