oracle tnsping命令
1、测试数据库服务的命令:
控制台 tnsping命令 IP地址
端口号 数据库服务名称
cmd->tnsping 192.168.1.123:1521/oracle10g
tnsping命令:如果能够ping通,则说明客户端能解析listener的机器名,而且lister也已经启动,但是并不能说明数据库已经打开,而且tsnping的过程与真正客户端连接的过程也不一致。但是如果不能用tnsping通,则肯定连接不到数据库。
2、查看服务配置的ora文件路径
E:\database\oracle\user\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora
文件内容形如:
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.1.123)
(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
3、使用sql*plus查询数据库
b、查询所有的表空间:select * from v$tablespace;
TS#
NAME
INC BIG FLA E
---------- ------------------------------ --- --- --- -
0 SYSTEM
YES NO
YES
1 UNDOTBS1
YES NO
YES
2 SYSAUX
YES NO
YES
4 USERS
YES NO
YES
3 TEMP
NO
NO
YES
c、查询默认的表空间:
SQL> col property_name for a10
SQL> col property_value for a10
SQL> col descrpition for a10
SQL> select * from database_propertie where property_name='DEFULT_PERMANENT_TABLESPACE';
d、查询所有用户:
select * from dba_users;
e、查询符合某些条件的用户:
select * from dba_users where username like 'ABC%';
注:sql*plus中的条件参数有大小写的区分,
例如“where property_name='DEFULT_PERMANENT_TABLESPACE';”和“username like 'ABC%'”,需要与数据库中的一致。
转自:http://jerry-chen.iteye.com/blog/1028530
OCP试题
Your
tnsnames.ora
file
has
the
following
entry
for
the
service
alias
ORCL:
ORCL =
( DESCRIPTION
=
(ADDRESS =
(PROTOCOL
=
TCP)(HOST
=
10.156.24.216)(PORT
=
1521))
(CONNECT_DATA =
(SERVER =
DEDICATED)
(SERVICE_NAME =
orcl.oracle.com)
)
)
The TNSPING
command
executes
successfully
when
tested
with
ORCL
but
you
are
not
able
to
connect
to the
database
instance
with
the
following
command:
SQL> CONNECT
scott/tiger@orcl
What could
be
the
reason
for
this?
A. The
listener
is
not
running
at
the
server.
B. The
TNS_ADMIN
environmental
variable
is
set
to
a
wrong
value.
C. The
orcl.oracle.com
database
service
is
not
registered
with
the
listener.
D. The
DEFAULT_DOMAIN
parameter
is
set
to
a
wrong
value
in
the
SQLNET.ORA
file.
Answer: C
1、测试数据库服务的命令:
tnsping命令:如果能够ping通,则说明客户端能解析listener的机器名,而且lister也已经启动,但是并不能说明数据库已经打开,而且tsnping的过程与真正客户端连接的过程也不一致。但是如果不能用tnsping通,则肯定连接不到数据库。
2、查看服务配置的ora文件路径
3、使用sql*plus查询数据库
注:sql*plus中的条件参数有大小写的区分,
例如“where property_name='DEFULT_PERMANENT_TABLESPACE';”和“username like 'ABC%'”,需要与数据库中的一致。
转自:http://jerry-chen.iteye.com/blog/1028530
OCP试题
ORCL
(
(ADDRESS
(CONNECT_DATA
(SERVER
(SERVICE_NAME
)
)
The
to
SQL>
What
A.
B.
C.
D.
Answer: