Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

0

积分

0

好友

3

主题
1#
发表于 2015-2-6 17:02:38 | 查看: 2032| 回复: 0
SQL> startup nomount force
ORACLE instance started.

Total System Global Area  780824576 bytes
Fixed Size                    2257312 bytes
Variable Size                  511708768 bytes
Database Buffers          264241152 bytes
Redo Buffers                    2617344 bytes
SQL> show parameter password

NAME                                     TYPE
------------------------------------ ----------------------
VALUE
------------------------------
remote_login_passwordfile             string
EXCLUSIVE

listener配置:
[oracle@dba admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
   (DESCRIPTION_LIST =
     (DESCRIPTION =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.71)(PORT = 1521))
     )
   )

ADR_BASE_LISTENER = /u01/app/oracle


SID_LIST_LISTENER=
(SID_LIST=
   (SID_DESC=
    (GLOBAL_DBNAME=lofe)
    (ORACLE_HOME=/u01/app/oracle/product/11.2.4/)
    (SID_NAME=lote)
    )
   (SID_DESC=
    (GLOBAL_DBNAME=rman)
    (ORACLE_HOME=/u01/app/oracle/product/11.2.4/)
    (SID_NAME=calog)
    )

)

[oracle@dba admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.4/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL_1.51 =
   (DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 196.128.1.51)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SERVICE_NAME = orcl)
     )
   )

lofe =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.71)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = lofe)
     )
   )

lote =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.71)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = lote)
     )
   )

LOFE1 =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.71)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = lofe)
     )
   )

CALOG =
   (DESCRIPTION =
     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.71)(PORT = 1521))
     (CONNECT_DATA =
       (SERVER = DEDICATED)
       (SERVICE_NAME = calog)
     )
   )

[oracle@dba dbs]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-FEB-2015 16:58:41

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.71)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                06-FEB-2015 16:55:52
Uptime                    0 days 0 hr. 2 min. 49 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.2.4/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/dba/listener/alert/log.xml
Listening Endpoints Summary...
   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.71)(PORT=1521)))
Services Summary...
Service "calog" has 1 instance(s).
   Instance "calog", status READY, has 1 handler(s) for this service...
Service "calogXDB" has 1 instance(s).
   Instance "calog", status READY, has 1 handler(s) for this service...
Service "lofe" has 1 instance(s).
   Instance "lote", status UNKNOWN, has 1 handler(s) for this service...
Service "lote" has 1 instance(s).
   Instance "lote", status BLOCKED, has 1 handler(s) for this service...
Service "rman" has 2 instance(s).
   Instance "calog", status UNKNOWN, has 1 handler(s) for this service...
   Instance "calog", status READY, has 1 handler(s) for this service...
The command completed successfully

[oracle@dba dbs]$ sqlplus sys/oracle@lote as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Fri Feb 6 16:48:52 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name: sys@lote as sysdba
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified


Enter user-name: sys@lofe as sysdba
Enter password:

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

SQL> exit

状态阻塞是什么问题啊??
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 20:50 , Processed in 0.047744 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569