Hi expert,
We loss sys and system password for one of our oracle 10g database(10.2.0.5) which os running on AIx machine. to trying to connect the database with sys as sysdba its throwing error ora 12545, we have tried to login the database with sys user,
logged in oracle user as dba member of the operating system then tried ,
# sqlplus / as sysdba@prdot
ORA-12545: Connect failed because target host or object does not exist
But , we connect the database with normal application user, after i found solution for ora 12545 , i have changed tnsnames.ora file HOST entry to numeric ip address but stil getting same error ,
after changing ip address of Host name i can able to connect as normal user but can't sys user with / as sysdba,
also tried with sqlplus / as sysdba@//ip address:1521/db name , no luck same error 12545 ,
This is my tnsnames.ora entry,
prdot = (DESCRIPTION=
(ADDRESS=
(COMMUNITY=TIA_TCP)
(PROTOCOL=TCP)
(Host=**.***.***.***) - -- tried this with actual host name also instead of numeric ip
(Port=1521)
)
(CONNECT_DATA=(SID=prdot) (srvr=dedicated) )
)
Please help on to resolve and connect database with sys user since we lost sys user credentials, here i'm not getting os authentication error , getting target host and object does not exist error. we have os level oracle user and root user passwords also. Please provide your suggestion to resolve this issue.
Thanks in Advance.