EMCA insists that it cannot connect to the service The 2019 Stack Overflow Developer Survey...
What force causes entropy to increase?
How did the audience guess the pentatonic scale in Bobby McFerrin's presentation?
1960s short story making fun of James Bond-style spy fiction
Why did Peik Lin say, "I'm not an animal"?
Can the Right Ascension and Argument of Perigee of a spacecraft's orbit keep varying by themselves with time?
University's motivation for having tenure-track positions
Do I have Disadvantage attacking with an off-hand weapon?
How do I design a circuit to convert a 100 mV and 50 Hz sine wave to a square wave?
ELI5: Why do they say that Israel would have been the fourth country to land a spacecraft on the Moon and why do they call it low cost?
Are spiders unable to hurt humans, especially very small spiders?
Can each chord in a progression create its own key?
Why don't hard Brexiteers insist on a hard border to prevent illegal immigration after Brexit?
Does Parliament need to approve the new Brexit delay to 31 October 2019?
For what reasons would an animal species NOT cross a *horizontal* land bridge?
What do I do when my TA workload is more than expected?
Is an up-to-date browser secure on an out-of-date OS?
How to type a long/em dash `—`
Are there continuous functions who are the same in an interval but differ in at least one other point?
How to politely respond to generic emails requesting a PhD/job in my lab? Without wasting too much time
Identify 80s or 90s comics with ripped creatures (not dwarves)
how can a perfect fourth interval be considered either consonant or dissonant?
Can the DM override racial traits?
Is it ok to offer lower paid work as a trial period before negotiating for a full-time job?
If I score a critical hit on an 18 or higher, what are my chances of getting a critical hit if I roll 3d20?
EMCA insists that it cannot connect to the service
The 2019 Stack Overflow Developer Survey Results Are In
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)check listener status other than 1521How can I change the connection descriptor used by Oracle Enterprise Manager?Difference between oracle database desktop and server classOracle XE 11g (ORA-12514: TNS:listener does not currently know of service requested in connect descriptor )Oracle connection suddenly refused on windows 8Oracle 11.2.0.3 Service Name Mismatch issueListener listening without listener.oraOracle Developers guide 10g is not connecting to serverConnect Oracle Database 12c via SQL Developer when it is in restricted modeTNS-12560: TNS:protocol adapter error
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}
Really new to Oracle and being a DBA in general. I am trying to set up a development environment so that I can play an learn oracle better. Enterprise Mananger failed to configure itself when I first created the database using the Database Configuration Assistant. No biggie. Just need to user emca.exe
I had some issues with the Listener but those might have just been me being impatient in waiting for the service to register or the service not running. Right now my issue is this from the emca log:
CONFIG: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
According to post here and on SO it should just be an issue with the service name. Problem is it looks right to me.
Listener.ora
ADR_BASE_VLISTENER = D:appAdministrator
VLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dvp-oracle)(PORT = 1521))
)
)
lsnrctl status
.... truncated ....
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dvp-oracle)(PORT=1521)))
Services Summary...
Service "prodbkp" has 1 instance(s).
Instance "prodbkp", status READY, has 1 handler(s) for this service...
Service "prodbkpXDB" has 1 instance(s).
Instance "prodbkp", status READY, has 1 handler(s) for this service...
The command completed successfully
That tells me that the database registered itself dynamically correctly. prodbkp is my SID. This might be a case issue since I named the DB "PRODbkp" but everything else seems to be fine since I can connect with sqlplus sys@prodbkp as sysdba just fine. Case should not be an issue with service names as per docs.oracle.com
tsnnames.ora
PRODBKP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dvp-oracle)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prodbkp)
)
)
Which also looks OK. Most of the solutions point to SERVICE_NAME mismatches. However I don't appear to have one.
v$parameter output
SQL> select value from v$parameter where name='service_names';
VALUE
--------------------------------------------------------------------------------
prodbkp
That gap you see above prodkbp is in the output as well. Not sure if that matters either. My production server has that anomaly as well so I can't imagine that has anything to do with it.
Basically everything looks right but something is still wrong. I cannot install Enterprise Manager
Environment
- Windows Server 2008R2
- Oracle 11g
oracle oracle-11g windows-server-2008-r2 oracle-enterprise-manager
asked Aug 28 '17 at 13:58
MattMatt
218116
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
Really new to Oracle and being a DBA in general. I am trying to set up a development environment so that I can play an learn oracle better. Enterprise Mananger failed to configure itself when I first created the database using the Database Configuration Assistant. No biggie. Just need to user emca.exe
I had some issues with the Listener but those might have just been me being impatient in waiting for the service to register or the service not running. Right now my issue is this from the emca log:
CONFIG: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
According to post here and on SO it should just be an issue with the service name. Problem is it looks right to me.
Listener.ora
ADR_BASE_VLISTENER = D:appAdministrator
VLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dvp-oracle)(PORT = 1521))
)
)
lsnrctl status
.... truncated ....
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dvp-oracle)(PORT=1521)))
Services Summary...
Service "prodbkp" has 1 instance(s).
Instance "prodbkp", status READY, has 1 handler(s) for this service...
Service "prodbkpXDB" has 1 instance(s).
Instance "prodbkp", status READY, has 1 handler(s) for this service...
The command completed successfully
That tells me that the database registered itself dynamically correctly. prodbkp is my SID. This might be a case issue since I named the DB "PRODbkp" but everything else seems to be fine since I can connect with sqlplus sys@prodbkp as sysdba just fine. Case should not be an issue with service names as per docs.oracle.com
tsnnames.ora
PRODBKP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dvp-oracle)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prodbkp)
)
)
Which also looks OK. Most of the solutions point to SERVICE_NAME mismatches. However I don't appear to have one.
v$parameter output
SQL> select value from v$parameter where name='service_names';
VALUE
--------------------------------------------------------------------------------
prodbkp
That gap you see above prodkbp is in the output as well. Not sure if that matters either. My production server has that anomaly as well so I can't imagine that has anything to do with it.
Basically everything looks right but something is still wrong. I cannot install Enterprise Manager
Environment
- Windows Server 2008R2
- Oracle 11g
oracle oracle-11g windows-server-2008-r2 oracle-enterprise-manager
asked Aug 28 '17 at 13:58
MattMatt
218116
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
This should be really easy to find in the logD:appAdministratordiagtnslsnrvlistenertracevlistener.log. Check that file and you will find what service name or SID emca uses to connect.
– Balazs Papp
Aug 28 '17 at 15:20
@BalazsPapp I see repetition of lines like this(CONNECT_DATA=(SERVICE_NAME=prodbkp)(CID=(PROGRAM=D:appAdministratorproduct11.2.0dbhome_1binsqlplus.exe)(HOST=DVP-ORACLE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.13.134)(PORT=49269))which looks correct. I think I found the actual problem in listener.log. It looks like it was trying to connect to the host via the ipv6 address. I need to break it and test again to be sure I understood the issue first.
– Matt
Aug 28 '17 at 15:28
I'd probably need to fix service name to remove that newline or that empty service name, then bounce listener and then log on to db as sysdba and run 'alter system register;' and see if it helps.
– Raj
Aug 28 '17 at 15:51
add a comment |
Really new to Oracle and being a DBA in general. I am trying to set up a development environment so that I can play an learn oracle better. Enterprise Mananger failed to configure itself when I first created the database using the Database Configuration Assistant. No biggie. Just need to user emca.exe
I had some issues with the Listener but those might have just been me being impatient in waiting for the service to register or the service not running. Right now my issue is this from the emca log:
CONFIG: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
According to post here and on SO it should just be an issue with the service name. Problem is it looks right to me.
Listener.ora
ADR_BASE_VLISTENER = D:appAdministrator
VLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dvp-oracle)(PORT = 1521))
)
)
lsnrctl status
.... truncated ....
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dvp-oracle)(PORT=1521)))
Services Summary...
Service "prodbkp" has 1 instance(s).
Instance "prodbkp", status READY, has 1 handler(s) for this service...
Service "prodbkpXDB" has 1 instance(s).
Instance "prodbkp", status READY, has 1 handler(s) for this service...
The command completed successfully
That tells me that the database registered itself dynamically correctly. prodbkp is my SID. This might be a case issue since I named the DB "PRODbkp" but everything else seems to be fine since I can connect with sqlplus sys@prodbkp as sysdba just fine. Case should not be an issue with service names as per docs.oracle.com
tsnnames.ora
PRODBKP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dvp-oracle)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prodbkp)
)
)
Which also looks OK. Most of the solutions point to SERVICE_NAME mismatches. However I don't appear to have one.
v$parameter output
SQL> select value from v$parameter where name='service_names';
VALUE
--------------------------------------------------------------------------------
prodbkp
That gap you see above prodkbp is in the output as well. Not sure if that matters either. My production server has that anomaly as well so I can't imagine that has anything to do with it.
Basically everything looks right but something is still wrong. I cannot install Enterprise Manager
Environment
- Windows Server 2008R2
- Oracle 11g
oracle oracle-11g windows-server-2008-r2 oracle-enterprise-manager
asked Aug 28 '17 at 13:58
MattMatt
218116
Really new to Oracle and being a DBA in general. I am trying to set up a development environment so that I can play an learn oracle better. Enterprise Mananger failed to configure itself when I first created the database using the Database Configuration Assistant. No biggie. Just need to user emca.exe
I had some issues with the Listener but those might have just been me being impatient in waiting for the service to register or the service not running. Right now my issue is this from the emca log:
CONFIG: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
According to post here and on SO it should just be an issue with the service name. Problem is it looks right to me.
Listener.ora
ADR_BASE_VLISTENER = D:appAdministrator
VLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dvp-oracle)(PORT = 1521))
)
)
lsnrctl status
.... truncated ....
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=dvp-oracle)(PORT=1521)))
Services Summary...
Service "prodbkp" has 1 instance(s).
Instance "prodbkp", status READY, has 1 handler(s) for this service...
Service "prodbkpXDB" has 1 instance(s).
Instance "prodbkp", status READY, has 1 handler(s) for this service...
The command completed successfully
That tells me that the database registered itself dynamically correctly. prodbkp is my SID. This might be a case issue since I named the DB "PRODbkp" but everything else seems to be fine since I can connect with sqlplus sys@prodbkp as sysdba just fine. Case should not be an issue with service names as per docs.oracle.com
tsnnames.ora
PRODBKP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dvp-oracle)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prodbkp)
)
)
Which also looks OK. Most of the solutions point to SERVICE_NAME mismatches. However I don't appear to have one.
v$parameter output
SQL> select value from v$parameter where name='service_names';
VALUE
--------------------------------------------------------------------------------
prodbkp
That gap you see above prodkbp is in the output as well. Not sure if that matters either. My production server has that anomaly as well so I can't imagine that has anything to do with it.
Basically everything looks right but something is still wrong. I cannot install Enterprise Manager
Environment
- Windows Server 2008R2
- Oracle 11g
oracle oracle-11g windows-server-2008-r2 oracle-enterprise-manager
oracle oracle-11g windows-server-2008-r2 oracle-enterprise-manager
asked Aug 28 '17 at 13:58
MattMatt
218116
asked Aug 28 '17 at 13:58
MattMatt
218116
edited Aug 28 '17 at 15:07
Matt
asked Aug 28 '17 at 13:58
MattMatt
218116
asked Aug 28 '17 at 13:58
MattMatt
218116
asked Aug 28 '17 at 13:58
MattMatt
218116
218116
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 11 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
This should be really easy to find in the logD:appAdministratordiagtnslsnrvlistenertracevlistener.log. Check that file and you will find what service name or SID emca uses to connect.
– Balazs Papp
Aug 28 '17 at 15:20
@BalazsPapp I see repetition of lines like this(CONNECT_DATA=(SERVICE_NAME=prodbkp)(CID=(PROGRAM=D:appAdministratorproduct11.2.0dbhome_1binsqlplus.exe)(HOST=DVP-ORACLE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.13.134)(PORT=49269))which looks correct. I think I found the actual problem in listener.log. It looks like it was trying to connect to the host via the ipv6 address. I need to break it and test again to be sure I understood the issue first.
– Matt
Aug 28 '17 at 15:28
I'd probably need to fix service name to remove that newline or that empty service name, then bounce listener and then log on to db as sysdba and run 'alter system register;' and see if it helps.
– Raj
Aug 28 '17 at 15:51
add a comment |
This should be really easy to find in the logD:appAdministratordiagtnslsnrvlistenertracevlistener.log. Check that file and you will find what service name or SID emca uses to connect.
– Balazs Papp
Aug 28 '17 at 15:20
@BalazsPapp I see repetition of lines like this(CONNECT_DATA=(SERVICE_NAME=prodbkp)(CID=(PROGRAM=D:appAdministratorproduct11.2.0dbhome_1binsqlplus.exe)(HOST=DVP-ORACLE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.13.134)(PORT=49269))which looks correct. I think I found the actual problem in listener.log. It looks like it was trying to connect to the host via the ipv6 address. I need to break it and test again to be sure I understood the issue first.
– Matt
Aug 28 '17 at 15:28
I'd probably need to fix service name to remove that newline or that empty service name, then bounce listener and then log on to db as sysdba and run 'alter system register;' and see if it helps.
– Raj
Aug 28 '17 at 15:51
This should be really easy to find in the log
D:appAdministratordiagtnslsnrvlistenertracevlistener.log. Check that file and you will find what service name or SID emca uses to connect.– Balazs Papp
Aug 28 '17 at 15:20
This should be really easy to find in the log
D:appAdministratordiagtnslsnrvlistenertracevlistener.log. Check that file and you will find what service name or SID emca uses to connect.– Balazs Papp
Aug 28 '17 at 15:20
@BalazsPapp I see repetition of lines like this
(CONNECT_DATA=(SERVICE_NAME=prodbkp)(CID=(PROGRAM=D:appAdministratorproduct11.2.0dbhome_1binsqlplus.exe)(HOST=DVP-ORACLE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.13.134)(PORT=49269)) which looks correct. I think I found the actual problem in listener.log. It looks like it was trying to connect to the host via the ipv6 address. I need to break it and test again to be sure I understood the issue first.– Matt
Aug 28 '17 at 15:28
@BalazsPapp I see repetition of lines like this
(CONNECT_DATA=(SERVICE_NAME=prodbkp)(CID=(PROGRAM=D:appAdministratorproduct11.2.0dbhome_1binsqlplus.exe)(HOST=DVP-ORACLE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.13.134)(PORT=49269)) which looks correct. I think I found the actual problem in listener.log. It looks like it was trying to connect to the host via the ipv6 address. I need to break it and test again to be sure I understood the issue first.– Matt
Aug 28 '17 at 15:28
I'd probably need to fix service name to remove that newline or that empty service name, then bounce listener and then log on to db as sysdba and run 'alter system register;' and see if it helps.
– Raj
Aug 28 '17 at 15:51
I'd probably need to fix service name to remove that newline or that empty service name, then bounce listener and then log on to db as sysdba and run 'alter system register;' and see if it helps.
– Raj
Aug 28 '17 at 15:51
add a comment |
1 Answer
1
active
oldest
votes
So it would seem the issue was not the service name specifically but that the request was going to the IPv6 address which was not set up in any of the required files. Looking at listener.log ( which for me was located D:appAdministratordiagtnslsnrdvp-oraclelistenertracelistener.log) I found these entries associated to my connnection attempts.
28-AUG-2017 08:41:58 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=prodbkp)(CID=(PROGRAM=D:appAdministratorproduct11.2.0dbhome_1binsqlplus.exe)(HOST=DVP-ORACLE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7197:6503:9e81:5454%11)(PORT=49246)) * establish * prodbkp * 0
The important portion was HOST=fe80::7197:6503:9e81:5454%11. Since I would never need to support IPv6 I removed it from the network adapter and restarted the server to ensure all services were updated accordingly.
While it might not be the ideal solution I was able to recreate the EM dbcontrol successfully after that change.
answered Aug 28 '17 at 16:12
MattMatt
218116
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f184497%2femca-insists-that-it-cannot-connect-to-the-service%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
So it would seem the issue was not the service name specifically but that the request was going to the IPv6 address which was not set up in any of the required files. Looking at listener.log ( which for me was located D:appAdministratordiagtnslsnrdvp-oraclelistenertracelistener.log) I found these entries associated to my connnection attempts.
28-AUG-2017 08:41:58 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=prodbkp)(CID=(PROGRAM=D:appAdministratorproduct11.2.0dbhome_1binsqlplus.exe)(HOST=DVP-ORACLE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7197:6503:9e81:5454%11)(PORT=49246)) * establish * prodbkp * 0
The important portion was HOST=fe80::7197:6503:9e81:5454%11. Since I would never need to support IPv6 I removed it from the network adapter and restarted the server to ensure all services were updated accordingly.
While it might not be the ideal solution I was able to recreate the EM dbcontrol successfully after that change.
answered Aug 28 '17 at 16:12
MattMatt
218116
add a comment |
So it would seem the issue was not the service name specifically but that the request was going to the IPv6 address which was not set up in any of the required files. Looking at listener.log ( which for me was located D:appAdministratordiagtnslsnrdvp-oraclelistenertracelistener.log) I found these entries associated to my connnection attempts.
28-AUG-2017 08:41:58 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=prodbkp)(CID=(PROGRAM=D:appAdministratorproduct11.2.0dbhome_1binsqlplus.exe)(HOST=DVP-ORACLE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7197:6503:9e81:5454%11)(PORT=49246)) * establish * prodbkp * 0
The important portion was HOST=fe80::7197:6503:9e81:5454%11. Since I would never need to support IPv6 I removed it from the network adapter and restarted the server to ensure all services were updated accordingly.
While it might not be the ideal solution I was able to recreate the EM dbcontrol successfully after that change.
answered Aug 28 '17 at 16:12
MattMatt
218116
add a comment |
So it would seem the issue was not the service name specifically but that the request was going to the IPv6 address which was not set up in any of the required files. Looking at listener.log ( which for me was located D:appAdministratordiagtnslsnrdvp-oraclelistenertracelistener.log) I found these entries associated to my connnection attempts.
28-AUG-2017 08:41:58 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=prodbkp)(CID=(PROGRAM=D:appAdministratorproduct11.2.0dbhome_1binsqlplus.exe)(HOST=DVP-ORACLE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7197:6503:9e81:5454%11)(PORT=49246)) * establish * prodbkp * 0
The important portion was HOST=fe80::7197:6503:9e81:5454%11. Since I would never need to support IPv6 I removed it from the network adapter and restarted the server to ensure all services were updated accordingly.
While it might not be the ideal solution I was able to recreate the EM dbcontrol successfully after that change.
answered Aug 28 '17 at 16:12
MattMatt
218116
So it would seem the issue was not the service name specifically but that the request was going to the IPv6 address which was not set up in any of the required files. Looking at listener.log ( which for me was located D:appAdministratordiagtnslsnrdvp-oraclelistenertracelistener.log) I found these entries associated to my connnection attempts.
28-AUG-2017 08:41:58 * (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=prodbkp)(CID=(PROGRAM=D:appAdministratorproduct11.2.0dbhome_1binsqlplus.exe)(HOST=DVP-ORACLE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=fe80::7197:6503:9e81:5454%11)(PORT=49246)) * establish * prodbkp * 0
The important portion was HOST=fe80::7197:6503:9e81:5454%11. Since I would never need to support IPv6 I removed it from the network adapter and restarted the server to ensure all services were updated accordingly.
While it might not be the ideal solution I was able to recreate the EM dbcontrol successfully after that change.
answered Aug 28 '17 at 16:12
MattMatt
218116
answered Aug 28 '17 at 16:12
MattMatt
218116
answered Aug 28 '17 at 16:12
MattMatt
218116
answered Aug 28 '17 at 16:12
MattMatt
218116
218116
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f184497%2femca-insists-that-it-cannot-connect-to-the-service%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
This should be really easy to find in the log
D:appAdministratordiagtnslsnrvlistenertracevlistener.log. Check that file and you will find what service name or SID emca uses to connect.– Balazs Papp
Aug 28 '17 at 15:20
@BalazsPapp I see repetition of lines like this
(CONNECT_DATA=(SERVICE_NAME=prodbkp)(CID=(PROGRAM=D:appAdministratorproduct11.2.0dbhome_1binsqlplus.exe)(HOST=DVP-ORACLE)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.13.134)(PORT=49269))which looks correct. I think I found the actual problem in listener.log. It looks like it was trying to connect to the host via the ipv6 address. I need to break it and test again to be sure I understood the issue first.– Matt
Aug 28 '17 at 15:28
I'd probably need to fix service name to remove that newline or that empty service name, then bounce listener and then log on to db as sysdba and run 'alter system register;' and see if it helps.
– Raj
Aug 28 '17 at 15:51