Skip to main content

Search

Welcome to Tibero GTS!

Changing DBNAME and SID (Windows)

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

Caution
Please 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

Caution
To 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.
 

Service verification screen
Note
Reinstallation is required.
 
 
 

Related to