oracle运维工作总结,oracle运维（1）

LISTENER

=

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY =racdb1))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.10)(PORT =

1521))

)

)

ADR_BASE_LISTENER = /u01/app/oracle

SID_LIST_LISTENER=

(SID_LIST=

(SID_DESC=

#BEQUEATH

CONFIG

(GLOBAL_DBNAME=racdb1)

(SID_NAME=racdb1)

(ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)

#PRESPAWN CONFIG

(PRESPAWN_MAX=20)

(PRESPAWN_LIST=

(PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=2)(TIMEOUT=1))

)

)

)

GLOBAL_DBNAME=racdb1

Service 名称，在客户端一定配置和他相同

SID_NAME=racdb1

实例名称，这个要和SID相同

GLOBAL_DBNAME可以不等于SID_NAME

客户端根据tnsname.ora中的SERVICE_NAME和地址(ADDRESS = (PROTOCOL =

TCP)(HOST =racdb1)(PORT = 1521))，到这个地址去访问监听器。然后监听器根据文件lisnter.ora文件中的GLOBAL_NAME来判断是否有一个

GLOBAL_DBNAME 和 SERVICE_NAME 相等。如果相等，则建立客户端到SID标识的服务端实例的连接,在客户端上我们可以使用tnsping 命令来测试

1.2.

客户端tnsnames

racdb1 =

(description =

(address_list =

(address = (protocol = tcp)(host = 192.168.137.10)(port = 1521))

)

(connect_data =

(service_name =racdb1)(ur=a)

)

)

这里的service_name

=racdb1 就是在服务器端的GLOBAL_DBNAME=racdb1

[oracle@racdb1 ~]$ tnsping racdb1

TNS Ping Utility for Linux: Version 11.2.0.1.0 -

Production on 21-JAN-2015 14:51:49

Copyright (c) 1997, 2009,

Oracle. All rights reserved.

TNS-03502: Insufficient

arguments. Usage: tnsping

[]

[oracle@racdb1 ~]$ tnsping racdb1

TNS Ping Utility for Linux: Version 11.2.0.1.0 -

Production on 21-JAN-2015 14:51:55

Copyright (c) 1997, 2009,

Oracle. All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the

alias

Attempting to contact (description = (address_list

= (address = (protocol = tcp)(host = racdb1)(port = 1521)))

(connect_data = (service_name = racdb1)(ur=a)))

OK (0 msec)

1.3.

检查Oracle Listener

lsnrctl stop

lsnrctl start

lsnrctl status

lsnrctl service

默认情况下我们oracle

安装好后是使用操作系统用户的验证,所以这里如果我们使用sys用户不用密码就可以登录,如果我们想使用oracle 密码文件验证的话我们就要进入下列文件夹

cd

/u01/app/oracle/product/11.2.0/dbhome_1/network/admin修改sqlnet.ora

增加下列命令

SQLNET.AUTHENTICATION_SERVICES = NONE

[oracle@racdb1 ~]$ sqlplus scott/111111@racdb1

sqlplus

/nolog

使用scott登陆到指定数据库racdb1

conn

sys/111111@racdb1 AS SYSDBA;

察看登陆到了哪个数据库实例

select

instance_name from v$instance

使用sys用户登陆

conn

sys/change_on_installer as sysdba

用sysdba

登陆

conn /as

sysdba

使用sys用户登录

conn

sys/change_on_install as sysdba;

conn / as

sysdba 连接数据库

conn

scott/111111 使用scott进行连接