hello i download and install oracle10g in my laptop computer(windows xp),and works well.in order to save the resource of my machine,i modify all the oracle services in the windows service console to MANUAL,when i need,i can start it from the service console.
but sometimes,i need to start the oracle from the dos windows,i execute following command sequence:
1 lsnrctl start the tns listener can be started successfully. 2 set oracle_sid=mydb mydb is my oracle instance name. 3 sqlplus /nolog i can enter the sqlplus prompt. 4 connect /as sysdba failed,"ORA-12560: TNS: protocol adapter error". if i start my oracle instance FIRST from the windows service console,then the "connect /as sysdba" works.
but i want to start oracle COMPLETELY from the command line,how?
I had a problem and tried to totally reinstall version 9. I got this error previous to the resinstall and now continue to get same error. Oracle said to re-install XP, which isnt gonna happen. I hate when phone techs, say reinstall OS...when it isnt really the reason or the fault. I dont plan to reinstall this pc's os just for oracle. When I did the reinstall it was fresh install in that I removed all site of ORACLE anything from registry and from the HD. The windows eror at the end tells me its external to oracle and maybe something else, and maybe a windows problem but I wont reinstall XP on this computer just to fix oracle....or at least not till Im ready to.
LSNRCTL for 32-bit Windows: Version 188.8.131.52.1 - Production on 03-DEC-2004 22:32:19
Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.
Starting tnslsnr: please wait...
TNSLSNR for 32-bit Windows: Version 184.108.40.206.1 - Production System parameter file is D:\oracle\ora90\network\admin\listener.ora Log messages written to D:\oracle\ora90\network\log\listener.log Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=pjc-office)(PORT=1521))) TNS-12546: TNS ermission denied TNS-12560: TNS rotocol adapter error TNS-00516: Permission denied 32-bit Windows Error: 13: Permission denied
Listener failed to start. See the error message(s) above...