Skip to main content
commvault.com commvault.com
Question

Oracle database name longer than 8 letters

  • May 16, 2024
  • 2 replies
  • 188 views
T
Explorer
Forum|alt.badge.img+10

Hello,

we have a problem to configure a RAC instance where the database name is longer than 8 letters. When we try to configure it, we see in the logs that the database names is shorten to 8 letters:

The database name is AKJFP14LOG

 

[B,2555900358,AKJFP14L,ARCHIVELOG,READ WRITE,12776703,I,1,akjfp14log,server1, NO, 1,] size=[0]

28841 70a9 05/03 13:05:24 ### RacBrowser::LocalInstanceBrowse() - Oracle SbtLibrary:[/opt/commvault/Base/libobk.so]

28841 70a9 05/03 13:05:24 ### RacBrowser::FillInstanceStatus(1034) - m_oraInfoReturn [B,2555900358,AKJFP14L,ARCHIVELOG,READ WRITE,12776703,I,1,akjfp14log,server1, NO, 1,] size=[0]

28841 70a9 05/03 13:05:24 ### RacBrowser::ValidateDBProps() - Received DBStatus=READ WRITE

Is it a problem with /opt/commvault/Base/libobk.so?

Thank you.

Thomas

 

 

 

2 replies

A
Vaulter
Forum|alt.badge.img+19

Hello @ThomasG 

Thanks for the great question, sounds like you may have found a bug. 
I recommend making sure you are on FR32.X latest and raising a support ticket to get it fix.

 

Kind regards
Albert Williams

The best way to learn anything, is to question everything
Michael Woodward
Certified Expert
Forum|alt.badge.img+14

Hello,

we have a problem to configure a RAC instance where the database name is longer than 8 letters. When we try to configure it, we see in the logs that the database names is shorten to 8 letters:

The database name is AKJFP14LOG

 

[B,2555900358,AKJFP14L,ARCHIVELOG,READ WRITE,12776703,I,1,akjfp14log,server1, NO, 1,] size=[0]

28841 70a9 05/03 13:05:24 ### RacBrowser::LocalInstanceBrowse() - Oracle SbtLibrary:[/opt/commvault/Base/libobk.so]

28841 70a9 05/03 13:05:24 ### RacBrowser::FillInstanceStatus(1034) - m_oraInfoReturn [B,2555900358,AKJFP14L,ARCHIVELOG,READ WRITE,12776703,I,1,akjfp14log,server1, NO, 1,] size=[0]

28841 70a9 05/03 13:05:24 ### RacBrowser::ValidateDBProps() - Received DBStatus=READ WRITE

Is it a problem with /opt/commvault/Base/libobk.so?

Thank you.

Thomas

 

 

 

Sorry to dig up an old topic ​@ThomasG but thought I’d check if you ever got an answer on this.  I’ve recently run RAC cross instance restores where we had the issue for a database restore having a name longer than 8 characters.  In the RMAN logs I found this entry:

I’ve changed the database name (which was 9 characters) to <DBNAME>

SQL> CREATE CONTROLFILE REUSE SET DATABASE <DBNAME> RESETLOGS FORCE LOGGING ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01127: database name '<DBNAME>' exceeds size limit of 8 characters
SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

As far as I’m aware the 8-character limit is a hard limit and can’t be exceeded for compatibility reasons. Fix was for the DBA to shorten the name. The restore logs had a command to run a script manually to change the ID of the database which corrected the issue.

Terms & ConditionsAccessibility statement