Cant log into EQuity Edge Database
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: Cant log into EQuity Edge Database

  1. #1
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152

    Cant log into EQuity Edge Database

    Nobody here knows any of the account passwords for this instance. I want to setup rman backups so they can stop crashing the DB by trying to back it up directly. This instance was installed by a vendor to support their product 'Equity Edge'.

    Neither I nor the DBA who was here when I arrived were told this Oracle instance existed. Its on Windows 2000 and I have rebuilt the password file and been added to a group which says I should not need a password to log into Oracle.

    Cannot hack SYS, or SYSTEM passwords. Cant connect internal with /nolog.

    Not use to Windows environment, could use some help, seems connect internal should work but asks for password and I get a lot of ORA-12560: TNSrotocol adapter errors. tnsnames.ora, listener.ora look fine.

    Strange...thanks for any feedback.

  2. #2
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    1) Recreate the passwordfile
    You can recreate the password file using the ORAPWDxx command by which you can specify the password for internal. Before running this command to create the new password file, make sure to delete the old password file. Otherwise, the ORAPWDxx utility will give an error message.

    D:\> ORAPWD file=D:\ORACLE\DATABASE\PWDORCL.ORA password=
    entries=5

    Verify if the new file has been created.

    The passwordfile might be hidden. Hidden files can be seen:
    on the DOS-prompt by type :
    c:\> dir /A:H
    in Windows NT explorer :
    use the Windows Explorer View/Option 'show all files' to see the file.


    Remark:
    -------

    If the value of the "remote_login_passwordfile" parameter in the "initxxxx.ora" is
    EXCLUSIVE then you must shutdown your database before recreating the password
    file.


    HTH
    Gregg

  3. #3
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152
    Thanks maybe I need to perform the shutdown since the new password file did not help.

    Its Oracle8 by the way and the odd thing is if I run svrmgrl I get a TNS error back. That seems indicative of a bad installation no ?

    Immediate TNS error, never get to do anything from svrmgrl prompt.

  4. #4
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152
    After stopping instance, and rebuilding password file again I still get

    C:\Oracle\Ora817\bin>svrmgrl

    Oracle Server Manager Release 3.1.7.0.0 - Production

    Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

    ORA-12560: TNSrotocol adapter error
    SVRMGR>

    Same result from sqlplus....

    Any windows guru's seen this before ?

    thx

  5. #5
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Listener is running, right?
    And is that the only ora home , no 9i on that box?
    Last edited by Tarry; 09-30-2003 at 04:34 PM.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  6. #6
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    do...
    tracert if underlying networks are different.


    Usage: tracert [-d] [-h maximum_hops] [-j host-list] [-w timeout] target_name

    Options:
    -d Do not resolve addresses to hostnames.
    -h maximum_hops Maximum number of hops to search for target.
    -j host-list Loose source route along host-list.
    -w timeout Wait timeout milliseconds for each reply.


    tnsping the server, try using ip addresses in the tnsnames and listener files, use net8 connectivity to check connection.


    doing an ipconfig on the server machine will get you the ipaddress.

    also try explicitly setting the oracle sid...

    Also check that the database sid(in the services menu..oracleservicexxxx) is same as actual db sid, if that's changed then you can have touble as well...

    recreate the service


    oradimxx -delete -sid

    oradimxx -new -sid -intpwd AUTO -pfile





    Hope this will get you somewhere...
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  7. #7
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Note the funny thing here...

    Code:
    
    C:\WINNT\system32>svrmgrl
    
    Oracle Server Manager Release 3.1.7.0.0 - Production
    
    Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.
    
    ORA-12560: TNS:protocol adapter error
    SVRMGR> connect internal@nick817
    Connected.
    SVRMGR> select * from scott.emp
         2> /
    EMPNO      ENAME      JOB       MGR        HIREDATE  SAL        COMM       DEPTNO
    ---------- ---------- --------- ---------- --------- ---------- ---------- ----------
          7369 SMITH      CLERK           7902 17-DEC-80        800                    20
          7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30
          7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30
          7566 JONES      MANAGER         7839 02-APR-81       2975                    20
          7654 MARTIN     SALESMAN        7698 28-SEP-81       1250       1400         30
          7698 BLAKE      MANAGER         7839 01-MAY-81       2850                    30
          7782 CLARK      MANAGER         7839 09-JUN-81       2450                    10
          7788 SCOTT      ANALYST         7566 19-APR-87       3000                    20
          7839 KING       PRESIDENT            17-NOV-81       5000                    10
          7844 TURNER     SALESMAN        7698 08-SEP-81       1500          0         30
          7876 ADAMS      CLERK           7788 23-MAY-87       1100                    20
          7900 JAMES      CLERK           7698 03-DEC-81        950                    30
          7902 FORD       ANALYST         7566 03-DEC-81       3000                    20
          7934 MILLER     CLERK           7782 23-JAN-82       1300                    10
    14 rows selected.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  8. #8
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152
    Originally posted by Tarry
    Listener is running, right?
    And is that the only ora home , no 9i on that box?
    I found a 92 home but it looks not live.

    Most importantly I am local to the box, running sqlplus and svrmgrl right there and it wont work.

    Too weird that it comes up with protocol adapter error right away.

    I am afraid the install done long ago has hosed registry info, but the HR gals are having no problems connecting thru 3rd party equity edge.

    At some level it works, until backups clobber it and has to be restarted. Cant believe I cant get in.

  9. #9
    Join Date
    Jan 2003
    Location
    Denver
    Posts
    152
    yes the smiley is funny..hehe

    SQL> connect internal@eqed
    Enter password: *****************
    ERROR:
    ORA-12154: TNS:could not resolve service name

    Service is correct, explicitly set sid - no dice tho.

  10. #10
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    are you logged onto the box as a local or domain user?

    steve
    I'm stmontgo and I approve of this message

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