查询oracle数据库实例的名字

dc-test2<oracle>sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Feb 25 22:44:25 2010

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> conn / as sysdba
Connected.
SQL> define
DEFINE _DATE           = "25-FEB-10" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "jttestdb1" (CHAR)
DEFINE _USER           = "SYS" (CHAR)
DEFINE _PRIVILEGE      = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1002000400" (CHAR)
DEFINE _EDITOR         = "ed" (CHAR)
DEFINE _O_VERSION      = "Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options" (CHAR)
DEFINE _O_RELEASE      = "1002000400" (CHAR)
SQL>

 

红色字体部分即为数据库实例名字