-
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.
-
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
-
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.
-
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
-
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)
--- Everything was meant to be---
-
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)
--- Everything was meant to be---
-
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)
--- Everything was meant to be---
-
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.
-
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|