[askdba] Re: Oracle ODM AIX

  • From: "Pepling, Todd C." <tpepling@xxxxxxx>
  • To: "'askdba@xxxxxxxxxxxxx'" <askdba@xxxxxxxxxxxxx>
  • Date: Fri, 3 Dec 2004 10:24:47 -0500

I don't believe 8.0.5 had ODM, thus it's not neither an AIX issue nor an ODM
issue.

> -----Original Message-----
> From: askdba-bounce@xxxxxxxxxxxxx 
> [mailto:askdba-bounce@xxxxxxxxxxxxx]On
> Behalf Of Patricia Eyenga
> Sent: Friday, December 03, 2004 10:00 AM
> To: askdba@xxxxxxxxxxxxx
> Subject: [askdba] Re: Oracle ODM AIX
> 
> 
> 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/orap
> wIBMPRDDB0
> > 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/orap
> wIBMPRDDB0
> > 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.
> 
> 
> 
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: