Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2001
    Posts
    4

    Question ORA-01034: Message 1034 not found;

    Hi All,

    I am using oracle 8i release 2 on RHL 6.2. I had been able to successfully install and configure oracle, but then for some reasons I had to move my box to a new network. When I now try to start an instance of oracle, this is what I get:

    svrmgrl > connect internal/password
    ORA-01034: Message 1034 not found; No message file for product=RDBMS, facility=ORA

    What could be wrong?

    #echo ORACLE_HOME
    /home/oracle/oracleinstall/app
    #echo ORACLE_SID
    usseipl

    -- init.ora
    db_name = "stcrm"
    db_domain = softwareelements.com
    instance_name = usseipl
    service_names = stcrm.softwareelements.com
    db_files = 1024 # LARGE
    control_files = ("/home/oracle/oracleinstall/app/oradata/stcrm/control01.ctl", "
    /home/oracle/oracleinstall/app/oradata/stcrm/control02.ctl", "/home/oracle/oracl
    einstall/app/oradata/stcrm/control03.ctl")
    open_cursors = 100
    max_enabled_roles = 30
    db_file_multiblock_read_count = 32 # LARGE

    _use_ism = false
    db_block_buffers = 2048 # INITIAL

    shared_pool_size = 15728640 # INITIAL
    large_pool_size = 614400
    java_pool_size = 20971520

    log_checkpoint_interval = 10000
    log_checkpoint_timeout = 1800
    processes = 200 # INITIAL

    log_buffer = 163840 # INITIAL

    user_dump_dest = /home/oracle/oracleinstall/admin/stcrm/udump

    db_block_size = 8192

    remote_login_passwordfile = exclusive

    os_authent_prefix = ""

    compatible = "8.1.0"
    sort_area_size = 65536
    sort_area_retained_size = 65536

    -- listener.ora
    LISTENER =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = se-3)(PORT = 1521))
    )
    )
    (DESCRIPTION =
    (PROTOCOL_STACK =
    (PRESENTATION = GIOP)
    (SESSION = RAW)
    )
    (ADDRESS = (PROTOCOL = TCP)(HOST = se-3)(PORT = 2481))
    )
    )

    SID_LIST_LISTENER =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /home/oracle/oracleinstall/app)
    (PROGRAM = extproc)
    )
    (SID_DESC =
    (GLOBAL_DBNAME = stcrm.softwareelements.com)
    (ORACLE_HOME = /home/oracle/oracleinstall/app)
    (SID_NAME = usseipl)
    )
    )


    -- tnsnames.ora
    STCRM.SOFTWAREELEMENTS.COM =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = se-3)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = stcrm.softwareelements.com)
    )
    )

    EXTPROC_CONNECTION_DATA =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
    (SID = PLSExtProc)
    (PRESENTATION = RO)
    )


    Any help would be greatly appreciated. There are several documents that google fetches, but none of them really help!

    Thanks.
    manav.

    ps: what does that "_use_ism = false" in init.ora mean?
    Its impossible to watch a sunset, and not dream.

  2. #2
    Join Date
    Aug 2001
    Posts
    4
    Hi,

    In continuation with this email:

    1. tnsping <sid> (which in my case is usseipl) fails.
    2. tnsping <service_name> (which in my case is stcrm.softwarelements.com) works.
    3. orapwd file=orpw<sid> internal=<newpassword> gives an error: unable to find error file. The older pw file (and all files in this directory belong to oracleuser.oraclegroup).
    4. sqlplus itself fails (:-) I know this is getting to be too much!). sqplus says:
    Message file sp1<lang>.msb not found
    Error 6 initializing SQL*Plus

    The files sp1us.msb and sp2us.msb exist under $ORACLE_HOME/sqlplus/mesg.

    I still have no clues whats wrong?!!!

    Should I go ahead and try creating a new database (with or without dbassist)?

    Any pointers will be appreciated.

    Manav.
    Its impossible to watch a sunset, and not dream.

  3. #3
    Join Date
    May 2003
    Posts
    1

    bad install

    Answer of first post:
    "_use_ism" should be "use_ism" from Harrison's Oracle Desk Reference (page 459) "if true this uses intimate data buffers, allowing SGAs of more than 4GB on supported platforms."

    I reference to your missing *.msb files: when you installed on the new machine, did you get any errors? Recently I had similar issues, and a reinstall magically corrected the *.msb errors (most of the *.msb should be in $ORACLE_HOME/rdbms/mesg/)

    I would also confirm that the $ORACLE_HOME and $ORACLE_BASE (not strictly necessary, but helpful) are set to correct paths.

    Usually an OFA complient install will have ORACLE_HOME set to include something closer to $ORACLE_BASE/product/8.1.6/ as the finish of the path (replace 8.1.6 with the version of the db you are using).

    In regards to the 1034 error, I am right now having similar odd issues- from an oracle shell account, I can log into the database. The listener is set up, and I can tnsping and trcroute correctly. If I try to log into a different OS user shell (ORACLE env variables set the same as the oracle OS user), I get a 1034 error. From the oracle user I can log into multiple oracle accounts from sqlplus.

  4. #4
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Exclamation

    svrmgrl > connect internal/password
    ORA-01034: Message 1034 not found; No message file for product=RDBMS, facility=ORA
    You didn't setup the correct ORACLE_HOME, ORACLE_SID in your Linux shell. Do that and verify it - $ env

    Most probably you have multiple Oracle homes, and the svrmgrl doesn't find the correct message files.

    Couple of other things:

    1. Since you have SOFTWAREELEMENTS.COM as TNS alias domain, check if the sqlnet.ora has SQLNET.DEFAULT_DOMAIN=SOFTWAREELEMENTS.COM too.

    2. How come that in the listener.ora file you have - (SID_NAME = usseipl) , but in the tnsnames.ora is different - (SERVICE_NAME = stcrm.softwareelements.com) ? Which one is the right one ???


    Hope that helps,

    clio_usa
    OCP - DBA
    Visit our Web Site

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •