查看Oracle的数据库表命令

查看Oracle的数据库表命令

srvctl config database

该命令会列出所有配置的数据库实例信息。

示例输出:

Database unique name: orcl

Database name: orcl

Oracle home: /u01/app/oracle/product/19.3.0/dbhome_1

Oracle user: oracle

Spfile: +DATA/orcl/spfileorcl.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: orcl

Disk Groups: DATA,FRA

Mount point paths:

Services:

Type: RAC

Startup state: FORCE

2. 在 Windows 系统上

可以查看服务列表,在命令提示符中输入:

services.msc

相关创作