Hi Ernesta,
No, your Windows Services file does not need the Oracle listener Port. You must, however, have the Oracle listener up and running while you run the startsap script. Otherwise you will get a message that says "R3trans cannot connect to the database."
Take a look at your startsap.log file, and reply here with the error that you have found there.
Troy
Hi Ernesta,
I think you are focusing on the Oracle instance prematurely, with no errors pointing to that. In my experience, once Oracle sets up the TNSNAMES and Listener, you do not need to change them, unless you are adding more Oracle DB's onto this system.
If you want to verify that the listener is up and running, log in as ora<sid>, and run "lsnrctl status"
to start: "lsnrctl start"
to stop: "lsnrctl stop"
Make certain it is running, and you should be fine, if you haven't changed the configuration since the system was installed.
Take a look at the sapstart.log file in the <SID>adm home directory, and there should be an error therein.
Other than that, check the Work directory at:
/usr/sap/<SID>/DVEBMGS00/work
and sort the files by time last created (ls -al) and read through the first 6 or so. This should give you a really good idea of what is causing you the trouble. Again, though, the SAPSTART.LOG file should tell you this explicitly, so start there. If you are uncertain what the messages mean, re-post them here, so that we can help to decipher them.
Cheers,
Troy
Here's the corresponding Listener.ora file:
LISTENER.ORA Network Configuration File: /oracle/QE1/817_64/network/admin/listener.ora
Generated by Oracle configuration tools.
STARTUP_WAIT_TIME_LISTENER = 0
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname002)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = hostname002)(PORT = 2481))
)
)
CONNECT_TIMEOUT_LISTENER = 10
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = QE1)
(ORACLE_HOME = /oracle/QE1/817_64)
(SID_NAME = QE1)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/QE1/817_64)
(PROGRAM = extproc)
)
)
TRACE_LEVEL_LISTENER = OFF
Add comment