Re: Manually starting services in Windows XP

DA Morgan wrote:

> Jining Han wrote:
>
> > If I remember correctly, Oracle instructs to start the listeners

> > then database
> >
> > Jining Han
>
> Correct. The database will automatically register with the listener
> if the listener is already started.
>

This is correct if you are on 8i (8.1.x) and above. This is because you don't have to have a static entry in the listener.ora file as, sid_desc =
sid_name = ....
which means it doesn't matter when the listener is started, before or afterwards, it will register all running instances. In pre 8.1.x releases, you had to have a static entry in the listener.ora file. I have LOC920 database and LISTENER92 listener,

C:\>net start OracleServiceLOC920
The OracleServiceLOC920 service is starting. The OracleServiceLOC920 service was started successfully.

C:\>net start OracleOraHome92TNSListenerLISTENER92 The OracleOraHome92TNSListenerLISTENER92 service is starting. The OracleOraHome92TNSListenerLISTENER92 service was started successfully.

<<Wait for about 30 seconds here>>

C:\>lsnrctl status listener92

LSNRCTL for 32-bit Windows: Version 9.2.0.5.0 - Production on 24-JAN-2005 18:13:12 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

<snip>

Services Summary...
Service "LOC920" has 1 instance(s).
Instance "LOC920", status READY, has 1 handler(s) for this service... Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

C:\>net stop OracleServiceLOC920
The OracleServiceLOC920 service is stopping. The OracleServiceLOC920 service was stopped successfully.

C:\>lsnrctl status listener92

LSNRCTL for 32-bit Windows: Version 9.2.0.5.0 - Production on 24-JAN-2005 18:14:12 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

<snip>

Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

C:\>net start OracleServiceLOC920
The OracleServiceLOC920 service is starting. The OracleServiceLOC920 service was started successfully.

C:\>lsnrctl status listener92

LSNRCTL for 32-bit Windows: Version 9.2.0.5.0 - Production on 24-JAN-2005 18:14:54 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

<snip>

Services Summary...
Service "LOC920" has 1 instance(s).
Instance "LOC920", status READY, has 1 handler(s) for this service... Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

And here is my listener.ora file
SID_LIST_LISTENER92 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)

)
)

LISTENER92 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.xx.xx)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)

    )
  )

Regards
/Rauf Received on Mon Jan 24 2005 - 12:35:36 CST