linux oracle实例名查看,Linux环境下oracle数库库改名，实例改名

Linux环境下oracle数库库改名，实例改名

SQL> select instance_name from v$instance; --查看当前实例名

INSTANCE_NAME

----------------

test

SQL> select name from v$database; --查看当前dbname

NAME

---------

TEST

SQL> shutdown immediate --关闭数据库

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 205520896 bytes

Fixed Size 1218532 bytes

Variable Size 67110940 bytes

Database Buffers 134217728 bytes

Redo Buffers 2973696 bytes

Database mounted.[@more@]SQL> host nid target=sys/test123 dbname=test2; --更改dbname

DBNEWID: Release 10.2.0.1.0 - Production on Wed Jul 21 16:31:20 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to database TESTORA (DBID