oracle组件

目前在用的三个oracle版本

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options

监听器

[oracle@localhost ~]$ lsnrctl

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 13-JUL-2015 09:26:22

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 111: Connection refused
LSNRCTL> start
Starting /u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                13-JUL-2015 09:27:41
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost.localdomain)(PORT=1521)))
The listener supports no services
The command completed successfully
LSNRCTL>

监听日志
[oracle@localhost log]$ ls
sqlnet.log
[oracle@localhost log]$ pwd
/u01/app/oracle/product/11.2.0/dbhome_1/network/log

css服务

[grid@rac02 ~]$ crsctl check css    css服务没启动
CRS-4530: Communications failure contacting Cluster Synchronization Services daemon
[grid@rac02 ~]$ ps -ef|grep cssd    没有css进程
果然没有CSS的服务daemon进程,再看一下HAS(High Availability Service)的状态
[grid@rac02 ~]$ crsctl check has    has服务是启动的
CRS-4638: Oracle High Availability Services is online
[grid@rac02 ~]$ ps -ef|grep d.bin
root      8505     1  0 11:36 ?        00:00:03 /u01/app/11.2.0/grid/bin/ohasd.bin reboot
root      8763     1  0 11:36 ?        00:00:04 /u01/app/11.2.0/grid/bin/orarootagent.bin
root      9581     1  0 11:40 ?        00:00:50 /u01/app/11.2.0/grid/bin/cssdmonitor
grid     13033     1  0 12:05 ?        00:00:01 /u01/app/11.2.0/grid/bin/oraagent.bin
grid     13048     1  0 12:05 ?        00:00:15 /u01/app/11.2.0/grid/bin/evmd.bin
root     15277     1  0 15:22 ?        00:00:00 /u01/app/11.2.0/grid/bin/crsd.bin reboot
grid     15950 13914  0 15:24 pts/11   00:00:00 grep d.bin
[grid@rac02 ~]$ crs_stat -t        进一步查看各资源的状态
CRS-0184: Cannot communicate with the CRS daemon.
[root@rac02 bus]# find / -name crsd.log    查看CRS日志
[root@rac02 bus]# less /u01/app/11.2.0/grid/log/rac02/crsd/crsd.log

组件

查看各组件及版本
SQL> set linesize 800
SQL> set pagesize 100
SQL> column product format A40
SQL> column version format A20
SQL> column status format A20
SQL> select * from product_component_version;

PRODUCT                                  VERSION              STATUS
---------------------------------------- -------------------- --------------------
NLSRTL                                   11.2.0.1.0           Production
Oracle Database 11g Enterprise Edition   11.2.0.1.0           64bit Production
PL/SQL                                   11.2.0.1.0           Production
TNS for Linux:                           11.2.0.1.0           Production

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

SQL> select * from v$option;

PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Partitioning                                                     TRUE
Objects                                                          TRUE
Real Application Clusters                                        FALSE
Advanced replication                                             TRUE
Bit-mapped indexes                                               TRUE
Connection multiplexing                                          TRUE
Connection pooling                                               TRUE
Database queuing                                                 TRUE
Incremental backup and recovery                                  TRUE
Instead-of triggers                                              TRUE
Parallel backup and recovery                                     TRUE
Parallel execution                                               TRUE
Parallel load                                                    TRUE
Point-in-time tablespace recovery                                TRUE
Fine-grained access control                                      TRUE
Proxy authentication/authorization                               TRUE
Change Data Capture                                              TRUE
Plan Stability                                                   TRUE
Online Index Build                                               TRUE
Coalesce Index                                                   TRUE
Managed Standby                                                  TRUE
Materialized view rewrite                                        TRUE
Materialized view warehouse refresh                              TRUE
Database resource manager                                        TRUE
Spatial                                                          TRUE
Automatic Storage Management                                     FALSE
Export transportable tablespaces                                 TRUE
Transparent Application Failover                                 TRUE
Fast-Start Fault Recovery                                        TRUE
Sample Scan                                                      TRUE
Duplexed backups                                                 TRUE
Java                                                             TRUE
OLAP Window Functions                                            TRUE
Block Media Recovery                                             TRUE
Fine-grained Auditing                                            TRUE
Application Role                                                 TRUE
Enterprise User Security                                         TRUE
Oracle Data Guard                                                TRUE
Oracle Label Security                                            FALSE
OLAP                                                             TRUE
Basic Compression                                                TRUE
Join index                                                       TRUE
Trial Recovery                                                   TRUE
Data Mining                                                      TRUE
Online Redefinition                                              TRUE
Streams Capture                                                  TRUE
File Mapping                                                     TRUE
Block Change Tracking                                            TRUE
Flashback Table                                                  TRUE
Flashback Database                                               TRUE
Transparent Data Encryption                                      TRUE
Backup Encryption                                                TRUE
Unused Block Compression                                         TRUE
Oracle Database Vault                                            FALSE
Result Cache                                                     TRUE
SQL Plan Management                                              TRUE
SecureFiles Encryption                                           TRUE
Real Application Testing                                         TRUE
Flashback Data Archive                                           TRUE
DICOM                                                            TRUE
Active Data Guard                                                TRUE
Server Flash Cache                                               TRUE
Advanced Compression                                             TRUE
XStream                                                          TRUE
Deferred Segment Creation                                        TRUE

65 rows selected.

oracle组件

标签：