OraFAQ Forum: Linux » character datafile naming oracle 18c o1_mf

Home » Infrastructure » Linux » character datafile naming oracle 18c o1_mf_system dbf (Oracle 18c redhat 7.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

character datafile naming oracle 18c o1_mf_system dbf [message #672701]

Thu, 25 October 2018 01:58

greensea
Messages: 2
Registered: October 2018

Junior Member

Dear

Please help, i try install and create database with oracle 18c in Red Hat 7.5.
I have problem, why datafile naming used random character for example o1_mf_system_fx2s9p5f_.dbf?
where configuration for naming datafile without random character?

Best regards,
Setiadi

Report message to a moderator

Re: character datafile naming oracle 18c o1_mf_system dbf [message #672702 is a reply to message #672701]

Thu, 25 October 2018 02:43

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Did you use DBCA to create your database? You obviously elected to use Oracle Managed Files while creating your database. You must specify "file system" and select which directory you want to use.

Report message to a moderator

Re: character datafile naming oracle 18c o1_mf_system dbf [message #672710 is a reply to message #672701]

Thu, 25 October 2018 06:22

John Watson
Messages: 9005
Registered: January 2010
Location: Global Village

Senior Member

Don't worry about it! I always use Oracle Managed Files, unless there is some show-stopping reason not to. OMF makes your life immeasurably easier.

Report message to a moderator

Re: character datafile naming oracle 18c o1_mf_system dbf [message #672711 is a reply to message #672701]

Thu, 25 October 2018 06:23

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

As gazzag said, you obviously told dbca to use 'oracle managed files' when you created the database. That means, among other things, that Oracle names the files the way he wants. If you want to manage the files yourself, including naming them to your own standards, then don't use Oracle Managed Files (aka "OMF").

If you do want the benefits of OMF, then you have to let oracle name the files to his standards, not yours.

Report message to a moderator

Re: character datafile naming oracle 18c o1_mf_system dbf [message #672736 is a reply to message #672711]

Thu, 25 October 2018 19:37

greensea
Messages: 2
Registered: October 2018

Junior Member

Thanks for the clue, your are right, i selected OMF, I shoudnt select OMF.
Thank you very much...

Report message to a moderator

Re: character datafile naming oracle 18c o1_mf_system dbf [message #672743 is a reply to message #672736]

Fri, 26 October 2018 03:01

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

TO be fair, as I recall, OMF is the default so don't be too hard on yourself Smile

Report message to a moderator

Previous Topic:	Can i686 linux library replace i386 linux library when installing Oracle database server 11gr2?
Next Topic:	ORA-01994: GRANT failed: password file missing or disabled

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 03 04:54:44 CDT 2026