Cant log into EQuity Edge Database

Printable View

09-30-2003, 12:38 PM
BJE_DBA

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: TNS:protocol adapter errors. tnsnames.ora, listener.ora look fine.

Strange...thanks for any feedback.
09-30-2003, 12:58 PM
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
09-30-2003, 01:06 PM
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.
09-30-2003, 04:11 PM
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: TNS:protocol adapter error
SVRMGR>

Same result from sqlplus....

Any windows guru's seen this before ?

thx
09-30-2003, 04:30 PM
Tarry

Listener is running, right?
And is that the only ora home , no 9i on that box?
09-30-2003, 04:55 PM
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...
09-30-2003, 05:00 PM
Tarry

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.
09-30-2003, 05:04 PM
BJE_DBA

Quote:

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.
09-30-2003, 05:07 PM
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.
09-30-2003, 05:10 PM
stmontgo

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

steve
09-30-2003, 05:17 PM
Tarry

Aha, so another error..

check if any alaises defined on the machine..

Check this file
Oracle\ Ora81\ Network\ Admin\ Tnsnames.ora and a .world would be appended to it...
See if the env var is local.

Check you sqlnet.log in the log directory of the network folder..

my error stack says this(for instance)...

Fatal NI connect error 12640, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.7.4.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.4.0 - Production
Time: 29-SEP-2003 23:11:01
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12640
TNS-12640: Authentication adapter initialization failed
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0

Did you try to use the net8 connection test, thru the net8 utility? Try recomfiguring the net8 configuration and test again.
10-01-2003, 05:31 PM
BJE_DBA

Thank you for your help.

The problem was terminal services. I got local access to the box and was able to use the new password from the newly gen'ed password file.

I immediately reset system and sys to something reasonable.