- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: add raw device as datafile to Oracle on HP-UX
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
тАО03-16-2004 07:49 AM
тАО03-16-2004 07:49 AM
add raw device as datafile to Oracle on HP-UX
ALTER TABLESPACE
And Oracle automatically figured out how large the raw device was, and added it as a datafile accordingly.
But this doesn't seem to work on HP-UX. When I used the same type of statement (cNtNdN, without the s2), I get an error:
00010: ORA-01257: cannot reuse database file /dev/rdsk/c7t0d7, unknown file size
How do I get Oracle to figure out how large the raw device is on HP-UX? Or how do I add a raw device as datafile in this case?
Thanks,
Nina
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2004 07:57 AM
тАО03-16-2004 07:57 AM
Re: add raw device as datafile to Oracle on HP-UX
You are attempting to use the disk directly.
Can't do that.
You have to do this:
#my example assumes vg02 is the oracle one
lvcreate -C y /dev/vg02 a new logical volume this will give you a name
lvextend -L
The lxextend command says extend this logical volume to size whatever on disk whatever.
Then go to /dev/vg02 and change ownership with chown to oracle:dba or whatever id and group the oracle binaries are owned by.
Now you can use sqlplus to bring the data container online.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2004 08:08 AM
тАО03-16-2004 08:08 AM
Re: add raw device as datafile to Oracle on HP-UX
OK, so I need to wrap the device in a volume. But how do I add the volume as a datafile to Oracle?
I tried this before:
ALTER TABLESPACE
And it gives me an error saying:
ORA-01119: error in creating database file '/dev/ninadg/vol1'
ORA-27038: skgfrcre: file exists
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2004 08:15 AM
тАО03-16-2004 08:15 AM
Re: add raw device as datafile to Oracle on HP-UX
Finally, unless this is Oracle RAC, you just might find that there is no advantage to using raw vs cooked i/o.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-16-2004 08:48 AM
тАО03-16-2004 08:48 AM
Re: add raw device as datafile to Oracle on HP-UX
Thanks!!!
We'll have to re-evaluate to see if we really want to implement this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-22-2004 08:53 AM
тАО03-22-2004 08:53 AM