on 12-06-2012 7:20 AM
Hello Expert!
I just recently deployed the ECC6 of EHP6 with Selected of Oracle Database on windows platform.
I am able to stop and start the database and able to tnsping <hostname or ipaddress). but whenever run the sqlplus and provide the username and password. the sqlplus not able to connect and error occured "ORA-12543: TNS: destination host unreachable".
I have set master password during the installation and did not set any other password or overwrite.
Please advise how to resolve error!
Regards
Hi,
I also faced this issue long back. As per I can remember this error occurred due to @ character was used in the password of my database.
Plz check once and lets know the result.
Thanks
Rajat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Gupta...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anwer,
Try this command without <> :
sqlplus <user>/"<pass>"@<tnsentry>
Regards,
Ankit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, this issue is related to your password. If your password having@ remove@ symbol please change your password and try it will come 100%. I got same issue but at last I've find the correct solution....
Message was edited by: Karthik Bura
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anwer,
Just to add, please also check if you have maintained maintained hosts file entry...
C:\Windows\System32\drivers\etc --> hosts
mainatin hostname and ipaddress ...
thanks,
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anwer,
>> I am able to stop and start the database and able to tnsping <hostname or ipaddress).
Do you execute the sqlplus and connect to the database from the client desktop or on the server? How do you stop and start the database?
If you are connecting from your desktop pc, check the firewall ports.
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I also faced this issue long back. As per I can remember this error occurred due to @ character was used in the password of my database.
Plz check once and lets know the result.
Thanks
Rajat
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.