oracle中x_name知多少.pdf
40墨值下载
warehouse
warehouse warehouse
warehouse 客栈
客栈客栈
客栈
msn:xys_666888@hotmail.com
个人简介
个人简介个人简介
个人简介！
！！
！
1 db_name
SQL> connect xys/manager as sysdba
SQL> show user
USER "SYS"
SQL> show parameter db_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name string test1
db_name oracle
db_name controlfile datafile_header,redo db_name
1 controlfile, reseglogs 2 nid
db_name 8 10g
8
db_name
SQL> desc v$database;
?
----------------------------------------- -------- ------------------------
DBID NUMBER
NAME VARCHAR2(9)
SQL>
db_name db_name
service_name, service_name pmon
db_name
SQL> host lsnrctl status
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 03-12 -2007 10:1
9:36
Copyright (c) 1991, 2005, Oracle. All rights reserved.
(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER STATUS
------------------------
LISTENER
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
03-12 -2007 09:29:47
0 0 49 50
off
ON: Local OS Authentication
SNMP OFF
e:\oracle\product\10.2.0\db_1\network\log\listener.log
...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xys)(PORT=1521)))
..
"TEST2.COM" 1
"inst_test", READY, 1 ...
"TEST3.COM" 1
"inst_test", READY, 1 ...
"test1.COM" 1
"inst_test", READY, 1 ...
"test1_XPT.COM" 1
"inst_test", READY, 1 ...
SQL> show parameter service_names
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string TEST2, TEST3
service_names TEST2, TEST3 lsnrctl status
"test1.COM" 1
"inst_test", READY, 1 ...
2 instnace_name
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
of 10
40墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论