Database Administration (MOSC)

MOSC Banner

After Oracle 12.2 upgrade still it does not allow long identifier

edited Oct 29, 2017 10:28PM in Database Administration (MOSC) 13 commentsAnswered

I have upgraded mu Oracle 12.1.02 database to Oracle 12.2 form the Oracle Upgrade Assistant. Even after the upgrade still the database does not support long identifier name. what is the issue?

my 12.1.0.2 database had the init.ora file as below.

# RACE Master Oracle 12.1.0.2

db_cache_size=800M

job_queue_processes=1

nls_language="AMERICAN"

nls_length_semantics=CHAR

nls_territory="AMERICA"

open_cursors=2048

remote_login_passwordfile=EXCLUSIVE

shared_pool_size=800M

undo_tablespace=UNDOTBS1

COMPATIBLE=12.1.0.0.0 

undo_retention=3600

processes=300

.

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center