Database Administration (MOSC)

MOSC Banner

Can an ORACLE_SID contain an underscore?

edited Oct 7, 2013 4:32AM in Database Administration (MOSC) 10 commentsAnswered
All the documentation I can find says it can, but I have seen posts on the internet saying you can't. Also a colleague had a problem where he called a database XX_611 which would not work because Oracle thought it was RAC instance 611, and you can only have 255 (Or similar) rac instances. I also note that many Oracle supplied tools don't like having an underscore in the ORACLE_SID, notably the dbca where as the manual db creation accepts underscore.
Documentation I looked at includes:
http://docs.oracle.com/cd/E11882_01/install.112/e24321/rev_precon_db.htm#i1027493
Support doc ID: 239888.1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center