===========================================================
Exp時遭遇 EXP-00008 ORA-00942 EXP-00024 EXP-00000
===========================================================
Exp時遭遇 EXP-00008 ORA-00942 EXP-00024 EXP-00000
About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user QCSYSTEM
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user QCSYSTEM
EXP-00008: ORACLE error 942 encountered
ORA-00942: table or view does not exist
EXP-00024: Export views not installed, please notify your DBA
EXP-00000: Export terminated unsuccessfully
是沒有乾淨升級至9204所至!
重新咝衏atexp.sql 解決。
The export views are not correctly installed. Try doing this:
run following script:
1).Login in as sys user.
2).run the $ORACLE_HOME/rdbms/admin/catexp.sql file. This will recreate all your exp related views.
3).run the exp again.
This will resolve issue.
etzhang
发表于:2008.08.22 10:01
::分类:
(
系统
)
::阅读:(4次)
::
评论
(0)
===========================================================
Troubleshooting SCSI issues
===========================================================
To begin troubleshooting, check the following top issues. If your issue is listed, select the link, otherwise proceed to step 2.
- Check IBM ServerProven to ensure all options are compatible with your system.
- Refer to your system's Hardware Maintenance Manual for appropriate installation and removal instructions.
- Run diagnostics to test the hardware. If a failure is indicated, use the error code extension to isolate the cause. Complete SCSI device error codes are 12 characters long. The first eight characters of the SCSI error code are for device information - not error information. The error information is in the next four characters (error extension bytes). Failure to use the entire error code may result in incorrect FRU parts replacement.
- Read errors may be caused by a bad or interrupted write operation if the drive was bumped or power failed during the write operation (sector incompletely written).
- If only the data is corrupted, rewriting the data will correct the error.
- If the error occurs in the directory or the operating system's file structure, it may be necessary to perform a high-level format (Format C), or even to re-create the partition with FDISK.
- If the sector ID is corrupted (ID or Sector Not Found errors), an advanced diagnostic format should be attempted prior to replacement of the fixed disk. The advanced diagnostic format will re-write all sector addresses and data fields. When the format completes, the diagnostics should be re-run. If the diagnostics then run error-free, it is unlikely that a hardware failure has occurred.
- If failures return after a particular software application has been loaded, it could mean that the software is corrupting the fixed disk. Assistance should be sought from the appropriate software source. Failures may occur during system operation, yet diagnostics might run error-free. This could be due to improper termination (see below for more information on termination).
- Check all SCSI IDs. Each device must be set for a unique SCSI ID via jumpers, switches, or remotely with a cable-connected switch. Run 'Set and View SCSI Configuration' from the Configuration menu - to configure new or powered-off devices.
- Check that all devices are receiving power:
- Is the 'Power Good' (green) light illuminated on the system unit? 'Power Good' is more complex than a 'Power On' light. It indicates that the power supply is delivering all the correct dc output voltages within specifications (that is, +5 Vdc for logic circuits and +12 Vdc for motor circuits, though some SCSI fixed disks may also use +5 Vdc). Any missing or incorrect voltage will cause the system to shut down (self-protect).
- Is the power cable connected correctly (that is, not inverted)?
- Check whether any contacts have been inadvertently pushed back into the power cable connector. Examine all power cable connections and check whether any female contacts are distorted and thereby making intermittent contact. If so, reform them using the tip of a small screwdriver (or similar tool).
- Check that all other connections and cabling are correct:
- Ensure that the SCSI adapter is fully seated. Tension on the external SCSI interface cable may cause the SCSI adapter to partially unplug (unseat) from the system board. (Systems jammed against a wall are subject to this).
- Ensure both ends of all cables are firmly and properly seated.
- Check termination. It is critical that the SCSI Bus is terminated properly. The physical ends of the internal and external SCSI Bus must be terminated at the last device. Devices connected to the middle of the Bus MUST NOT BE TERMINATED.
- Terminator types include the following:
- Socketed DIP (Dual In-line Package) on the adapter
- Connector plug on the adapter's internal or external connector or cable
- Two or more socketed SIPs (Single In-line Packages) on a device
- In-line terminator attached between device and cable
- Enabled via a jumper
- The polarity of terminators must be correct:
- Pin 1 on DIPs and SIP are usually indicated by a dot or arrow
- Pin 1 on sockets are usually indicated by a 1, dot, or square solder pad
- For a SCSI device to 'come ready' and be configured, the following events must occur:
- Upon Power-on Reset, SCSI Post issues an Inquiry command to each SCSI address - to poll all devices present.
- All SCSI devices attached to the SCSI Bus must answer with their inquiry data.
- A Test Unit Ready command is issued to all devices that responded to the Inquiry command.
- If a hard disk drive answers 'Not Ready', a Start Unit command is then issued to sequentially start the drive (Motor Start). The devices must then run 'Self Test' and report their status.
- Once the drive is ready, the Read Device Capacity command is issued - to determine the device size for example 320MB, 1GB, etc).
- All responding devices are compared with the configuration data.
- Post beeps twice and displays errors if there are any new, missing, or defective SCSI devices.
- Following a successful Post (one beep), the system will attempt to load the operating system.
- If these steps have not solved your problem,
refer to your system's Hardware Maintenance Manual (HMM), or refer to "Need more help?"
Please select one of the the following options for further assistance:
Applicable countries and regions
Worldwide
Back to top
Document id: MIGR-50643
Last modified: 2007-09-05
Copyright © 2008 IBM Corporation
引自:https://www-304.ibm.com/systems/support/supportsite.wss/docdisplay?lndocid=MIGR-50643&brandind=5000019
etzhang
发表于:2008.05.14 14:47
::分类:
(
系统
)
::阅读:(32次)
::
评论
(0)
===========================================================
IBM Tapetool
===========================================================
The IBM Tapetool (tape-tool) contains diagnostic utilities and applications, device drivers, user's and operator's guides, hardware maintenance manuals, firmware and errata, and error log gathering routines for IBM tape drives, tape libraries, and tapeautoloaders.
Note: ibm_utl_tape_tapetool-1.08.25_anyos_noarch.iso - Tape tool version 1.08.25
MD5 checksum = 06cdc40050a07ba3d411bff2e980109e
查看全文
etzhang
发表于:2008.05.14 14:39
::分类:
(
系统
)
::阅读:(54次)
::
评论
(0)
===========================================================
Troubleshooting Hard drive (HDD) issues
===========================================================
Note: Diagnostics must be completed and any error codes or messages noted prior to hard disk drive replacement. Noisy drives are not always defective. Some are just inherently noisy. Compare noise levels against another identical drive with the same field replacement unit (FRU).
Data backup is an important part of any computer security program. Some of the procedures below may result in complete data loss. Make sure all important data has been backed up before continuing.
查看全文
etzhang
发表于:2008.05.14 14:22
::分类:
(
系统
)
::阅读:(77次)
::
评论
(0)
===========================================================
Troubleshooting ServeRAID controller issues
===========================================================
Note: ServeRAID controllers in cluster or fault-tolerant environments require additional troubleshooting techniques which are detailed in the User's Reference (SRAID.PDF) contained in the BOOKS directory of the ServeRAID Support CD.
查看全文
etzhang
发表于:2008.05.14 14:19
::分类:
(
系统
)
::阅读:(40次)
::
评论
(0)
===========================================================
ServeRAID mismatched software levels can result in system problems
===========================================================
Mismatched ServeRAID software levels can result in system problems. Mismatched version levels are not tested together and may result in stability problems when installed and used together for any significant period of time.
Symptoms might include, but are not limited to:
- Defunct Disk Drives (DDD)
- Erratic performance
- Loss of ServeRAID configuration
- POST error messages
- ServeRAID error messages
查看全文
etzhang
发表于:2008.05.14 14:12
::分类:
(
系统
)
::阅读:(65次)
::
评论
(0)
===========================================================
Troubleshooting POST error codes
===========================================================
This document is intended for trained servicers who are familiar with IBM Personal Computer products. Use this document along with advanced diagnostic tests to troubleshoot problems effectively. Before servicing an IBM product, be sure to review the safety information. Click here to review safety information.
查看全文
etzhang
发表于:2008.05.14 13:14
::分类:
(
系统
)
::阅读:(139次)
::
评论
(0)
===========================================================
Troubleshooting POST error codes
===========================================================
This document is intended for trained servicers who are familiar with IBM Personal Computer products. Use this document along with advanced diagnostic tests to troubleshoot problems effectively. Before servicing an IBM product, be sure to review the safety information. Click here to review safety information.
查看全文
etzhang
发表于:2008.05.14 13:14
::分类:
(
系统
)
::阅读:(22次)
::
评论
(0)
===========================================================
IBM ServeRAID software matrix
===========================================================
ServeRAID Manager | Latest release | Japanese version |
|---|
ServeRAID Application CD | | |
| Note: The ServeRAID Application CD does not support the ServeRAID MR controllers. For application support for these controllers, please use the ServeRAID MR Support CD. |
Integrated ServeRAID support | Latest release | Japanese version |
|---|
ServeRAID-8e |
|---|
SAS/SATA II hot-swap models | | |
| SATA II simple-swap models | | |
ServeRAID-7e |
|---|
SCSI (ServeRAID-7e) | | |
SATA (ServeRAID-7e) | | |
ServeRAID controller support | Latest release | Japanese version |
|---|
| SAS/SATA (ServeRAID-MR10i, MR10k, MR10M) | | N/A |
SAS/SATA (ServeRAID-8i, 8k, 8k-l, 8s) | | |
SCSI (ServeRAID-3L, 3H, 3HB, 4L, 4Lx, 4M, 4Mx, 4H, 5i, 6i, 6i+, 6m, 7k) | | |
SATA (ServeRAID-7t) | | |
Previous ServeRAID Software images | Previous release | Japanese version |
|---|
ServeRAID Support CD (Japanese) | N/A | |
IBM ServeRAID Support CD v6.11 (See RETAIN tip: H187621) | | N/A |
ServeRAID 64-bit Support CD for Itanium systems (xSeries 382, 450, 455) | | |
ServeRAID Support for I, II, 3L, 3H, 3HB controllers for PC Server and Netfinity 7000 | | N/A |
Document id: SERV-RAID
Last modified: 2008-04-16
Copyright © 2008 IBM Corporation
https://www-304.ibm.com/systems/support/supportsite.wss/docdisplay?lndocid=SERV-RAID&brandind=5000008
etzhang
发表于:2008.05.14 11:27
::分类:
(
系统
)
::阅读:(86次)
::
评论
(1)
===========================================================
ServeRAID disk drive error recovery
===========================================================
The demand for very large drive capacities has created the need to group many physical disks together in the form of arrays and logical drives. It is important to understand certain aspects of hard disk technology to understand the function of synchronization.
While a drive is in manufacturing, a set of low level tests is run against it to establish two internal sector lists. These tests create the "known good sectors" and the "known bad sectors" lists. The hard drive is then locked to their capacity by the firmware installed and defines which sectors become actively available. For example, a 36GB drive may actually accommodate 38GB of usable space. This extra space is listed in the NVRAM of the drive in another list called the "Known good reserved sectors". 查看全文
etzhang
发表于:2008.05.14 11:08
::分类:
(
系统
)
::阅读:(43次)
::
评论
(0)
===========================================================
Troubleshooting ServeRAID
===========================================================
To begin troubleshooting, check the following top issues. If your issue is listed, select the link, otherwise proceed to step 2.
What are Bad Stripe Table entries?
What are Bad Stripe Table (BST) limitations?
What are the conditions conducive to the appearance of bad stripes?
How to minimize the risk of bad stripes
How to maintain ServeRAID
How does an operating system react when it tries to read or write to a bad stripe?
How can Bad Stripes Table entries be removed from an Array/Logical Drive?
How to mitigate the existence of bad stripes on a logical drive
Frequently asked questions (FAQs)
查看全文
etzhang
发表于:2008.05.12 09:50
::分类:
(
系统
)
::阅读:(72次)
::
评论
(0)
===========================================================
制作rootvg镜像标准步骤
===========================================================
为什么要对rootvg做镜像
如果你的系统的rootvg仅有一块硬盘,当灾难来临的时候,例如硬盘损坏,这就意味着你的系统就再也不能启动了。尽管你可能拥有mksysb的磁带,但你仍然需要花费很多的时间去处理这个原本很小的问题。rootvg镜像能够提供单机bos容错,使得你能够用最短的时间摆脱这种困境,简单到只需要一次重新启动。
查看全文
etzhang
发表于:2007.08.01 15:48
::分类:
(
系统
)
::阅读:(152次)
::
评论
(2)
===========================================================
如何获得P5服务器HMC端口的IP地址
===========================================================
环境 平台: p520,p550,p570
问题: 一台非出厂配置参数的p5服务器, 由于不知道HMC端口的IP地址,现无法控制该服务器。用什么方法能知道原来的 HMC端口的IP地址?
查看全文
etzhang
发表于:2007.08.01 15:47
::分类:
(
系统
)
::阅读:(191次)
::
评论
(1)
===========================================================
RHEL4上安装oracle9i-9.2.0.4
===========================================================
1、默认安装RHEL4。
2、安装telnet与rsh服务,并设置。
3、安装系统所差的RPM。
查看全文
etzhang
发表于:2007.08.01 14:15
::分类:
(
系统
)
::阅读:(409次)
::
评论
(0)
===========================================================
oracle9.2.0在RHEL中建库使用裸设备
===========================================================
Oracle的RAC要求数据库建在裸设备上,在单机里也可以将库建在裸设备上,这样可以优化数据库性能。
下面操作在RHEL4上,Oracle为9.2.0.8。系统与数据库安装完成,数据库未建库。
查看全文
etzhang
发表于:2007.08.01 14:09
::分类:
(
系统
)
::阅读:(227次)
::
评论
(0)