Dilemma
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Dilemma

  1. #1
    Join Date
    Nov 2000
    Posts
    74
    We have an Oracle 8.0.5 application on Unix. We took over a contract from another company which left us with no account names & passwords for dba. How can I sign on in order to shutdown this database? There are two instances on the box. When I try to sign on under server manager I get only one version. I've used "connect internal@test as sysdba" but it won't work with any password I have. I've changed the SYS password to get the internal password changed. That only works when I sign on as "Connect SYS/password." Not with "internal". "Connect internal as sysdba" connects me to the wrong instance. I can't find a way to shutdown this other instance. There is no password file on the UNIX.
    I have tried using SET ORACLE_SID=TEST, but it still goes to the other instance when I go into server manager.

    Help please!!!

    Thanks.

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    You can also use the same version(db version you are trying to connect) binaries for server manager executable and use connect string as follows.

    connect internal@xyz

    where xyz is service name of the database you are connecting to.
    Reddy,Sam

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Once after you set your environment, did you get to confirm that it had got set in the env.

    If you are using c shell i.e "%" then you get to use setenv
    If you are using the borne shell i.e. "$" then you use export.

    eg:
    Borne shell:

    ORACLE_SID=xyz; export ORACLE_SID


    C Shell:

    setenv ORACLE_SID xyz

    Then confirm that it had got set in the environment as


    env

    Then try connecting to theinstance as

    svrmgrl
    connect internal

    now you can alter the sys password as

    alter user sys identified by password;
    alter user system identified by password;

    :
    .
    etc


    Hope this would help you,

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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