- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: ORA-01110, 01115, 27072 during database startu...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2003 12:12 AM
тАО02-10-2003 12:12 AM
Re: ORA-01110, 01115, 27072 during database startup
I have attached the log file..
rgds
nainesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2003 12:28 AM
тАО02-10-2003 12:28 AM
Re: ORA-01110, 01115, 27072 during database startup
existent device(file system)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2003 12:41 AM
тАО02-10-2003 12:41 AM
Re: ORA-01110, 01115, 27072 during database startup
This was working fine for sometime...if the files didn't
exist oracle wouln't have started at all..And believe me this filesystem exists..with the exact structure and permissions..I have tested this file system for read/write operations and its working fine..There is ample space in this filesystem and all the filesystems on this volumegroup..
I guess i have to wait for our server support guys to come and take a look..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2003 02:04 AM
тАО02-10-2003 02:04 AM
Re: ORA-01110, 01115, 27072 during database startup
I would like you to check the /var/adm/syslog/syslog.log file for any errors on the disk or file system corruptions.
Please revert on the same.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2003 02:58 AM
тАО02-10-2003 02:58 AM
Re: ORA-01110, 01115, 27072 during database startup
I have attached the syslog.log file ..Please take a look
rgds
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2003 04:14 AM
тАО02-10-2003 04:14 AM
Re: ORA-01110, 01115, 27072 during database startup
If you are running a new system then you should check the scsi cables and the termination.
If you had the system running fine for sometime it should be mostly a problem with a bad drive.
Looks lik e
bus0==c0
ssid=0a=10 on the bus
Looks like c0t10d0 is creating problems.
Just do a pvdisplay on the device.If it is not okay then it should show "stale" in the output.
#pvdisplay -v /dev/dsk/c0t10d0
//It is time to launch a call to HP and not Oracle//
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2003 05:17 AM
тАО02-10-2003 05:17 AM
Re: ORA-01110, 01115, 27072 during database startup
pvdisplay is not showing any stale PE's. I know now that this is not an oracle problem..its pure hardware related. The filesystem has got corrupt which is mounted on Volume group vg03 and the device is c0t8d0..Its the same what we replaced last week..i guess its bad luck that the new disk is creating the same problem..Anyways i have logged the call with hp and am expecting someone to come anytime now..
thanx all of you for good inputs..
rgds
nainesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-10-2003 08:51 PM
тАО02-10-2003 08:51 PM
Re: ORA-01110, 01115, 27072 during database startup
For the error ORA-27052 try this
Set these two values in your init
DISK_ASYNCH_IO = FALSE
DBWR_IO_SLAVES = 0
and restart the database for the chages to be effective, anf then check the alert log for error message if they still appear.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-11-2003 03:18 PM
тАО02-11-2003 03:18 PM
Re: ORA-01110, 01115, 27072 during database startup
eg. /s04/acuchis/dat/seatf.xdf : no such device or address........
Tell me, as a test, can you change permissions and ownership of, say, '/oracle/D02/origlogB/log_g14m1.dbf' (or one of your problem files) to something else? Then change it back? Does this test give you a "No such device...." error?
If it does give an error - then you've got a logical file error, and will have to recreate or restore from backup. The gottcha is, in anycase, I think your going to have to drop the logical volume and recreate it to get around this one (that's what I had to end up doing :-( )
- « Previous
-
- 1
- 2
- Next »