Re: After Creating New Dtabase...

From: Arijit Chatterjee <arijitchatterjee123_at_yahoo.co.in>
Date: 17 Jun 2004 21:16:26 -0700
Message-ID: <ea01504d.0406172016.34ae77b9@posting.google.com>

Thanks Howard
Thanks Once Again.But the problem still there. When I am typing system/password_at_seconddb
getting

ORA-12541: TNS:no listener

And

system/password_at_FirstDb
getting

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

Few days before when I faced same error(On that time FirstDb was only there) I type

connect / as sysdba
startup

I do the same,successful mounting is there but still same error is coming.

I am giving the details in my two .ora ora files.

listener.ora Containing

LISTENER1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <HostName>)(PORT = 1523))
)

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

tnsnames.ora Containing

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 = 1523))     )
(CONNECT_DATA =

      (SERVICE_NAME = SecondDb)
    )
  )

Regards
Arijit Chatterjee Received on Thu Jun 17 2004 - 23:16:26 CDT