on 01-31-2011 10:11 AM
Hello Experts,
I am a freshers in basis with 11 months of experience. I am facing a problem. My jcontrol dosent start up. My system is not dual stack, its abap and java independent and the problem i am facing in BI -Quality-Java system.
I am posting the trace file
[Thr 1] JStartupICheckFrameworkPackage: can't find framework package /usr/sap/BQJ/JC01/work/jvmx.jar
**********************************************************************
JStartupIReadSection: read node properties [bootstrap]
-> node name : bootstrap
-> node type : bootstrap
-> node execute : yes
-> java path : /usr/jdk/j2sdk1.4.2_22
-> java parameters : -Djco.jarm=1
-> java vm version : 1.4.2_22-b02
-> java vm vendor : Java HotSpot(TM) 64-Bit Server VM (Sun Microsystems Inc.)
-> java vm type : server
-> java vm cpu : sparcv9
-> heap size : 256M
-> root path : /usr/sap/BQJ/JC01/j2ee/cluster
-> class path : ./bootstrap/launcher.jar
-> OS libs path : /usr/sap/BQJ/JC01/j2ee/os_libs
-> main class : com.sap.engine.offline.OfflineToolStart
-> framework class : com.sap.bc.proj.jstartup.JStartupFramework
-> registr. class : com.sap.bc.proj.jstartup.JStartupNatives
-> framework path : /usr/sap/BQJ/JC01/work/jstartup.jar:/usr/sap/BQJ/JC01/work/jvmx.jar
-> parameters : com.sap.engine.bootstrap.Bootstrap ./bootstrap ID0163687
-> debuggable : yes
-> debug mode : no
-> debug port : 60000
-> shutdown timeout : 120000
**********************************************************************
**********************************************************************
JControlStartJLaunch: program = /usr/sap/BQJ/JC01/exe/jlaunch
-> arg[00] = /usr/sap/BQJ/JC01/exe/jlaunch
-> arg[01] = pf=/usr/sap/BQJ/SYS/profile/BQJ_JC01_BIQAS
-> arg[02] = -DSAPINFO=BQJ_01_bootstrap
-> arg[03] = -nodeId=-1
-> arg[04] = -file=/usr/sap/BQJ/JC01/j2ee/cluster/instance.properties
-> arg[05] = -syncSem=98
-> arg[06] = -nodeName=bootstrap
-> arg[07] = -jvmOutFile=/usr/sap/BQJ/JC01/work/jvm_bootstrap.out
-> arg[08] = -stdOutFile=/usr/sap/BQJ/JC01/work/std_bootstrap.out
-> arg[09] = -locOutFile=/usr/sap/BQJ/JC01/work/dev_bootstrap
-> arg[10] = -mode=BOOTSTRAP
-> arg[11] = pf=/usr/sap/BQJ/SYS/profile/BQJ_JC01_BIQAS
-> lib path = LD_LIBRARY_PATH=/usr/j2se/jre/lib/sparcv9/server:/usr/j2se/jre/lib/sparcv9:/usr/j2se/jre/../lib/sparcv9:/usr/sap/BQJ/JC01/exe:/usr/sap/BQJ/JC01/exe:/tmp/sapinst_exe.3559.1288088561:/usr/openwin/lib:/usr/sap/BQJ/SYS/exe/run:/oracle/client/10x_64/instantclient:/usr/lib:/usr/sap/BQJ/JC01/j2ee/os_libs:/usr/sap/BQJ/JC01/exe:/usr/sap/BQJ/JC01/exe:/usr/sap/BQJ/SYS/exe/run:/oracle/client/10x_64/instantclient
-> exe path = PATH=/usr/jdk/j2sdk1.4.2_22/bin:/usr/sap/BQJ/JC01/j2ee/os_libs:/oracle/BQJ/102_64/bin:/usr/jdk/j2sdk1.4.2_22/bin:/usr/sap/bqjadm:/usr/sap/BQJ/SYS/exe/run:/usr/bin:.:/usr/ccs/bin:/usr/ucb
**********************************************************************
[Thr 1] JStartupICreateProcess: fork process (pid 24909)
[Thr 1] Thu Jan 27 20:08:16 2011
[Thr 1] *** ERROR => invalid return code of process [bootstrap] (exitcode = 66) [jstartxx_mt. 1642]
[Thr 1] JControlExecuteBootstrap: error executing bootstrap node [bootstrap] (rc = 66)
[Thr 1] JControlCloseProgram: started (exitcode = 66)
[Thr 1] JControlCloseProgram: good bye... (exitcode = 66)
In log_bootstrap it shows:-
[Jan 27, 2011 8:08:16 PM ] Exception occurred:
com.sap.engine.bootstrap.SynchronizationException: Database initialization failed! Check database properties!
at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:476)
at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:146)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:971)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:331)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
-
==[ Caused by: ]==----
com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB.
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:364)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.<init>(DBConnectionPool.java:129)
at com.sap.engine.core.configuration.impl.persistence.rdbms.PersistenceHandler.<init>(PersistenceHandler.java:38)
at com.sap.engine.core.configuration.impl.cache.ConfigurationCache.<init>(ConfigurationCache.java:149)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.init(ConfigurationManagerBootstrapImpl.java:236)
at com.sap.engine.core.configuration.bootstrap.ConfigurationManagerBootstrapImpl.<init>(ConfigurationManagerBootstrapImpl.java:49)
at com.sap.engine.bootstrap.Synchronizer.<init>(Synchronizer.java:74)
at com.sap.engine.bootstrap.Bootstrap.initDatabaseConnection(Bootstrap.java:473)
at com.sap.engine.bootstrap.Bootstrap.<init>(Bootstrap.java:146)
at com.sap.engine.bootstrap.Bootstrap.main(Bootstrap.java:971)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:331)
at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)
Caused by: java.sql.SQLException: ORA-00257: archiver error. Connect internal only, until freed.
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOsesskey(T4CTTIoauthenticate.java:294)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:357)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at com.sap.sql.jdbc.NativeConnectionFactory.createNativeConnection(NativeConnectionFactory.java:215)
at com.sap.sql.connect.OpenSQLDataSourceImpl.createPooledConnection(OpenSQLDataSourceImpl.java:608)
at com.sap.sql.connect.OpenSQLDataSourceImpl.getPooledConnection(OpenSQLDataSourceImpl.java:285)
at com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:306)
... 14 more
[Jan 27, 2011 8:08:16 PM ] [Bootstrap module]> Problem occurred while performing synchronization.
Check
- listener is running (lsnrctl status) and start if it is not started already
- You can connect to oracle with sqlplus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi everybody..
My Jcontrol is up and running after we restarted my BQJ server once again yeaterday. I think it was due to the fact that previously listener was not running.
<< Moderator message - Please do not promise points >>
Now please help me with my archive log issue.. I a going o post it today only. Will I continue in this or create a new thread? I seek your advice.
Edited by: Rob Burbank on Feb 1, 2011 5:33 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
SQL> show parameter archive
NAME TYPE VALUE
-
-
-
archive_lag_target integer 0
log_archive_config string
log_archive_dest string /oracle/BQJ/oraarch/BQJarch
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
NAME TYPE VALUE
-
-
-
log_archive_dest_8 string
log_archive_dest_9 string
log_archive_dest_state_1 string enable
log_archive_dest_state_10 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
log_archive_dest_state_6 string enable
log_archive_dest_state_7 string enable
log_archive_dest_state_8 string enable
NAME TYPE VALUE
-
-
-
log_archive_dest_state_9 string enable
log_archive_duplex_dest string
log_archive_format string %t_%s_%r.dbf
log_archive_local_first boolean TRUE
log_archive_max_processes integer 2
log_archive_min_succeed_dest integer 1
log_archive_start boolean FALSE
log_archive_trace integer 0
remote_archive_enable string true
standby_archive_dest string ?/dbs/arch
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi both of you,
No i have not stopped and restarted the listener, But i will surely take your advice and do it and update u guys.
Thanks again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you both of u. I am looking into the SAP Note.
Any other suggestions from both of you, regarding the jcontrol issue???
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For Java issues I general I prefer checking /usr/sap/<SID>/j2ee/cluster/serverx/log directory and under there default.trc.
Just check the latest contents of default.trc.. May be there is a hint over there.
Seocndly go the kernel directory using sidadm (on Central Instance)and do
ldd dboraslib.so
It will let you know if sidadm is having access to oracle client or not.
Regards.
Ruchit.
In initBQJ.ora
*.log_archive_dest='/oracle/BQJ/oraarch/BQJarch'
Is this jcontrol problem related to this? Can i solve the jcontrol problem fast please or its dependent on the archive problem?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ruchit,
Yes I have seen my oraarch directory. there is a free space of 29GB, so i dont think there's a archive stuck problem, but actually the problem was
Whenever I was taking backup by brtools it gave a warning
There has been no problem except in system BI-Quality Java. In this system DB Backup is happening normally without any problem, it was only giving a warning
BR0335W Status of online redo log file /oracle/BQJ/mirrlogB/log_g12m2.dbf is INVALID
Now this file /oracle/BQJ/mirrlogB/log_g12m2.dbf is there in mirrorlogB and its dated 26-11.
Problem is next when I am taking archive log backup using brtools --> Database backup --> archivelog backup.It shows
BR0013W No offline Redologs found for processing. But when I am checking oraarch directory it shows archive files exists for those dates.
After reading from SDN, I did a log switch.
then later due to some work I restarted the database from that time this problem was showing in SAP MMC, though system was UP when i did startsap all..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Juan, thanx for prompt reply.
My system is currently running and users are logged on to the portal, will it not affect if I stop and start the Listener???
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
BIQAS:orabqj 2% lsnrctl start LISTENER_BQJ
LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 31-JAN-2011 18:24:19
Copyright (c) 1991, 2007, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER_BQJ has already been started
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
System was running previously. Its happening after the basis restarted the system on Thursday night, due to some activities.
Below r the contents of Listener.ora
################
Filename......: listener.ora
Created.......: created by SAP AG, R/3 Rel. >= 6.10
Name..........:
Date..........:
@(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#1 $
################
ADMIN_RESTRICTIONS_LISTENER_BQJ = on
LISTENER_BQJ =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = IPC)
(KEY = BQJ.WORLD)
)
(ADDRESS=
(PROTOCOL = IPC)
(KEY = BQJ)
)
(ADDRESS =
(COMMUNITY = SAP.WORLD)
(PROTOCOL = TCP)
(HOST = BIQAS)
(PORT = 1530)
)
)
STARTUP_WAIT_TIME_LISTENER_BQJ = 0
CONNECT_TIMEOUT_LISTENER_BQJ = 10
TRACE_LEVEL_LISTENER_BQJ = OFF
SID_LIST_LISTENER_BQJ =
(SID_LIST =
(SID_DESC =
(SID_NAME = BQJ)
(ORACLE_HOME = /oracle/BQJ/102_64)
)
)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI, thanks for all the replies.
When checking lsnrctl status - It gives
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Solaris Error: 146: Connection refused
Then I ran
lsnrctl start
it gives:-
BIQAS:orabqj 4% lsnrctl start
LSNRCTL for Solaris: Version 10.2.0.4.0 - Production on 31-JAN-2011 17:15:26
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Starting /oracle/BQJ/102_64/bin/tnslsnr: please wait...
TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
System parameter file is /oracle/BQJ/102_64/network/admin/listener.ora
Log messages written to /oracle/BQJ/102_64/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=BIQAS)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
-
Alias LISTENER
Version TNSLSNR for Solaris: Version 10.2.0.4.0 - Production
Start Date 31-JAN-2011 17:15:27
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/BQJ/102_64/network/admin/listener.ora
Listener Log File /oracle/BQJ/102_64/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=BIQAS)(PORT=1521)))
The listener supports no services
The command completed successfully
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I think I find your problem...
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
When checking the listener status your listener is looking into port 1521 (which is the standard)
(PORT = 1530)
But when you posted the contents of listener.ora the port is pointing to 1530???
Try setting you port to 1521 in listener.ora and restart the listener.
Regards
Juan
@Juan,
it could be because he started the default listener in this case which would invariable start at the default port 1521. You are checking that section I guess. I think correct listener LISTENER_BQJ is running at port 1530 only !
One option is to stop LISTENER_BQJ and then restart it to validate the port being used. Else use ntstat !
Regards.
Ruchit.
Database initialization failed! Check database properties!
Error while connecting to DB.
Seems like your DB is not running or your settings have changed.
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
any recent activities on the system???
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.