portfoliogugl.blogg.se -

ORACLE11G DROPKEY HOW TO

ORACLE11G DROPKEY HOW TO

How to we avoid this behaviour? Is there a special method to deal with old (migrated) primary keys/indexes? now only the primary key xpk_test is dropped, the index xpk_test stays make an dump with exp and import it on Oracle 10ĪLTER TABLE test DROP CONSTRAINT xpk_test Oracle 10 does not drop the unique Index created with the primary key!ĪLTER TABLE test ADD CONSTRAINT xpk_test PRIMARY KEY ( pk ) Create a primary key under Oracle 9 and export the Database

If the database is transferred from Oracle 9 to 10 between both statements the index persists. This works fine as long as both statements (create and drop) are performed on either Oracle 9 or Oracle 10, i.e. When the pk is dropped the index is dropped too. When creating PKs, oracle automatically adds a unique index to hold the primary key rule. We have a problem with an auto-index from a primary key (PK), which is not dropped when removing the PK.

1.7K Training / Learning / Certification.

165.3K Java EE (Java Enterprise Edition).

7.9K Oracle Database Express Edition (XE).

3.8K Java and JavaScript in the Database.

Resource /em/database/instance/sitemap/sitemap. The link Database gives me again the error There is a Menu with Database, Setup, Preferences, Help and Logout at the bottom of the page. log in as "sys as sysadm" and again I get the error SQL> exec mgmt_t_agent_tzrgn(':3938','Europe/Berlin')Īfter recreating db control files and repository I also updated the timezone as suggested at last but unfortunately it doesn't solve my problem. This can be done for example by logging into sqlplus and doing Login as the em repository user and run the script:Įxec mgmt_t_agent_tzrgn(':3938','Europe/Berlin') Successfully updated /opt/oracle/product/11.2.0.4/db_1/_/sysman/config/emd.properties. Updating /opt/oracle/product/11.2.0.4/db_1/_/sysman/config/emd.properties. Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service. Instance "COMASORA11", status READY, has 1 handler(s) for this service. Service "COMASORA11XDB" has 1 instance(s). Instance "COMASORA11", status UNKNOWN, has 1 handler(s) for this service. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))) Listener Log File /opt/oracle/diag/tnslsnr//listener/alert/log.xml Listener Parameter File /opt/oracle/product/11.2.0.4/db_1/network/admin/listener.ora Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production All rights reserved.Ĭonnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) Logs are generated in directory /opt/oracle/product/11.2.0.4/db_1_/sysman/log Oracle Enterprise Manager 11g is running. Last successful heartbeat to OMS : 15:15:05

Size of XML files pending upload(MB) : 0.00Īvailable disk space on upload filesystem : 72.22%ĭata channel upload directory : /opt/oracle/product/11.2.0.4/db_1/_/sysman/recv Total Megabytes of XML files uploaded so far : 11.07

All rights reserved.Īgent Home : /opt/oracle/product/11.2.0.4/db_1/_Īgent binaries : /opt/oracle/product/11.2.0.4/db_1Īgent URL : Repository URL : Started at : 15:13:58 Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0Ĭopyright (c) 1996, 2009 Oracle Corporation. emca -config dbcontrol db -repos create removed $ORACLE_HOME/_ and $ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_

emca -deconfig dbcontrol db -repos drop Unfortunately I still have the same error! How can I fix this problems above or simply how can I clear the EM configuration and reinstall EM completely? SERVER/sysman/config/emkey.ora is corrupted or contains an invalid Em Key. Sais that the Em Key is not configured properly.Įmctl config emkey -emkeyfile SERVER/sysman/config/emkey.ora -force Please consult the application log for details. The current application deployment descriptors do not allow for including it in this response. Resource /em/database/instance/sitemap/sitemap.jsp/page/internalError not found on this server But after logging in I only get the error page My browser opens that URL and shows the Oracle Enterprise Database Control login page. as well as it showed the path to the key emkey.ora. I've tried running all configuration steps in dbca and in the end it said that the database control is We have installed Oracle 11.2.0.4 but the Enterprise Manager was never working.