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.
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 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...
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---