startup mount pfile='/uatdb/app/oraascp/db/11.2.0/dbs/initASR.ora';
supplier creation - stgi
alter system set service_names='ASR' scope=spfile;
SQL> alter system set service_names='edstevens' scope=spfile;
alter system set db_domain='ebs.in' scope=spfile;
startup force;
!lsnrctl stop
SQL> alter system register;
SQL> !lsnrctl status
SQL> show parameter db_name;
SQL> show parameter service_names;
SQL> show parameter db_domain;
emca -config dbcontrol db -repos recreate
emctl start dbconsole
OC4J Configuration issue. /uatdb/app/oraascp/db/11.2.0/oc4j/j2ee/OC4J_DBConsole_TJPSB007.ebs.in_ASR not found.
cd
[oraascp@TJPSB007 bin]$ vncserver
You will require a password to access your desktops.
Password:
Verify:
xauth: file /home/oraascp/.Xauthority does not exist
New 'TJPSB007.ebs.in:1 (oraascp)' desktop is TJPSB007.ebs.in:1
Creating default startup script /home/oraascp/.vnc/xstartup
Starting applications specified in /home/oraascp/.vnc/xstartup
Log file is /home/oraascp/.vnc/TJPSB007.ebs.in:1.log
https://docs.oracle.com/cd/E11882_01/server.112/e25494/dbcontrol.htm#ADMIN13414
https://g7schools.wordpress.com/2015/03/12/oc4j-configuration-issue-oracle_homeoc4jj2eeoc4j_dbconsole__-not-found/
http://facedba.blogspot.com/2014/10/fix-oc4j-configuration-issue-while.html
http://oracleacedba.blogspot.com/2010/08/error-starting-dbconsole-service-oc4j.html#!/2010/08/error-starting-dbconsole-service-oc4j.html
https://dbatricksworld.com/oracle-enterprise-manager-failed-to-start-oc4j-configuration-issue-configure-enterprise-manager-database-control-manually-with-enterprise-manager-configuration-assistant/
http://vikaskohlioracledba.blogspot.com/2012/11/steps-to-configure-oracle-11g-oem.html#!/2012/11/steps-to-configure-oracle-11g-oem.html
https://gerardnico.com/db/oracle/oracledb_emca_how_to_reconfigure
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/2day_dba/gettingstarted/gettingstarted.htm
https://gerardnico.com/db/oracle/database_control
OCA:
https://education.oracle.com/oracle-database-11g-administrator-certified-associate/trackp_50
https://blogs.oracle.com/certification/the-secret-to-choosing-the-oracle-database-certification-that-is-right-for-you
https://education.oracle.com/products/pexam_1Z0-071
https://education.oracle.com/oracle-database/oracle-database-11g/product_163?certPage=true
opp error:
http://oracletechdba.blogspot.com/2015/03/concurrent-opp-response-timeout-to.html
http://m-burhan.blogspot.com/2016/04/output-post-post-processor-error.html
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export PATH
export ORACLE_HOME=/uatdb/app/oraascp/db/11.2.0/
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export ORACLE_SID=ASR
export ORACLE_UNQNAME=ASR
export ORACLE_HOSTNAME=TJPSB007
mkdir -p /uatdb/app/oraascp/db1
chown -R oraascp:dba /uatdb/app/oraascp/db1
chmod -R 755 /uatdb/app/oraascp/db1
mkdir -p /uatdb/app/oraascp/db1/archive
chown -R oraascp:dba /uatdb/app/oraascp/db1/archive
chmod -R 755 /uatdb/app/oraascp/db1/archive
cd /ascptest_arch/sky/product/11.2.0/db_2/oc4j/j2ee/
cp -R OC4J_DBConsole_tjps011.ebs.in_moon OC4J_DBConsole_tjps011.ebs.in_SKY
cd /ascptest_arch/sky/product/11.2.0/db_2/
cp -Rv tjps011.ebs.in_moon tjps011.ebs.in_SKY
[sky@tjps011 bin]$ ./emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://tjps011.ebs.in:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /ascptest_arch/sky/product/11.2.0/db_2/tjps011.ebs.in_SKY/sysman/log
. /uatdb/app/oraascp/db/11.2.0/ASR_tjpsb007.env
/uatdb/app/oraascp/db/11.2.0/bin
[oraascp@TJPSB007 bin]$ ./emctl status dbconsole
OC4J Configuration issue. /uatdb/app/oraascp/db/11.2.0/oc4j/j2ee/OC4J_DBConsole_TJPSB007.ebs.in_ASR1 not found.
EM Configuration issue. /uatdb/app/oraascp/db/11.2.0/TJPSB007.ebs.in_ASR1 not found.
emca -config dbcontrol db -repos recreate
1) Listener port 1582 provided is incorrect. Provide the correct port.
2) Listener is not up. Start the Listener.
3) Database service ASR.ebs.in is not registered with listener. Register the database service.
4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset ORACLE_HOSTNAME environment variable.
5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=<virtual host>.
6) /etc/hosts does not have correct entry for hostname.
Configure SELINUX=disabled in the /etc/selinux/config file:
How To Drop, Create And Recreate Database Control (dbconsole) Web Site in Releases 10g and 11g (Doc ID 278100.1)
Master Note for Enterprise Manager Configuration Assistant (EMCA) in Single Instance Database Environment (Doc ID 1099271.1)
How To Check Pre-requisites for Successful Execution of EMCA Commands in Single Instance Database Environment (Doc ID 1113343.1)
emca -deconfig dbcontrol db -repos drop
>emca -config dbcontrol db
SEVERE: Password file may be missing or configured incorrectly.
Sep 12, 2018 11:06:11 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /uatdb/app/oraascp/db/11.2.0/cfgtoollogs/emca/ASR/emca_2018_09_12_11_05_48.log.
Sep 12, 2018 11:06:12 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Password file may be missing or configured incorrectly.
Refer to the log file at /uatdb/app/oraascp/db/11.2.0/cfgtoollogs/emca/ASR/emca_2018_09_12_11_05_48.log for more details.
Could not complete the configuration. Refer to the log file at /uatdb/app/oraascp/db/11.2.0/cfgtoollogs/emca/ASR/emca_2018_09_12_11_05_48.log for more details.
/uatdb/app/oraascp/db/11.2.0/admin/ASR_tjpsb007/diag/rdbms/asr/ASR/trace
>ORA-01918: user 'SYSMAN' does not exist
$ORACLE_HOME/sysman/admin/emdrep/bin/RepManager antarctic 2483 sprod -action drop
$ORACLE_HOME/sysman/admin/emdrep/bin/RepManager TJPSB007 1582 ASR -action drop
Quest>How to register local listener.
1582
http://anuj-singh.blogspot.com/2011/05/how-to-set-locallistener.html
SQL> show parameter local;
T1000
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string ASR_LOCAL
log_archive_local_first boolean TRUE
parallel_force_local boolean FALSE
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.2.210)(PORT=1521))';
System altered.
alter system set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=172.16.2.65)(PORT=1582))';
ALTER SYSTEM SET LOCAL_LISTENER='listener_alias';
ALTER SYSTEM SET LOCAL_LISTENER='ASR'
alter system register;
tnsping ASR
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 12-SEP-2018 12:13:30
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/uatdb/app/oraascp/db/11.2.0/network/admin/ASR_tjpsb007/sqlnet_ifile.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = TJPSB007)(PORT = 1582))) (CONNECT_DATA = (SERVICE_NAME = ASR)))
OK (10 msec)
ALTER SYSTEM SET LOCAL_LISTENER='ASR' scope=both sid='*' ;
SQL> alter system register;
System altered.
SQL> show parameter local_list
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS = (PROTOCOL=TCP)(HOST
=192.168.2.210)(PORT=1521))
******************************************************88
DBD ERROR: OCISessionBegin
http://www.acehints.com/2011/06/troubleshoot-fix-emca-could-not-connect.html
orapwd file=orapw$ORACLE_SID password=manager1 entries=5
/uatdb/app/oraascp/db/11.2.0/dbs
orapwASR
password=<systempassword> entries=5
Step 3. Set following environment parameters
export TNS_ADMIN=$ORACLE_HOME/network/admin
export HOSTNAME=<HOSTNAME mentioned in listener.ora>
export ORACLE_SID=PROD9
export ORACLE_HOME= /data/oracle/product/11.1.0
export TNS_ADMIN=$ORACLE_HOME/network/admin
export HOSTNAME=TJPSB007.ebs.in
export ORACLE_SID=ASR
export ORACLE_HOME= /data/oracle/product/11.1.0
./emctl status dbconsole
SEVERE: Error parsing XML file /uatdb/app/oraascp/db/11.2.0/oc4j/j2ee/OC4J_DBConsole/config/server.xml
Sep 12, 2018 1:18:23 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error instantiating OC4J configuration files
Refer to the log file at /uatdb/app/oraascp/db/11.2.0/cfgtoollogs/emca/ASR/emca_2018_09_12_13_10_17.log for more details.
Could not complete the configuration. Refer to the log file at /uatdb/app/oraascp/db/11.2.0/cfgtoollogs/emca/ASR/emca_2018_09_12_13_10_17.log for more details.
https://TJPSB007.ebs.in:1158/em/console/aboutApplication
supplier creation - stgi
alter system set service_names='ASR' scope=spfile;
SQL> alter system set service_names='edstevens' scope=spfile;
alter system set db_domain='ebs.in' scope=spfile;
startup force;
!lsnrctl stop
SQL> alter system register;
SQL> !lsnrctl status
SQL> show parameter db_name;
SQL> show parameter service_names;
SQL> show parameter db_domain;
emca -config dbcontrol db -repos recreate
emctl start dbconsole
OC4J Configuration issue. /uatdb/app/oraascp/db/11.2.0/oc4j/j2ee/OC4J_DBConsole_TJPSB007.ebs.in_ASR not found.
cd
[oraascp@TJPSB007 bin]$ vncserver
You will require a password to access your desktops.
Password:
Verify:
xauth: file /home/oraascp/.Xauthority does not exist
New 'TJPSB007.ebs.in:1 (oraascp)' desktop is TJPSB007.ebs.in:1
Creating default startup script /home/oraascp/.vnc/xstartup
Starting applications specified in /home/oraascp/.vnc/xstartup
Log file is /home/oraascp/.vnc/TJPSB007.ebs.in:1.log
https://docs.oracle.com/cd/E11882_01/server.112/e25494/dbcontrol.htm#ADMIN13414
https://g7schools.wordpress.com/2015/03/12/oc4j-configuration-issue-oracle_homeoc4jj2eeoc4j_dbconsole__-not-found/
http://facedba.blogspot.com/2014/10/fix-oc4j-configuration-issue-while.html
http://oracleacedba.blogspot.com/2010/08/error-starting-dbconsole-service-oc4j.html#!/2010/08/error-starting-dbconsole-service-oc4j.html
https://dbatricksworld.com/oracle-enterprise-manager-failed-to-start-oc4j-configuration-issue-configure-enterprise-manager-database-control-manually-with-enterprise-manager-configuration-assistant/
http://vikaskohlioracledba.blogspot.com/2012/11/steps-to-configure-oracle-11g-oem.html#!/2012/11/steps-to-configure-oracle-11g-oem.html
https://gerardnico.com/db/oracle/oracledb_emca_how_to_reconfigure
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/2day_dba/gettingstarted/gettingstarted.htm
https://gerardnico.com/db/oracle/database_control
OCA:
https://education.oracle.com/oracle-database-11g-administrator-certified-associate/trackp_50
https://blogs.oracle.com/certification/the-secret-to-choosing-the-oracle-database-certification-that-is-right-for-you
https://education.oracle.com/products/pexam_1Z0-071
https://education.oracle.com/oracle-database/oracle-database-11g/product_163?certPage=true
opp error:
http://oracletechdba.blogspot.com/2015/03/concurrent-opp-response-timeout-to.html
http://m-burhan.blogspot.com/2016/04/output-post-post-processor-error.html
# User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export PATH
export ORACLE_HOME=/uatdb/app/oraascp/db/11.2.0/
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export ORACLE_SID=ASR
export ORACLE_UNQNAME=ASR
export ORACLE_HOSTNAME=TJPSB007
mkdir -p /uatdb/app/oraascp/db1
chown -R oraascp:dba /uatdb/app/oraascp/db1
chmod -R 755 /uatdb/app/oraascp/db1
mkdir -p /uatdb/app/oraascp/db1/archive
chown -R oraascp:dba /uatdb/app/oraascp/db1/archive
chmod -R 755 /uatdb/app/oraascp/db1/archive
cd /ascptest_arch/sky/product/11.2.0/db_2/oc4j/j2ee/
cp -R OC4J_DBConsole_tjps011.ebs.in_moon OC4J_DBConsole_tjps011.ebs.in_SKY
cd /ascptest_arch/sky/product/11.2.0/db_2/
cp -Rv tjps011.ebs.in_moon tjps011.ebs.in_SKY
[sky@tjps011 bin]$ ./emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
https://tjps011.ebs.in:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /ascptest_arch/sky/product/11.2.0/db_2/tjps011.ebs.in_SKY/sysman/log
. /uatdb/app/oraascp/db/11.2.0/ASR_tjpsb007.env
/uatdb/app/oraascp/db/11.2.0/bin
[oraascp@TJPSB007 bin]$ ./emctl status dbconsole
OC4J Configuration issue. /uatdb/app/oraascp/db/11.2.0/oc4j/j2ee/OC4J_DBConsole_TJPSB007.ebs.in_ASR1 not found.
EM Configuration issue. /uatdb/app/oraascp/db/11.2.0/TJPSB007.ebs.in_ASR1 not found.
emca -config dbcontrol db -repos recreate
1) Listener port 1582 provided is incorrect. Provide the correct port.
2) Listener is not up. Start the Listener.
3) Database service ASR.ebs.in is not registered with listener. Register the database service.
4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset ORACLE_HOSTNAME environment variable.
5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=<virtual host>.
6) /etc/hosts does not have correct entry for hostname.
Configure SELINUX=disabled in the /etc/selinux/config file:
How To Drop, Create And Recreate Database Control (dbconsole) Web Site in Releases 10g and 11g (Doc ID 278100.1)
Master Note for Enterprise Manager Configuration Assistant (EMCA) in Single Instance Database Environment (Doc ID 1099271.1)
How To Check Pre-requisites for Successful Execution of EMCA Commands in Single Instance Database Environment (Doc ID 1113343.1)
emca -deconfig dbcontrol db -repos drop
>emca -config dbcontrol db
SEVERE: Password file may be missing or configured incorrectly.
Sep 12, 2018 11:06:11 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /uatdb/app/oraascp/db/11.2.0/cfgtoollogs/emca/ASR/emca_2018_09_12_11_05_48.log.
Sep 12, 2018 11:06:12 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Password file may be missing or configured incorrectly.
Refer to the log file at /uatdb/app/oraascp/db/11.2.0/cfgtoollogs/emca/ASR/emca_2018_09_12_11_05_48.log for more details.
Could not complete the configuration. Refer to the log file at /uatdb/app/oraascp/db/11.2.0/cfgtoollogs/emca/ASR/emca_2018_09_12_11_05_48.log for more details.
/uatdb/app/oraascp/db/11.2.0/admin/ASR_tjpsb007/diag/rdbms/asr/ASR/trace
>ORA-01918: user 'SYSMAN' does not exist
$ORACLE_HOME/sysman/admin/emdrep/bin/RepManager antarctic 2483 sprod -action drop
$ORACLE_HOME/sysman/admin/emdrep/bin/RepManager TJPSB007 1582 ASR -action drop
Quest>How to register local listener.
1582
http://anuj-singh.blogspot.com/2011/05/how-to-set-locallistener.html
SQL> show parameter local;
T1000
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string ASR_LOCAL
log_archive_local_first boolean TRUE
parallel_force_local boolean FALSE
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string
SQL> alter system set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=192.168.2.210)(PORT=1521))';
System altered.
alter system set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=172.16.2.65)(PORT=1582))';
ALTER SYSTEM SET LOCAL_LISTENER='listener_alias';
ALTER SYSTEM SET LOCAL_LISTENER='ASR'
alter system register;
tnsping ASR
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 12-SEP-2018 12:13:30
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/uatdb/app/oraascp/db/11.2.0/network/admin/ASR_tjpsb007/sqlnet_ifile.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = TJPSB007)(PORT = 1582))) (CONNECT_DATA = (SERVICE_NAME = ASR)))
OK (10 msec)
ALTER SYSTEM SET LOCAL_LISTENER='ASR' scope=both sid='*' ;
SQL> alter system register;
System altered.
SQL> show parameter local_list
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (ADDRESS = (PROTOCOL=TCP)(HOST
=192.168.2.210)(PORT=1521))
******************************************************88
DBD ERROR: OCISessionBegin
http://www.acehints.com/2011/06/troubleshoot-fix-emca-could-not-connect.html
orapwd file=orapw$ORACLE_SID password=manager1 entries=5
/uatdb/app/oraascp/db/11.2.0/dbs
orapwASR
password=<systempassword> entries=5
Step 3. Set following environment parameters
export TNS_ADMIN=$ORACLE_HOME/network/admin
export HOSTNAME=<HOSTNAME mentioned in listener.ora>
export ORACLE_SID=PROD9
export ORACLE_HOME= /data/oracle/product/11.1.0
export TNS_ADMIN=$ORACLE_HOME/network/admin
export HOSTNAME=TJPSB007.ebs.in
export ORACLE_SID=ASR
export ORACLE_HOME= /data/oracle/product/11.1.0
./emctl status dbconsole
SEVERE: Error parsing XML file /uatdb/app/oraascp/db/11.2.0/oc4j/j2ee/OC4J_DBConsole/config/server.xml
Sep 12, 2018 1:18:23 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error instantiating OC4J configuration files
Refer to the log file at /uatdb/app/oraascp/db/11.2.0/cfgtoollogs/emca/ASR/emca_2018_09_12_13_10_17.log for more details.
Could not complete the configuration. Refer to the log file at /uatdb/app/oraascp/db/11.2.0/cfgtoollogs/emca/ASR/emca_2018_09_12_13_10_17.log for more details.
https://TJPSB007.ebs.in:1158/em/console/aboutApplication
No comments:
Post a Comment