kulikuli
asked on
a beginner's question..
Hi there,
I set up an Oracle server and now I want to run an instance and connect to the database.
This is the cmd file I run:
-------------------------- -
set ORACLE_SID=ifmH
F:\orant\v816\bin\oradim -delete -sid ifmH
pause
erase f:\orant\v816\database\pwd ifmh.ora
pause
F:\orant\v816\bin\oradim -new -sid ifmH -intpwd hofem -startmode auto -pfile F:\orant\v816\database\ini tifmH.ora
pause
F:\orant\v816\bin\oradim -startup -sid ifmH -starttype srvc,inst -usrpwd hofem -pfile F:\orant\v816\database\ini tifmH.ora
pause
F:\orant\v816\bin\svrmgrl @ifmHrun.sql
-------------------------- ---------- -
These is the output, ending up in an error:
-------------------------- ---------- -------
F:\orant\DATABASE>set ORACLE_SID=ifmH
F:\orant\DATABASE>F:\orant \v816\bin\ oradim -delete -sid ifmH
F:\orant\DATABASE>pause
Press any key to continue . . .
F:\orant\DATABASE>erase f:\orant\v816\database\pwd ifmh.ora
F:\orant\DATABASE>pause
Press any key to continue . . .
F:\orant\DATABASE>F:\orant \v816\bin\ oradim -new -sid ifmH -intpwd hofem -startmode auto -pfile F:\orant\v816\database\ini tifmH.ora
F:\orant\DATABASE>pause
Press any key to continue . . .
F:\orant\DATABASE>F:\orant \v816\bin\ oradim -startup -sid ifmH -starttype srvc,inst -usrpwd hofem -pfile F:\orant\v816\database\ini tifmH.ora
DIM-00011: The service does not exists
O/S-Error: (OS 5) Access is denied.
-------------------------- ---------- -
Can somebody explain what I am doing wrong? If more information is required, pls ask. I spent quite some time on this...
Thank you
I set up an Oracle server and now I want to run an instance and connect to the database.
This is the cmd file I run:
--------------------------
set ORACLE_SID=ifmH
F:\orant\v816\bin\oradim -delete -sid ifmH
pause
erase f:\orant\v816\database\pwd
pause
F:\orant\v816\bin\oradim -new -sid ifmH -intpwd hofem -startmode auto -pfile F:\orant\v816\database\ini
pause
F:\orant\v816\bin\oradim -startup -sid ifmH -starttype srvc,inst -usrpwd hofem -pfile F:\orant\v816\database\ini
pause
F:\orant\v816\bin\svrmgrl @ifmHrun.sql
--------------------------
These is the output, ending up in an error:
--------------------------
F:\orant\DATABASE>set ORACLE_SID=ifmH
F:\orant\DATABASE>F:\orant
F:\orant\DATABASE>pause
Press any key to continue . . .
F:\orant\DATABASE>erase f:\orant\v816\database\pwd
F:\orant\DATABASE>pause
Press any key to continue . . .
F:\orant\DATABASE>F:\orant
F:\orant\DATABASE>pause
Press any key to continue . . .
F:\orant\DATABASE>F:\orant
DIM-00011: The service does not exists
O/S-Error: (OS 5) Access is denied.
--------------------------
Can somebody explain what I am doing wrong? If more information is required, pls ask. I spent quite some time on this...
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried to connect using SVRMGRL, but it returns the following an error:
ORA-12560: TNS:protocol adaptor error
ORA-12560: TNS:protocol adaptor error
ORA-12560 is usualy a listener problem.
configure listener:
go to f:\orant\v816\network\admi n,
edit listener.ora (make sure you backup it up)
and insert lines:
### START OF LISTENER.ORA FILE ###
listener=(address_list=
(address=
(protocol=ipc)
(key=ifmH)
)
(address=
(protocol=tcp)
(host=<machine_ip>)
(port=1521)
)
)
sid_list_listener=(sid_lis t=
(sid_desc=
(sid_name=imfH)
(oracle_home=f:\orant\v816 )
)
)
startup_wait_time_listener =0
connect_timeout_listener=1 0
trace_level_listener_liste ner=off
### END OF LISTENER.ORA FILE ###
goto dos prompt:
D:\> lsnrctl stop
D:\> lsnrctl start
try the whole process from the begining.
regards,
dbaora.
configure listener:
go to f:\orant\v816\network\admi
edit listener.ora (make sure you backup it up)
and insert lines:
### START OF LISTENER.ORA FILE ###
listener=(address_list=
(address=
(protocol=ipc)
(key=ifmH)
)
(address=
(protocol=tcp)
(host=<machine_ip>)
(port=1521)
)
)
sid_list_listener=(sid_lis
(sid_desc=
(sid_name=imfH)
(oracle_home=f:\orant\v816
)
)
startup_wait_time_listener
connect_timeout_listener=1
trace_level_listener_liste
### END OF LISTENER.ORA FILE ###
goto dos prompt:
D:\> lsnrctl stop
D:\> lsnrctl start
try the whole process from the begining.
regards,
dbaora.
ASKER
I replaced the original listener.ora:
# LISTENER.ORA Network Configuration File: F:\orant\v816\network\admi n\listener .ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ntifm01)(PORT = 1521))
)
)
)
# end of file
with your sample and changed <machine_ip> to the server's ip address.
however...
>lsnlctl [enter]
results in:
-----------
LSNRCTL for 32-bit Windows: Version 8.1.6.0.0 - Production on 20-MAR-2002 16:05:31
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
Starting tnslsnr: please wait...
Failed to start service, error 5.
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 5: Input/output error
# LISTENER.ORA Network Configuration File: F:\orant\v816\network\admi
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ntifm01)(PORT = 1521))
)
)
)
# end of file
with your sample and changed <machine_ip> to the server's ip address.
however...
>lsnlctl [enter]
results in:
-----------
LSNRCTL for 32-bit Windows: Version 8.1.6.0.0 - Production on 20-MAR-2002 16:05:31
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
Starting tnslsnr: please wait...
Failed to start service, error 5.
TNS-12546: TNS:permission denied
TNS-12560: TNS:protocol adapter error
TNS-00516: Permission denied
32-bit Windows Error: 5: Input/output error
If you are trying to start the db instance on the same box and you receive 'tns protocol adapter' error, then check for 2 things.
- open a command window
- see whether your oracle related service is started or not. If not, then start it.
- check whether oracle_sid env variable is set to your sid value.
C:\> set oracle_sid=ifmH
Regards,
Sudhi.
- open a command window
- see whether your oracle related service is started or not. If not, then start it.
- check whether oracle_sid env variable is set to your sid value.
C:\> set oracle_sid=ifmH
Regards,
Sudhi.
ASKER
Thanx dbaora,
Unfortunately I didn't manage to fix the problem by reading the comments on this topic. I reinstalled the whole thing - which took alot of time - and now it works. But I'll grant you this topic for the efforts.
Unfortunately I didn't manage to fix the problem by reading the comments on this topic. I reinstalled the whole thing - which took alot of time - and now it works. But I'll grant you this topic for the efforts.
ASKER
ORA-12560: TNS:protocol adaptor error