免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1901 | 回复: 3
打印 上一主题 下一主题

rman的一个问题。。求助 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2006-05-31 17:46 |只看该作者 |倒序浏览
平台AIX,oracle版本817,想做个测试,rman的
RMAN> create catalog tablespace rmantbs

RMAN-06099: error occurred in source file: krmk.pc, line: 6600
RMAN-06097: text of failing SQL statement: CREATE TABLE db
(
db_key          NUMBER NOT NULL,        -- sequence generated primary key
db_id           NUMBER NOT NULL,        -- kccfhdbi from controlfile
-- updatable columns
curr_dbinc_key  NUMBER,                 -- current incarnation
CONSTRAINT db_p  PRIMARY KEY (db_key),
CONSTRAINT db_u1 UNIQUE(db_id)          -- ensure that db_id is unique
)
tablespace rmantbs

RMAN-06004: ORACLE error from recovery catalog database: ORA-01658: unable to create INITIAL extent for segment in tablespace RMANTBS

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06433: error installing recovery catalog

论坛徽章:
0
2 [报告]
发表于 2006-05-31 19:37 |只看该作者
free space...

论坛徽章:
0
3 [报告]
发表于 2006-06-01 13:03 |只看该作者
谢谢,是空间问题

论坛徽章:
0
4 [报告]
发表于 2006-06-01 13:08 |只看该作者
不好意思,再多问题一个问题
$ rman target internal/oracle@lipz rcvcat rman/rman@rman
Recovery Manager: Release 8.1.7.0.0 - Production

RMAN-06005: connected to target database: LIPZ (DBID=2544989400)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-12154: TNS:could not resolve service name
该如何解决这个问题呢,因为只是个做备份软件这块的,所以对oracle不熟悉,请教一下,如果知道能写详细点吗,谢谢
listense.ora如下:
# LISTENER.ORA Network Configuration File: /oracle/app/oracle/product/8.1.7/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = IBM140)(PORT = 1521))
      )
    )
    (DESCRIPTION =
      (PROTOCOL_STACK =
        (PRESENTATION = GIOP)
        (SESSION = RAW)
      )
      (ADDRESS = (PROTOCOL = TCP)(HOST = IBM140)(PORT = 2481))
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = lipz.domain)
      (ORACLE_HOME = /oracle/app/oracle/product/8.1.7)
      (SID_NAME = lipz)
    )
  )

sqlnet.ora如下
# SQLNET.ORA Network Configuration File: /oracle/app/oracle/product/8.1.7/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
#SQLNET.AUTHENTICATION_SERVICES= (NTS)


tnsnames.ora如下:

# TNSNAMES.ORA Network Configuration File: /oracle/app/oracle/product/8.1.7/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LIPZ =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.10.140)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = lipz.domain)
    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IBM140)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = lipz.domain)
      (PRESENTATION = http://admin)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP