1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

R11 session and database settings

Discussion in 'Server Administration and Options' started by jesthr@gmail.com, Feb 1, 2013.

  1. jesthr@gmail.com

    jesthr@gmail.com Active Member

    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    80
    Dear!

    I have Oracle R11 on Microsoft Windows server 2008
    I would like to have the same parameters as SESSION_PARAMETERS and DATABASE_PARAMETERS.
    The DATABASE_PARAMERES must be the same as SESSION_PARAMETERS, slovenian . ..


    This ia my SPFILE::
    webdb.__db_cache_size=1962934272
    webdb.__java_pool_size=16777216
    webdb.__large_pool_size=16777216
    webdb.__oracle_base='E:\oracle\dbadmin'#ORACLE_BASE set from environment
    webdb.__pga_aggregate_target=872415232
    webdb.__sga_target=2583691264
    webdb.__shared_io_pool_size=0
    webdb.__shared_pool_size=536870912
    webdb.__streams_pool_size=16777216
    *.audit_file_dest='E:\oracle\dbadmin\admin\webdb\adump'
    *.audit_trail='db'
    *.compatible='11.2.0.0.0'
    *.control_files='E:\oracle\dbadmin\oradata\webdb\control01.ctl','E:\oracle\dbadmin\fast_recovery_area\webdb\control02.ctl'
    *.db_block_size=8192
    *.db_domain=''
    *.db_name='webdb'
    *.db_recovery_file_dest='E:\oracle\dbadmin\fast_recovery_area'
    *.db_recovery_file_dest_size=4322230272
    *.diagnostic_dest='E:\oracle\dbadmin'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=webdbXDB)'
    *.nls_currency='EUR'
    *.nls_date_format='DD.MM.RR'
    *.nls_date_language='SLOVENIAN'
    *.nls_dual_currency='EUR'
    *.nls_iso_currency='SLOVENIA'
    *.nls_language='SLOVENIAN'
    *.nls_numeric_characters=',.'
    *.nls_sort='SLOVENIAN'
    *.nls_territory='SLOVENIA'
    *.nls_time_format='HH24:MI:SSXFF'
    *.open_cursors=300
    *.pga_aggregate_target=858783744
    *.processes=150
    *.remote_login_passwordfile='EXCLUSIVE'
    *.sga_target=2576351232
    *.undo_tablespace='UNDOTBS1'


    This is DATABASE_PARAMTETERS
    PARAMETER VALUE
    ------------------------------ ----------------------------------------
    NLS_LANGUAGE AMERICAN
    NLS_TERRITORY AMERICA
    NLS_CURRENCY $
    NLS_ISO_CURRENCY AMERICA
    NLS_NUMERIC_CHARACTERS .,
    NLS_CALENDAR GREGORIAN
    NLS_DATE_FORMAT DD-MON-RR
    NLS_DATE_LANGUAGE AMERICAN
    NLS_SORT BINARY
    NLS_TIME_FORMAT HH.MI.SSXFF AM
    NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
    NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
    NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
    NLS_DUAL_CURRENCY $
    NLS_COMP BINARY
    NLS_LENGTH_SEMANTICS BYTE
    NLS_NCHAR_CONV_EXCP FALSE


    This is SESSION_PARAMTETERS
    NLS_LANGUAGE SLOVENIAN
    NLS_TERRITORY SLOVENIA
    NLS_CURRENCY SIT
    NLS_ISO_CURRENCY SLOVENIA
    NLS_NUMERIC_CHARACTERS ,.
    NLS_CALENDAR GREGORIAN
    NLS_DATE_FORMAT DD.MM.RR
    NLS_DATE_LANGUAGE SLOVENIAN
    NLS_SORT SLOVENIAN
    NLS_TIME_FORMAT HH24:MI:SSXFF
    NLS_TIMESTAMP_FORMAT DD.MM.RR HH24:MI:SSXFF
    NLS_TIME_TZ_FORMAT HH24:MI:SSXFF TZR
    NLS_TIMESTAMP_TZ_FORMAT DD.MM.RR HH24:MI:SSXFF TZR
    NLS_DUAL_CURRENCY SIT
    NLS_COMP BINARY
    NLS_LENGTH_SEMANTICS BYTE
    NLS_NCHAR_CONV_EXCP FALSE

    Question!
    How can I set the DATABASE PARAMETER like SESSION PARAMETERS
    (On the HP-UNIX system is o.k.)

    Regards!
    hine.rosulnik@gmail.com
    Hine Rosulnik
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,351
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You do this:

    Code (SQL):
    ALTER system SET NLS_LANGUAGE=SLOVENIAN scope=spfile;
    ALTER system SET NLS_TERRITORY=SLOVENIA scope=spfile;
    ALTER system SET NLS_CURRENCY=SIT scope=spfile;
    ALTER system SET NLS_ISO_CURRENCY=SLOVENIA scope=spfile;
    ALTER system SET NLS_NUMERIC_CHARACTERS=',.' scope=spfile;
    ALTER system SET NLS_CALENDAR=GREGORIAN scope=spfile;
    ALTER system SET NLS_DATE_FORMAT='DD.MM.RR' scope=spfile;
    ALTER system SET NLS_DATE_LANGUAGE=SLOVENIAN scope=spfile;
    ALTER system SET NLS_SORT=SLOVENIAN scope=spfile;
    ALTER system SET NLS_TIME_FORMAT='HH24:MI:SSXFF' scope=spfile;
    ALTER system SET NLS_TIMESTAMP_FORMAT='DD.MM.RR HH24:MI:SSXFF' scope=spfile;
    ALTER system SET NLS_TIME_TZ_FORMAT='HH24:MI:SSXFF TZR' scope=spfile;
    ALTER system SET NLS_TIMESTAMP_TZ_FORMAT='DD.MM.RR HH24:MI:SSXFF TZR' scope=spfile;
    ALTER system SET NLS_DUAL_CURRENCY=SIT scope=spfile;
    ALTER system SET NLS_COMP=BINARY scope=spfile;
    ALTER system SET NLS_LENGTH_SEMANTICS=BYTE scope=spfile;
    ALTER system SET NLS_NCHAR_CONV_EXCP=FALSE scope=spfile;
     
    then restart the database.