Database Administration (MOSC)

MOSC Banner

SPFILE and PFILE altered

edited Mar 23, 2017 5:00AM in Database Administration (MOSC) 14 commentsAnswered

Hello,

Last saturday i had a problem with my database that cannot startup.

After too many hours finding the problem, i notice that my init.ora file was like this:

MBSHO.__db_cache_size=14696841216

MBSHO.__java_pool_size=67108864

MBSHO.__large_pool_size=67108864

MBSHO.__oracle_base='/home/oracle'#ORACLE_BASE set from environment

MBSHO.__pga_aggregate_target=8992587776

MBSHO.__sga_target=16777216000

MBSHO.__shared_io_pool_size=0

MBSHO.__shared_pool_size=1744830464

MBSHO.__streams_pool_size=67108864

*._kgl_debug='name=','SELECT','COUNT(*)','FROM'

#.schema=',','SYS'

.namespace=',','1'

.debug=',','3723286657','

.name=',',',',','SELECT',',',',','COUNT(*)',',',',','FROM'

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