Re: After Creating New Dtabase...

From: Arijit Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 18 Jun 2004 21:18:11 -0700
Message-ID: <ea01504d.0406182018.4dda43dd@posting.google.com>

Thanks Howard,
Thanks for your king help.Atlast I got may FirstDB.As per your instruction I did all the step and successfuly recover my FirstDB. But in the case of SecondDb(After oracle_sid changing to seconddb) it is telling for username scott

ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor

But when I created the database I got a message box userid "change_on_install"
and password "manager" and sid is secondDB.

But for userid also giving the same error. Now I am giving my LISTENER.ORA and TNSNAMES.ORA details. Need any more modification and what about userid and password???

TNSNAMES.ORA details

FirstDb =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <Hostname>)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = FirstDb )
    )
  )

SecondDB =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <Hostname>)(PORT = 1521))     )
    (CONNECT_DATA =
      (SERVICE_NAME = SecondDB )
    )
  )

LISTENER.ORA details

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <Hostname>)(PORT = 1521)) )

If you have time then oly response me.Unless I will delete the SeondDB and recreate that.
And one more thing
In my services yesterday I observer three more services have added automatically.

1.OracleiSuitesTNSListenerFirstDb
2.OracleiSuitesTNSListenerlsnr
3.OracleiSuitesTNSListenerSecondDb

Once I created these through listener interface.Now when I trying to start this telling error

The OracleiSuitesTNSListenerSYSTELLIST service is starting. The OracleiSuitesTNSListenerSYSTELLIST service could not be started.

The service did not report an error.

More help is available by typing NET HELPMSG 3534.

Is there any need for these services??If not how to remove these. Thsnks once again.
Regards
Arijit Chatterjee Received on Fri Jun 18 2004 - 23:18:11 CDT