Home » RDBMS Server » Enterprise Manager » Connection refused when trying to start Database Instance (oracle 11g, windows 7, enterprise manager 11.2.0.1.0)
Connection refused when trying to start Database Instance [message #612468] |
Sat, 19 April 2014 02:13 |
|
SeniorInvissible
Messages: 34 Registered: July 2013
|
Member |
|
|
I'm running the oracle server on a virtual machine. This should be a simple task but for some reason I'm getting an error.
I entered the correct username and password for the OS account as well as the sys username and password for the Database but still getting a connection refused error.
Could anyone help? I'm positive the credentials are correct. The account used for the OS is that of the virtual machine, I don't know what else to do
[Updated on: Sat, 19 April 2014 02:15] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: Connection refused when trying to start Database Instance [message #612769 is a reply to message #612526] |
Thu, 24 April 2014 12:12 |
|
SeniorInvissible
Messages: 34 Registered: July 2013
|
Member |
|
|
Yes the environment variables are set: ORACLE_HOSTNAME and ORACLE_UNQNAME as per directed when I installed oracle.
I tried using the username of: ADMIN-E26A6FE11\Admin but getting the same message as below:
Yes, it's working perfectly from SQL Plus but I have to get it working from the enterprise manager.
From my understanding, a single oracle Database could have many instances
SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 24 13:16:45 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: sys as sysdba
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 535662592 bytes
Fixed Size 1375792 bytes
Variable Size 427819472 bytes
Database Buffers 100663296 bytes
Redo Buffers 5804032 bytes
Database mounted.
Database opened.
SQL>
[Updated on: Thu, 24 April 2014 12:21] Report message to a moderator
|
|
|
|
Re: Connection refused when trying to start Database Instance [message #612772 is a reply to message #612771] |
Thu, 24 April 2014 12:31 |
|
SeniorInvissible
Messages: 34 Registered: July 2013
|
Member |
|
|
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Admin>lsnrctl status
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 24-APR-2014 13:36
:53
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 24-APR-2014 13:31:30
Uptime 0 days 0 hr. 5 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Log File c:\app\admin\diag\tnslsnr\admin-e26a6fe11\listener\ale
rt\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=admin-e26a6fe11)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=admin-e26a6fe11)(PORT=8085))(Present
ation=HTTP)(Session=RAW))
Services Summary...
Service "oracle11g" has 1 instance(s).
Instance "oracle11g", status READY, has 1 handler(s) for this service...
Service "oracle11gXDB" has 1 instance(s).
Instance "oracle11g", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Documents and Settings\Admin>lsnrctl service
LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 24-APR-2014 13:37
:01
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "oracle11g" has 1 instance(s).
Instance "oracle11g", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:9 refused:0 state:ready
LOCAL SERVER
Service "oracle11gXDB" has 1 instance(s).
Instance "oracle11g", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: ADMIN-E26A6FE11, pid: 556>
(ADDRESS=(PROTOCOL=tcp)(HOST=admin-e26a6fe11)(PORT=1031))
The command completed successfully
C:\Documents and Settings\Admin>
|
|
|
|
|
|
Re: Connection refused when trying to start Database Instance [message #612780 is a reply to message #612778] |
Thu, 24 April 2014 13:46 |
|
SeniorInvissible
Messages: 34 Registered: July 2013
|
Member |
|
|
C:\Documents and Settings\Admin>emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
http://ADMIN-E26A6FE11:5500/em/console/aboutApplication
EM Daemon is not running.
------------------------------------------------------------------
Logs are generated in directory C:\Oracle11g\product\11.2.0\dbhome_1/ADMIN-E26A6
FE11_oracle11g/sysman/log
C:\Documents and Settings\Admin>
I'm seeing lots of files in this directory, which one should I open?
I'm pasting the contents of emdctl.trc:
2014-04-18 19:49:48,577 Thread-3716 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 19:55:19,683 Thread-2492 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 20:00:30,971 Thread-3100 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 20:04:24,246 Thread-2968 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 20:04:52,306 Thread-1560 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 20:04:54,710 Thread-3004 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 20:05:42,979 Thread-1236 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 20:07:19,768 Thread-2728 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 20:07:20,790 Thread-2428 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 20:07:30,023 Thread-3516 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 20:08:19,625 Thread-3080 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 20:08:32,703 Thread-1988 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 20:09:07,363 Thread-2380 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 20:19:36,605 Thread-1780 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 20:53:25,482 Thread-1172 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-18 22:46:48,333 Thread-1248 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-19 02:29:37,456 Thread-2000 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-19 02:52:37,105 Thread-1988 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-19 03:29:57,840 Thread-408 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-19 04:32:20,686 Thread-528 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-19 04:38:55,714 Thread-2256 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-19 04:40:04,423 Thread-3096 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-19 04:40:17,832 Thread-3548 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-19 04:55:02,675 Thread-3516 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-19 04:55:16,795 Thread-3052 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-19 04:55:52,086 Thread-1272 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-19 04:56:08,670 Thread-3048 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 08:23:02,535 Thread-1720 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 10:48:26,441 Thread-1676 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 11:47:58,611 Thread-1836 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 12:13:20,749 Thread-1640 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 12:16:51,773 Thread-4008 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 12:17:09,218 Thread-2652 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 12:17:19,012 Thread-3468 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 12:18:02,805 Thread-1260 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 12:18:23,835 Thread-2896 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 12:24:42,480 Thread-2744 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 12:25:09,118 Thread-3920 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 12:47:50,355 Thread-2108 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 12:48:16,793 Thread-2108 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 12:51:34,762 Thread-332 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 13:47:18,526 Thread-756 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 17:28:56,253 Thread-1824 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-300,and testTZoffset for -08:00:-480 do not match
2014-04-20 17:28:57,675 Thread-1824 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-300,and testTZoffset for -08:00:-480 do not match
2014-04-20 18:21:07,876 Thread-2820 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-300,and testTZoffset for -08:00:-480 do not match
2014-04-20 18:21:09,158 Thread-2820 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-300,and testTZoffset for -08:00:-480 do not match
2014-04-20 18:21:43,868 Thread-2924 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 18:27:32,319 Thread-4080 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-300,and testTZoffset for -08:00:-480 do not match
2014-04-20 18:27:33,501 Thread-4080 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-300,and testTZoffset for -08:00:-480 do not match
2014-04-20 18:28:03,724 Thread-3600 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-20 18:51:14,314 Thread-3644 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-300,and testTZoffset for -08:00:-480 do not match
2014-04-20 18:51:15,446 Thread-3644 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-300,and testTZoffset for -08:00:-480 do not match
2014-04-20 18:51:46,000 Thread-3132 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
2014-04-21 21:31:03,646 Thread-204 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-300,and testTZoffset for -08:00:-480 do not match
2014-04-21 21:31:04,808 Thread-204 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-300,and testTZoffset for -08:00:-480 do not match
2014-04-24 09:50:20,034 Thread-1588 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-300,and testTZoffset for -08:00:-480 do not match
2014-04-24 09:50:21,145 Thread-1588 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-300,and testTZoffset for -08:00:-480 do not match
2014-04-24 11:26:13,686 Thread-436 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-240,and testTZoffset for -08:00:-480 do not match
2014-04-24 11:26:14,917 Thread-436 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-240,and testTZoffset for -08:00:-480 do not match
2014-04-24 13:13:55,418 Thread-496 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-240,and testTZoffset for -08:00:-480 do not match
2014-04-24 13:13:56,660 Thread-496 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-240,and testTZoffset for -08:00:-480 do not match
2014-04-24 13:31:44,024 Thread-748 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-240,and testTZoffset for -08:00:-480 do not match
2014-04-24 13:31:45,126 Thread-748 ERROR main: nmectl.c: nmectl_validateTZRegion, agentTZoffset =-240,and testTZoffset for -08:00:-480 do not match
2014-04-24 14:47:15,040 Thread-3376 ERROR main: nmectla_agentctl: Error connecting to http://ADMIN-E26A6FE11:3938/emd/main. Returning status code 1
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri Nov 22 12:21:05 CST 2024
|