topic Re: Please help !!! Oracle Datafile creation in Operating System - HP-UX

Please help !!! Oracle Datafile creation

Lynn_9 — Sat, 06 Apr 2002 02:24:55 GMT

In Windows2000, I tried to set up Oracle9i in one server, and create its datafile in another.
I map the second server hard driver into the first server. And I can create text file into this mappped driver. But Oracle setup always fails with "can not create" or "can not open" error message. Please help! Thanks!

Re: Please help !!! Oracle Datafile creation

harry d brown jr — Sat, 06 Apr 2002 03:13:49 GMT

Lynn,

Check the security permissions. And I'm not sure that having oracle on one server and the database sitting on another will actually work because the timing requirements for oracle are quite small.

live free or die
harry

Re: Please help !!! Oracle Datafile creation

T G Manikandan — Tue, 09 Apr 2002 01:59:34 GMT

Hello,
Please post the exact error message.
I assume the permissions on the drive where you are trying to create the datafile.

Thanks
G Manikandan

Re: Please help !!! Oracle Datafile creation

Printaporn_1 — Tue, 09 Apr 2002 06:09:05 GMT

THis is permission problem.
in control panel -> service at OracleService start this service with administrator ot user that have priviledge to map drive.
(default is SYSTEM in NT)

Re: Please help !!! Oracle Datafile creation

Volker Borowski — Tue, 09 Apr 2002 06:40:57 GMT

Oh, oh,

NEVER do this ! If you create/locate a datafile accross the network, just the drop of a single network package will lead to severe problems.

If you are lucky, it is immediately detected, and the datafile will go in to media-recovery state at once, which means you will be able to monitor this and start automatic recovery procedures at once, but it it takes a while to detect this drop, real restores of this datafile might be neccessary.

The only thing I can think of would be the use of a read-only tablespace.

Please buy an additional local disk.

Volker