Starting Dbconsole On Oracle 10g?
Sep 2, 2011
I cloned the oracle VM, was able to recreate the repository for em.
But its failing when i try to start it with following trace of errors
2011-09-02 17:22:59,502 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.ias.ias.IASIntegration
2011-09-02 17:22:59,753 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.eml.target.slb.common.SLBIntegration
2011-09-02 17:22:59,830 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.sysman.eml.ssl.intg.SSLIntegration
2011-09-02 17:22:59,898 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.tip.oem.central.domain.ProcessConnectDomainIntg
2011-09-02 17:22:59,908 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.tip.oem.central.instance.ProcessConnectInstanceIntg
2011-09-02 17:22:59,910 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.webdb.admin.em.PortalIntegration
2011-09-02 17:22:59,911 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.webdb.admin.em.SSOIntegration
2011-09-02 17:22:59,912 [Orion Launcher] ERROR app.ContextInitializer contextInitialized.272 - Integration Class not found: oracle.reports.em.RepIntg
View 1 Replies
ADVERTISEMENT
May 29, 2013
unable to start the DBCONSOLE immediately after installing Oracle 11G R2 onto my Windows 7 box. Here is what I have ran from the command line:
Microsoft Windows [Version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. All rights reserved.
C:Userssandifer>emctl start dbconsole
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.
C:Userssandifer>SET ORACLE_HOSTNAME=localhost
[code].....
I checked the above listed file path, and sure enough, OC4J_DBConsole_localhost_orcl is missing.
View 7 Replies
View Related
Oct 14, 2011
I am getting problem while starting the CRS. Below is the necessary details:
1) I am using oracle 11g R2 RAC, with 2 node named RAC1 and RAC2
2) I have 3 diskgroup named DATA, DATA1, DATA2
3) OCR and voting disks are stored on ASM diskgroup
On node RAC1, CRS is started and /etc/oracle/ocr.loc is having the below entry:
ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA1
On node RAC2, CRS is stopped and /etc/oracle/ocr.loc is having the below entry:
ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA2
Please note the difference in "ocrmirrorconfig_loc". The difference was occured because I updated the OCR location on RAC1 when RAC2 was down.
Now I am trying to repair the OCR on the RAC2 using below command. This command must be run as root user when HA service is started but CRS must be stopped.
ocrconfig -repair -replace +DAT2 -replacement +DATA1
but this showing error "PROT-21: Invalid parameter", because to run this command diskgroup must be mounted. But diskgroup cannot be mounted until the CRS start. SO this is a conflicting situation.
View 3 Replies
View Related
Jul 17, 2010
when i start the Oracle database, the database is mounted. Then when i issue the "alter database open resetlogs" command, i got the below error.
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/data/oracle/NYP15S1D/data03/SYSTEM_01.dbf'
So i added the parameter "_allow_resetlogs_corruption=TRUE" in "init.ORA" file to force open the database but the Oracle instance crashed with following message.
In the alert log the following error is there:
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [4000], [2], [], [], [], [], [], []
How can i resolve the issue?
Please note: the database is Oracle 9i, installed in UNIX AIX OS.
View 1 Replies
View Related
Oct 23, 2012
I'm using Oracle 11g running over a Windows 7 OS. The service OracleServiceORCL doesn't start. Listener.log has the following registry:
23-OCT-2012 19:45:29 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=MBA-DB$))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=49445)) * establish * orcl * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor
When I try to start in services, is returned the OS error 1067. This error starts to occur when I did the follow. I executed a PLSQL command to fill a (big) table with a lot of data. More than 1 day after and while the program still running, I broke the program. After that, Oracle was consuming lot of disk. I broke the process (using taskkill /f) and, after that, the database stopped working.
What I can do to recover my database?Below I list my listener.ora and tnsnames.ora
mbentoalves
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
[code]...
View 5 Replies
View Related
Mar 16, 2011
I am done with my configuration for oracle HS to connect to SQLserver. When I tried to start my listener, it is giving the following errors.
-----------------------------------------------------------------
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
System parameter file is D:oracleproduct10.2.0db_1
etworkadminlistener.or
a
Log messages written to D:oracleproduct10.2.0db_1
[code]..
Contents of my listener.ora file are below
--------------------------------------------------------------
LISTENERSQLODBC =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=
[code]...
View 1 Replies
View Related
May 3, 2013
today i have restarted the database server (11gR2) after that database service is not starting, the error message is
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0
View 8 Replies
View Related
Dec 5, 2011
I saw this thread:[URL]....
and checked to see if I could start:[URL]........
using Firefox 8.0 and found that I was "unable to connect". I found that although my OracleDBConsoleorcl service was set to automatic, it was not started. So, I attempted to start it from the Windows services menu, but received a message that Windows could not start it and it said to see the System Event Log. So, I checked the Windows System Event Log and found:
"The OracleDBConsoleorcl service terminated with service-specific error The system cannot find the file specified."but it does not tell me the name of the file or directory path. So, where do I go from here? I did not want to hijack the other thread, so I started a new one, especially since the original poster was able to start this service. Is there a different way to try to start the service that might provide more information?
I have been using this installation for a long time and seem to remember this working once upon a time, but I could be wrong. I don't usually use Enterprise Manager, so this is not something critical, just a curiosity, and something that I might like to explore. I have provided version and system info below.
-- Oracle version info:
SCOTT@orcl_11gR2> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
5 rows selected.
-- partial systeminfo (some lines like product key removed):
C:>systeminfo
OS Name: Microsoft Windows 7 Professional
OS Version: 6.1.7601 Service Pack 1 Build 7601
[code]...
View 1 Replies
View Related
Jun 10, 2011
When I am trying to enter to the enterprise manager of oracle 11g, but it is not working. In my services list the 'oracledbconsoleorcl' is assigned as automatically to start with windows. But it is not starting. When I tried to start it manually the following message is displayed repeatedly even after restarting the pc.
'Windows could not start the oracledbconsoleorcl on Local computer. For more information, view the system event log. If this is a non-Microsoft services, contact the service vendor, and refer to service-specific error code 2.'
In the event log the following error messages are displayed:The OracleDBConsoleorcl service terminated with service-specific error 2 (0x2). and
The OracleCSService service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion.
View 4 Replies
View Related
Dec 17, 2012
I’m wondering how other sites are going to handle the de-implementation of DBconsole after 11.2.0.4?
Is Oracle's Enterprise Manager Grid the only solution? They seem very vague on what they are going to replace it with.
View 6 Replies
View Related
Nov 23, 2010
I have Oracle 11g downloaded on my laptop for personal use. Here are my specs-
Gateway T-6815
Processor: Intel® Core™2 Duo CPU T5250 @1.5GHz 1.50 GHz
RAM: 1.00 G
32-bit Operating System
Windows Vista -Home Premium
Disk Space Available : 16.8 GB free of 138 GB
Every time I start DBConsole it takes almost 30 minutes to start, slows down the computer to the point where its not usable and/or crashes it.
View 1 Replies
View Related
Jun 27, 2013
I have download and installed the trial version of oracle 11g enterprise on windows 2008 r2 in vmware workstation. I couldn't see the database control in start up as my destination path c:oracleyourdatabaselocationdboc4jj2eeoc4j_DBConsole though I tried to open manually https://<localhost, ipaddress, domainname>:1158/em but its failed to open. I also tried to recreate the db using below commandemca -deconfig dbcontrol db -repos dropemca –config dbcontrol –repos createGot some info from below details:[URL]
NOTE: Moreover dbcontrol services missing in services.msc
View 4 Replies
View Related
Apr 26, 2007
When i am trying to start dbconsole, it throughs error:
oracle@aaa:aaa:>emctl status dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.1.0.4
Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
http://aaa:5500/em/console/aboutApplication
[Code].....
View 9 Replies
View Related
Jan 20, 2010
I have two database in my system but when i open
[URL].....it always defaults for one database..in the service name also there is dbconsoledba1 written....my other database is dba2...do i need to create another service for dbconsole
View 1 Replies
View Related
Mar 11, 2010
When I try to access the database control, I am un able to.The page cannot be found
I am using this URL in firefox [URL] But it is coming blank. with message as HTTP 404 not found
I have already did this
$ emca -repos create
$ emca -config dbcontrol db
View 9 Replies
View Related
Nov 13, 2012
OS Windows Server2008 R2 64 bit (virtual machine), DB Oracle 11.2.0.1,
emctl:
C: Oracle product 11.2.0 dbhome_2BIN>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
[code]...
I can access database with sql plus.When I try to access dbconsole with IE I get a certificate error (see uploaded picture),clicking "Laden dieser Webseite fortsetzen" has no effect. Disable Windows firewall does not change anything.
There are 2 further databases of same oracle version on this machine. They show the same problem with dbconsole.
I tried to add content of C: Oracleproduct11.2.0dbhome_2200864ORADB.it.ixsystems_CHAMPsysmanlog (for which i stopped service OracleDBConsoleCHAMP). But I can upload only one file, no ZIP.
-- after creation of this topic failed with "You cannot use links until you have posted more than 5 messages" I try to send it without attachment --
View 2 Replies
View Related
Jan 8, 2010
Tried restarting OracaleDBConsole service after a Windows security patch was installed and now I'm getting error 1053:The service did not respond to the start or control request in a timely fashion" error message when you stop or pause a managed Windows service.
Apparently it was a MS known issue and it has been fixed in .NET v1.1 which is what was installed(& I didn't have any problems) before server team installed the latest security update which was .NET v2.0
View 2 Replies
View Related
Mar 4, 2008
I have a new install of 10g running on xp. All seems to be working fine except for the Db Console. This command...C:>emctl status dbconsole throws...OC4J Configuration issue. C:oracleproduct10.2.0db_1/oc4j/j2ee/OC4J_DBConsole_xxx.xxx.xxx.xxx_LOCAL10G not found.where xxx... is my ip address???
The directory name is actually OC4J_DBConsole_MY-LT_LOCAL10G. My tnsnames shows my host as MY-LT, so I'm not sure why it's looking for an ip address.
I did a search off my oracle home in all .ora and .xml files, but did not see this address listed. I figured there may be a var assigned this ip instead of the hostname but found none.
To note, I do not have a ORACLE_HOME setup. I do have an ORACLE_SID setup (local10g). This is the only Db running on this host.
View 5 Replies
View Related
Oct 13, 2011
I am getting problem while starting the CRS. Below is the necessary details:
1) I am using oracle 11g R2 RAC, with 2 node named RAC1 and RAC2
2) I have 3 diskgroup named DATA, DATA1, DATA2
3) OCR and voting disks are stored on ASM diskgroup
On node RAC1, CRS is started and /etc/oracle/ocr.loc is having the below entry:
ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA1
On node RAC2, CRS is stopped and /etc/oracle/ocr.loc is having the below entry:
ocrconfig_loc=+DATA
ocrmirrorconfig_loc=+DATA2
note the difference in "ocrmirrorconfig_loc". The difference was occured because I updated the OCR location on RAC1 when RAC2 was down.
Now I am trying to repair the RAC2 using below command. This command must be run as root user when HA service is started but CRS must be stopped.
ocrconfig -repair -replace +DAT2 -replacement +DATA1
but this showing error "PROT-21: Invalid parameter", because to run this command diskgroup must be mounted. But diskgroup cannot be mounted until the CRS start. SO this is a conflicting situation.
View 4 Replies
View Related
Apr 25, 2011
I am unable to start the listener.When I start it I get this error
LISTENER2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.20.221)(PORT = 1522))
)
[Code]....
When I try to start it is showing
LSNRCTL for 32-bit Windows: Version 10.2.0.3.0 - Production on 25-APR-2011 10:55
:31
Copyright (c) 1991, 2006, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start listener1
Starting tnslsnr: please wait...
Failed to start service, error 0.
View 4 Replies
View Related
Jun 30, 2011
We have Data Migration for our application coded in PL/SQL. The DB server has 64 Cores available (Solaris 10 OS) however running the migration code written as a function, utilizes very little CPU and CPU utilization is to max 2%. To utilize CPU power available to increase the speed of migration, we are using DBMS_JOB to schedule this function multiple times.
However scheduling the function 10 times, we are seeing that at any moment only 4/5 oracle processes are active and utilizing the CPU and CPU utilization has gone up to 5-6%. The speed of migration is increased but not to a great extend which I feel would work if we could utilize more CPU.
I see a parameter job_queue_processes is set to 10 currently in the database and am planning to increase this (currently to 25 as I don't have exact count of how many other jobs may be running in the database).
View 1 Replies
View Related
Jul 30, 2010
how to select the name that starts with first letter caps.
Eg:
Emp_Name Emp_id
Raga 101
Purnima 102
Vicky 103
ragu 104
raman 105
Santhosh 106
output should like as following:
Emp_Name
Raga
Purnima
Vicky
Santhosh
4 row(s) affected.
View 39 Replies
View Related
Jan 25, 2010
I have forms developer installed on a HP-UX machine. I do the following
1. connect to server (telnet)
2. export DISPLAY=my_ip:0.0
3. run f90desm
The 'ps' shows f90desm as running
now this does not show the window for forms developer in short time it takes a large amount of time Hrs before the window shows up.
View 1 Replies
View Related
Nov 9, 2012
I want to get the week of the year.
Conditions are:
1. Year's first week starts with first Sunday of the year. (6th Jan 2013 will be the starting week (week 1) in Year 2013)
2. 2nd Jan 2013 will be the last week of the previous year i.e. 2012 (either 52th or 53rd week)
At many place I found the below solution:
select to_char(to_date('01-JAN-2008','DD-MON-YYYY')+1,'IW') week_number from dual;
But its not working for the given dates (2nd Jan 2013, which should fall in the last week of 2012, and 6th Jan 2013, which should be the starting week of 2013).
View 6 Replies
View Related
Mar 20, 2013
in my application I'm starting jobs via dbms_scheduler for background activity on user action.
I know from my logs that the procedure executed in the job finishes within 2 seconds.
But in the AWR I find execution time for the job of 360 seconds (single execution because of unique job id).
How do I find out why the job takes so long?
And more important: how do I speed up the job?
(details will follow...)
View 0 Replies
View Related
Oct 3, 2010
Trying to configure oracle golden gate between oracle 10g and 9i golden gate Manager is not starting
Error in MGR.rpt
Source Context :
SourceModule : [mgr.main]
SourceID : [/home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34085]/perforce/src/app/mgr/mgr.c]
SourceFunction : [param_file_args]
SourceLine : [2854]
2010-10-03 09:27:48 ERROR OGG-00303 Unrecognized parameter (<CODE>PORT).
2010-10-03 09:27:48 ERROR OGG-01668 PROCESS ABENDING.
View 1 Replies
View Related
Aug 23, 2010
I have created and formatted a mini test scenario. Execute the scripts I have below?
From the column adj_second_line, I am trying to clip everything from the characters '201' all the way to the end...or the NUMERIC start value after the word 'TYPE'. Whichever way is easier for you...
create table test_split
(adj_second_line varchar2(80))
insert into test_split
values ('ADJ#1-2G3AYL TYPE 20100501 20100524 0MO/23DY')
insert into test_split
values ('ADJ#2-656GYP TYPE AR 20100522 20100524 0MO/15DY')
insert into test_split
values ('ADJ# 265HKK TYPE X 20100428 20100524 0MO/30HT')
insert into test_split
values ('ADJ#13 43327DR TYPE AJ 20100413 20100524 0MO/30HT')
-- Need to have another column called split_second_half
SELECT adj_second_line,
substr(adj_second_line, 1, instr(adj_second_line, '201')-1) split_first_half,
instr(adj_second_line, '201') clip_from_position
FROM test_split
--Desired output for the split_second_half column
20100501 20100524 0MO/23DY
20100522 20100524 0MO/15DY
20100428 20100524 0MO/30HT
View 11 Replies
View Related
Sep 16, 2008
SP file was removed during the testing and I started the database after making some changes in the pfile, and it works fine.
But when I try to start the database using the SPFILE, it gives an error.
SQL> STARTUP PFILE='D:oracleproduct10.2.0adminorclpfileINITORCL.ORA'
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1248576 bytes
Variable Size 109052608 bytes
Database Buffers 171966464 bytes
Redo Buffers 7139328 bytes
Database mounted.
Database opened.
SQL> create spfile from pfile;
File created.
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL> startup
ORA-01565: error in identifying file 'D:oracleproduct10.2.0db_7/dbs/SPFILEORCL.ORA'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 1541)
The contents of the spfile in $ORACLE_HOMEdatabase are
*.SPFILE='D:oracleproduct10.2.0db_7/dbs/SPFILEORCL.ORA'
View 12 Replies
View Related
Jul 28, 2012
I installed Oracle database 11g enterprise edition. I can connect it through sql plus but Database control is not starting. I have checked dbconsole service which is running.
the address is [URL]...
but mozilla and chrome both are unable to start the application. after installation it started only once. but it is not starting now.
second thing is how can i confirm what is the port of my listener is it 1158 or something else.
View 2 Replies
View Related
Sep 30, 2011
I have made one LOV for vendor_names. On form level i want that when the user will enter a particular alphabet in a textbox assigned with LOV, the list should popup with only those elements starting with that particular alphabet. I have written the following code in the query of LOV wizard
query:
select distinct(bpt_ven_nm),bpt_ven_cd from bill_hdr1_tab
where bpt_ven_nm like ('enter.vendr_nm'||'%')
order by bpt_ven_nm
Wherin 'Enter' is the name of block and 'vendr_nm' is field name.
But its getting unsuccesfull. Any alternate way to get this result.
View 2 Replies
View Related
