Cant log into EQuity Edge Database

[BJE_DBA]

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.

[gbrabham]

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

[BJE_DBA]

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.

[BJE_DBA]

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

[Tarry]

Listener is running, right?
And is that the only ora home , no 9i on that box?

[Tarry]

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]

Note the funny thing here...

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.

[BJE_DBA]

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.

[BJE_DBA]

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.

[stmontgo]

are you logged onto the box as a local or domain user?

steve