CODEWITHSUNDEEP
oracle-databaseoracle11g
captinmemo
captinmemo

Reputation: 41

can't start oracle service in windows

I'm taking DB prog. class and we are required to use Oracle+ Oracle sql dev. I so far I got 3 DB in oracle each with a connection from Oracle sql dev.

In windows services I only have one service called OracleDBConsole"MY1stDB name" there's no similiar services for the other DBs I created.

When I try to start this service I receive error as the picture

enter image description here

I can connect through the connections in Oracle sql dev. to the other DB I created except the 1st one

Does anybody have an idea on this issue

Upvotes: 1

Views: 8564

Answers (4)

mohsen.b
mohsen.b

Reputation: 436

Mentioned service relates to oracle enterprise manager service.you have this because it configured for your database. but to troubleshoot it please check its logs in %ORACLE_HOME%**HOSTNAME_DBNAME**\sysman\log*. check there logs and send to investigate. regards, Mohsen

Upvotes: 2

Kacper
Kacper

Reputation: 4818

OK you installed 3 instances on same machine. There are two possibilities.

They are all set up to use default ports so when one is started no other can start due to port conflict. In that case you need to reconfigure ports following documentation

Second possibility is you already have different ports for your instances. In that case please check your connection definitions if they use proper ports. First will probably need default 1521 but others needs other ports. You may try 1522 as when during instalation 1521 was used it could took next free. But generally you should go to NETWORK/ADMIN/listener.ora edit file and check what port is used. Then properly define connection in client tool.

But as said in comments. Installing 3 instances make no sense unless you're trying to do some study with DBlinks simulations.

Upvotes: 2

Pavel Janicek
Pavel Janicek

Reputation: 14748

As one of affected people, I finally found solution:

If this appears, run lsnrctl start as an administrator to start the listener.

Most probably your listener.ova and tnsnames.ova are improperly set.

Upvotes: 3

Bohemian
Bohemian

Reputation: 425358

There is insufficient detail about the error to know what the problem is, however my guess is that subsequent instances are attempting to use the same resource as the already started instance, most likely the port.

Nevertheless, your problem can be solved by not creating multiple instances of Oracle, but rather creating multiple databases in the one Oracle instance.

It is a virtual certainty that your teacher did not intend you to start multiple instances of Oracle.

Upvotes: 1

Related Questions