Solved

a beginner's question..

Posted on 2002-03-19
7
859 Views
Last Modified: 2012-06-27
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\pwdifmh.ora
pause
F:\orant\v816\bin\oradim -new -sid ifmH -intpwd hofem -startmode auto -pfile F:\orant\v816\database\initifmH.ora
pause
F:\orant\v816\bin\oradim -startup -sid ifmH -starttype srvc,inst -usrpwd hofem -pfile F:\orant\v816\database\initifmH.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\pwdifmh.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\initifmH.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\initifmH.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
0
Comment
Question by:kulikuli
  • 4
  • 2
7 Comments
 
LVL 2

Accepted Solution

by:
dbaora earned 100 total points
ID: 6879692
Hi kulikuli,

In Oracle version 8.0.x there were two services for an oracle instnace:
1) OracleStart<SID>:   OracleStartifmH
2) OracleService<SID>: OracleServiceifmH

Since Oracle 8i there is only one service for the instnace.
Try deleting the last line from your file and use:
svrmgrl
SVRMGR> connect internal;
SVRMGR> startup nomount pfile='F:\orant\v816\database\initifmH.ora';
SVRMGR> create database .....

regards,
dbaora
0
 
LVL 5

Author Comment

by:kulikuli
ID: 6880071
I tried to connect using SVRMGRL, but it returns the following an error:
 
ORA-12560: TNS:protocol adaptor error
0
 
LVL 5

Author Comment

by:kulikuli
ID: 6880097
I tried to connect using SVRMGRL, but it returns the following an error:
 
ORA-12560: TNS:protocol adaptor error
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 2

Expert Comment

by:dbaora
ID: 6882126
ORA-12560 is usualy a listener problem.

configure listener:

go to f:\orant\v816\network\admin,
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_list=
   (sid_desc=
      (sid_name=imfH)
      (oracle_home=f:\orant\v816)
   )
)
startup_wait_time_listener=0
connect_timeout_listener=10
trace_level_listener_listener=off
### END OF LISTENER.ORA FILE ###

goto dos prompt:
D:\> lsnrctl stop
D:\> lsnrctl start

try the whole process from the begining.

regards,
dbaora.
0
 
LVL 5

Author Comment

by:kulikuli
ID: 6882695
I replaced the original listener.ora:

# LISTENER.ORA Network Configuration File: F:\orant\v816\network\admin\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
0
 
LVL 4

Expert Comment

by:sudhi022299
ID: 6889280
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.
0
 
LVL 5

Author Comment

by:kulikuli
ID: 6988466
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.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now