ORACLE initialization or shutdown in progress
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: ORACLE initialization or shutdown in progress

  1. #1
    Join Date
    Aug 2001
    Posts
    26
    someone pls help....
    SERVER :
    OS=>SPARC SOLARIS 5.8
    DB => 8.1.5

    SVRMGR> connect internal
    Connected.
    SVRMGR> startup pfile=initabctst.ora
    ORACLE instance started.
    Total System Global Area 11333008 bytes
    Fixed Size 64912 bytes
    Variable Size 10059776 bytes
    Database Buffers 1126400 bytes
    Redo Buffers 81920 bytes
    Database mounted.
    Database opened.
    SVRMGR> select * from v$database;
    DBID NAME CREATED RESETLOGS_ RESETLOGS PRIOR_RESE PRIOR_RES LOG_MOD
    E CHECKPOINT ARCHIVE_CH CONTROL CONTROLFI CONTROLFIL CONTROLFIL CONTROLFI OP
    EN_RESETL VERSION_T OPEN_MODE
    ---------- --------- --------- ---------- --------- ---------- --------- -------
    ----- ---------- ---------- ------- --------- ---------- ---------- --------- --
    --------- --------- ----------
    3196858936 ABCTST 31/08/200 1 31/08/200 0 NOARCHI
    VELOG 111676 111487 CURRENT 31/08/200 1395 111676 05/09/200 NO
    T ALLOWED 31/08/200 READ WRITE
    1 row selected.
    SVRMGR>



    in the client side


    C:\ORAWIN95\NET80\ADMIN>tnsping abctst

    TNS Ping Utility for 32-bit Windows: Version 2.3.4.0.0 - Production on 05-SEP-01
    17:35:38

    Copyright (c) Oracle Corporation 1995. All rights reserved.

    Attempting to contact (ADDRESS=(PROTOCOL=TCP)(Host=190.200.8.112)(Port=1521))
    OK (0 msec)



    but when i connect

    C:\ORAWIN95\NET80\ADMIN>plus80 system@abctst

    SQL*Plus: Release 8.0.5.0.0 - Production on Wed Sep 5 17:36:22 2001

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Enter password:
    ERROR:
    ORA-01033: ORACLE initialization or shutdown in progress


    Enter user-name:
    ERROR:
    ORA-12203: TNS:unable to connect to destination


    Enter user-name:



    wat's wrong????

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    SHUTDOWN IMMEDIATE and STARTUP again.

    Have you made the password file with orapwd?

    I suppose that remote_login_passwordfile = exclusive.





  3. #3
    Join Date
    Aug 2001
    Posts
    26
    Connected to:
    Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
    With the Partitioning and Java options
    PL/SQL Release 8.1.5.0.0 - Production


    NAME
    ---------
    ABCTST


    INSTANCE
    ----------------
    abctst

    SQL> show parameter remote_login

    NAME TYPE VALUE
    ------------------------------------ ------- --------------------
    remote_login_passwordfile string NONE
    SQL>


    I already bounced my db.......
    one of the workstation has a version of sqlplus 8.1.5
    I created the same entry for the tns. and look what happened

    C:\>sqlplus system@abctst

    SQL*Plus: Release 8.1.5.0.0 - Production on Wed Sep 5 17:57:30 2001

    (c) Copyright 1999 Oracle Corporation. All rights reserved.

    Enter password:

    Connected to:
    Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
    With the Partitioning and Java options
    PL/SQL Release 8.1.5.0.0 - Production

    SQL>


  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Is everything in order now?

  5. #5
    Join Date
    Jun 2000
    Posts
    315
    1. I think your problem is on client side.
    2. the problem is a networking problem.

    please try following:

    1. make sure the tnsnames.ora, sqlnet.ora file are in the net80\admin directory instead of network\admin directory.
    2. check if wsock32.dll file in \windows directory is 65k.


    Please let us know how'd it go, and how you solve the problem!

    Thank you!


Posting Permissions

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



Click Here to Expand Forum to Full Width