| Kaiz |
Posted: Jan 09, 2008 12:47:50 AM |
Total Post: 104
Joined: Sep, 2007
|
Dear Friends,
When I am trying to connect to the sid database which I had created at the time of Installation of oracle 9i, I am able to connect through OEM but when I am trying to connect through Command Prompt using SQLPLUS I am not able to connect I am getting this error..Ora-12560 : TNS: Protocol adapter error, servie is started...but still when I am giving on the command prompt net start oracleserviceNAME it is giving me the error the service name is invalid.....On the contrary when I created a new Database using DBCA I am able to connect from both OEM as well as from Dos prompt using Sqlplus .....
Please if any one can solve this proble...
With regards.... |
|
|
 Babu |
| Posted: Jan 09, 2008 01:39:46 AM |  |
|
Total Post: 90
Joined: Oct, 2007
|
>>net start oracleserviceNAME it is giving me the error the service name is invalid....
net start OracleServiceDBName
|
|
|
|
|
| Kaiz |
| Posted: Jan 09, 2008 05:51:14 AM | |
|
Total Post: 104
Joined: Sep, 2007
|
Dear Babu,
Yes I have given the same command net start OracleServiceDatabasename but still is giving the error that invalid service name....
Thanks & Regards..
|
|
|
|
|
| vikhardba |
| Posted: Jan 09, 2008 07:09:56 AM | |
|
Total Post: 85
Joined: Apr, 2007
|
Did you try restarting OracleservicesDBNAME from services.msc window? If yes, try to set ORACLE_SID==SIDNAME and then type sqlplus "/as sysdba" from DOS prompt.
|
|
|
|
|
| Kaiz |
| Posted: Jan 10, 2008 06:56:18 AM | |
|
Total Post: 104
Joined: Sep, 2007
|
Yes Vikhar, I had tried the option what you are telling still its not working... yaar....
Thanks & Regards
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
