Results 1 to 7 of 7

Thread: Logon via EXP

  1. #1
    Join Date
    Sep 2003
    Location
    Chiang Mai Thailand
    Posts
    14

    Post Unanswered: Logon via EXP

    Hello
    I try to use EXP utility oracle 9.0.2
    after I telnet to server and type to shell promt (oracle user) as followed
    [oracle@linux-serv EXP]$ exp system/**** file=/EXP/expdat.dmp compress=y
    System return me as followed
    Export: Release 9.2.0.1.0 - Production on Mon Sep 22 19:40:43 2003

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


    EXP-00056: ORACLE error 1034 encountered
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory
    EXP-00005: all allowable logon attempts failed
    EXP-00000: Export terminated unsuccessfully

    Evenif I use system user and system's password login to Oracle Enterprise Manager successful. I gave same password to exp parameter.
    But I can not log in to system. How can I fix this problem?
    I try to solve problem.By use oerr command. It told me as I did'nt start oracle instance. Evenif it still running.....
    I reconize something. I can connect as system in oracle enterprise manager (normal and as sysdba). But for sys use I connect as sysdba only.
    Guide me please.
    Thank you.
    Attached Thumbnails Attached Thumbnails logon.bmp  
    Kindly regards,
    Thana p.
    Chiangmai Thailand
    Yim_cm@hotmail.com

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Check the database is up using sqlplus and check your environment variables are correctly set (like $ORACLE_HOME, $ORACLE_SID etc).

    Alan

  3. #3
    Join Date
    Sep 2003
    Location
    Chiang Mai Thailand
    Posts
    14

    Post My configurations file

    I set ora environment in .bashrc in /home/oracle as followed
    ######### .bashrc #################
    #Oracle environment
    export ORACLE_BASE=/opt/oracle
    export ORACLE_HOME=/opt/oracle/product/9.2.0
    export ORACLE_SID=GG
    ##################################

    in /$ORACLE_HOME/dbs/initGG.ora as followed

    ########## initGG.ora ################
    # replace DEFAULT with your database name
    db_name=GG
    ##################################

    in /$ORACLE_HOME/network/admin/tnsnames.ora are followed

    ########### tnsnames.ora #############
    GG =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = linux-serv)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = GG)
    )
    )
    ####################################

    and my process still running normally as
    oracle 2965 1 0 08:00 ? 00:00:00 ora_pmon_GG
    oracle 2967 1 0 08:00 ? 00:00:01 ora_dbw0_GG
    oracle 2969 1 0 08:00 ? 00:00:01 ora_lgwr_GG
    oracle 2971 1 0 08:00 ? 00:00:01 ora_ckpt_GG
    oracle 2973 1 0 08:00 ? 00:00:03 ora_smon_GG
    oracle 2975 1 0 08:00 ? 00:00:00 ora_reco_GG
    oracle 2977 1 0 08:00 ? 00:00:00 ora_cjq0_GG
    oracle 2979 1 0 08:00 ? 00:01:16 ora_qmn0_GG
    oracle 2981 1 0 08:00 ? 00:00:00 ora_s000_GG
    oracle 2983 1 0 08:00 ? 00:00:00 ora_d000_GG
    oracle 2994 1 0 08:00 tty1 00:00:01 /opt/oracle/product/9.2.0/bin/tnslsnr LISTENER -inherit

    #######################################
    Everthing seem ok.
    I can connect in shell by
    [oracle@linux-serv admin]$ sqlplus system/****@GG

    SQL*Plus: Release 9.2.0.1.0 - Production on Mon Sep 22 21:31:04 2003

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


    Connected to:
    Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.1.0 - Production

    but I can not connect as followed
    [oracle@linux-serv admin]$ sqlplus

    SQL*Plus: Release 9.2.0.1.0 - Production on Mon Sep 22 21:33:09 2003

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Enter user-name: system
    Enter password: ******
    ERROR:
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Linux Error: 2: No such file or directory

    What wrong with me.
    Kindly for help.
    Kindly regards,
    Thana p.
    Chiangmai Thailand
    Yim_cm@hotmail.com

  4. #4
    Join Date
    Mar 2004
    Posts
    1

    run rdbms scripts

    you should tryto log in sqlplus/nolog as sys then run the rdbms script found in that folder for the export.

  5. #5
    Join Date
    Jan 2004
    Posts
    99
    check your ORACLE_SID

    type the folowing echo $ORACLE_SID

    this will display the ORACLE_SID of the database you are trying to export.

  6. #6
    Join Date
    Jan 2004
    Location
    Scottsdale, AZ
    Posts
    106
    Also look in the alert log for any messages. Looks to me like the instance is started, but not open.
    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

  7. #7
    Join Date
    Jan 2004
    Posts
    370
    This post has been dormant for over 5 months.
    I'd guess it is no longer an issue.

Posting Permissions

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