[askdba] Re: Oracle ODM AIX

  • From: "Patricia Eyenga" <patricia.e@xxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>
  • Date: Fri, 3 Dec 2004 10:00:06 -0500

I'm just wondering if it's an ODM issue or an AIX issue.  I suppose I =
could
do as you suggest, but would also like to know it this is ODM-related or =
not

-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx] =
On
Behalf Of Pepling, Todd C.
Sent: Friday, December 03, 2004 9:06 AM
To: 'askdba@xxxxxxxxxxxxx'
Subject: [askdba] Re: Oracle ODM AIX


This was standard for Oracle 8.0.5 on WinNT 4.0.  I always created the =
DB
first w/ remote_login_passwordfile=3Dnone, then created the password =
file,
then changed remote_login_passwordfile=3Dexclusive, then bounced the DB.

Is there a reason you can't do this?

> -----Original Message-----
> From: askdba-bounce@xxxxxxxxxxxxx
> [mailto:askdba-bounce@xxxxxxxxxxxxx]On
> Behalf Of Patricia Eyenga
> Sent: Friday, December 03, 2004 8:58 AM
> To: askdba@xxxxxxxxxxxxx
> Subject: [askdba] Oracle ODM AIX
>=20
>=20
> Is anyone out there using Oracle 9i with ODM (we're on AIX,
> but I'm not sure
> this problem would be limited to AIX)...
> =20
> The issue we're having is that setting the
> remote_login_passwordfile to
> anything other than 'NONE' generates the following error when=20
> creating the
> DB:
> ORA-01501: CREATE DATABASE failed
> ORA-00600: internal error code, arguments: [ksfd_odmopn2], [ODM ERROR
> V-41-4-19 No such device], [], [], [], [], [], []
> Error 600 happened during db open, shutting down database=20
> USER: terminating instance due to error 600
> =20
> I also see the following in the trace file:=20
> =
ksfdopn:fname=3D/u01/ARBPRDDB/app/oracle/product/9205/dbs/orapwIBMPRDDB0
> blksiz=3D512 ftype=3D8 flags=3D0x0 ps=3D0x0 fno=3D0=20
> ksfd_odmopn:fname=3D/u01/ARBPRDDB/app/oracle/product/9205/dbs/or
> apwIBMPRDDB0
> blksiz=3D512 ftype=3D8 flags=3D0x0 ps=3D0xe43656a0 fno=3D0=20
> ksfd_fibd:fib=3D0xe3d2abe0 flags=3D0x0
> *** 2004-12-02 22:24:35.511
> ksedmp: internal or fatal error
> ORA-00600: internal error code, arguments: [ksfd_odmopn2], [ODM ERROR=20
> V-41-4-19 No such device], [], [], [], [], [], []
> =20
> =20
> although at the beginning of the create statement the
> following succeeds:
> =
ksfdopn:fname=3D/u01/ARBPRDDB/app/oracle/product/9205/dbs/orapwIBMPRDDB0
> blksiz=3D512 ftype=3D8 flags=3D0x0 ps=3D0x0 fno=3D0=20
> ksfdopn: fob=3D0xe705d098 fib=3D0xe3d29b78=20
>=20
> =20
> Anyone have any clue?
>=20
>=20
>=20
This email and any files transmitted with it are confidential and =
intended
solely for the use of the individual or entity to whom they are =
addressed.
If you have received this email in error please notify the system =
manager.
This message contains confidential information and is intended only for =
the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail.



Other related posts: