Home » Infrastructure » Linux » character datafile naming oracle 18c o1_mf_system dbf (Oracle 18c redhat 7.5)
character datafile naming oracle 18c o1_mf_system dbf [message #672701] Thu, 25 October 2018 01:58 Go to next message
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
Re: character datafile naming oracle 18c o1_mf_system dbf [message #672702 is a reply to message #672701] Thu, 25 October 2018 02:43 Go to previous messageGo to next message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, 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.
Re: character datafile naming oracle 18c o1_mf_system dbf [message #672710 is a reply to message #672701] Thu, 25 October 2018 06:22 Go to previous messageGo to next message
John Watson
Messages: 8075
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.
Re: character datafile naming oracle 18c o1_mf_system dbf [message #672711 is a reply to message #672701] Thu, 25 October 2018 06:23 Go to previous messageGo to next message
EdStevens
Messages: 1148
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.
Re: character datafile naming oracle 18c o1_mf_system dbf [message #672736 is a reply to message #672711] Thu, 25 October 2018 19:37 Go to previous messageGo to next message
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...
Re: character datafile naming oracle 18c o1_mf_system dbf [message #672743 is a reply to message #672736] Fri, 26 October 2018 03:01 Go to previous message
gazzag
Messages: 1082
Registered: November 2010
Location: Bristol, UK
Senior Member
TO be fair, as I recall, OMF is the default so don't be too hard on yourself Smile
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:
  


Current Time: Sun Dec 08 15:09:32 CST 2019