Dear Experts,
I could not startup SAP running on Oracle. My question is does use of listener port matter when starting SAP instance? What ports must be used to startup SAP? Does SAP rely on oracle listener port to startup or just oracle instance depends on it to startup itself? Must it be one and not the other? I have restored a MS-clustered SAP instance onto a separate machine without clustering i.e. standalone instance.
How is tnsnames.ora and listener.ora used and must the port number be set in windows services file?
Regards
Ernesta
5 Answers
-
Former MemberSep 20, 2005 at 06:30 PMHi 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
Add comment
-
Former MemberSep 26, 2005 at 03:18 PM
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
Add comment
-
Former MemberSep 29, 2005 at 06:27 PM
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
Add comment