Oracle database throwing error - orapw[SID] is missing
I have downloaded and installed Oracle Database Express edition. In SQL Developer, I am trying to create a new database connection that connects to SYS, however I am being rejected with the error:
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
I found out that during installation I should have been prompted to create a password for sys, but no such thing happened.
I then tried to find the orapw[SID] file in /database. It was not there.
Any idea what I'm doing wrong?
oracle passwords
edited Jan 19 at 0:22
Praveen Govind
8181032
asked Jan 18 at 17:33
ze borisze boris
1
New contributor
ze boris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have downloaded and installed Oracle Database Express edition. In SQL Developer, I am trying to create a new database connection that connects to SYS, however I am being rejected with the error:
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
I found out that during installation I should have been prompted to create a password for sys, but no such thing happened.
I then tried to find the orapw[SID] file in /database. It was not there.
Any idea what I'm doing wrong?
oracle passwords
edited Jan 19 at 0:22
Praveen Govind
8181032
asked Jan 18 at 17:33
ze borisze boris
1
New contributor
ze boris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
What happens if you open a command prompt window and executesqlplus / as sysdba? If you manage to connect to the database, modify SYS password usingalter user sys identified by its_new_password;
– Littlefoot
Jan 18 at 19:19
The error message is saying the TNS listener doesn't recognise the specified SID. It doesn't seem to be related to any password issue. What did you specify in the connection, how is that defined in tnsnames.ora, and what services are known to the listener?tnsping yoursidmay give you some clues.
– William Robertson
Jan 19 at 10:07
add a comment |
I have downloaded and installed Oracle Database Express edition. In SQL Developer, I am trying to create a new database connection that connects to SYS, however I am being rejected with the error:
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
I found out that during installation I should have been prompted to create a password for sys, but no such thing happened.
I then tried to find the orapw[SID] file in /database. It was not there.
Any idea what I'm doing wrong?
oracle passwords
edited Jan 19 at 0:22
Praveen Govind
8181032
asked Jan 18 at 17:33
ze borisze boris
1
New contributor
ze boris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have downloaded and installed Oracle Database Express edition. In SQL Developer, I am trying to create a new database connection that connects to SYS, however I am being rejected with the error:
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
I found out that during installation I should have been prompted to create a password for sys, but no such thing happened.
I then tried to find the orapw[SID] file in /database. It was not there.
Any idea what I'm doing wrong?
oracle passwords
oracle passwords
edited Jan 19 at 0:22
Praveen Govind
8181032
asked Jan 18 at 17:33
ze borisze boris
1
New contributor
ze boris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Jan 19 at 0:22
Praveen Govind
8181032
asked Jan 18 at 17:33
ze borisze boris
1
New contributor
ze boris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Jan 19 at 0:22
Praveen Govind
8181032
edited Jan 19 at 0:22
Praveen Govind
8181032
edited Jan 19 at 0:22
Praveen Govind
8181032
8181032
asked Jan 18 at 17:33
ze borisze boris
1
New contributor
ze boris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Jan 18 at 17:33
ze borisze boris
1
asked Jan 18 at 17:33
ze borisze boris
1
1
New contributor
ze boris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
ze boris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
ze boris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
What happens if you open a command prompt window and executesqlplus / as sysdba? If you manage to connect to the database, modify SYS password usingalter user sys identified by its_new_password;
– Littlefoot
Jan 18 at 19:19
The error message is saying the TNS listener doesn't recognise the specified SID. It doesn't seem to be related to any password issue. What did you specify in the connection, how is that defined in tnsnames.ora, and what services are known to the listener?tnsping yoursidmay give you some clues.
– William Robertson
Jan 19 at 10:07
add a comment |
What happens if you open a command prompt window and executesqlplus / as sysdba? If you manage to connect to the database, modify SYS password usingalter user sys identified by its_new_password;
– Littlefoot
Jan 18 at 19:19
The error message is saying the TNS listener doesn't recognise the specified SID. It doesn't seem to be related to any password issue. What did you specify in the connection, how is that defined in tnsnames.ora, and what services are known to the listener?tnsping yoursidmay give you some clues.
– William Robertson
Jan 19 at 10:07
What happens if you open a command prompt window and execute
sqlplus / as sysdba? If you manage to connect to the database, modify SYS password using alter user sys identified by its_new_password;– Littlefoot
Jan 18 at 19:19
What happens if you open a command prompt window and execute
sqlplus / as sysdba? If you manage to connect to the database, modify SYS password using alter user sys identified by its_new_password;– Littlefoot
Jan 18 at 19:19
The error message is saying the TNS listener doesn't recognise the specified SID. It doesn't seem to be related to any password issue. What did you specify in the connection, how is that defined in tnsnames.ora, and what services are known to the listener?
tnsping yoursid may give you some clues.– William Robertson
Jan 19 at 10:07
The error message is saying the TNS listener doesn't recognise the specified SID. It doesn't seem to be related to any password issue. What did you specify in the connection, how is that defined in tnsnames.ora, and what services are known to the listener?
tnsping yoursid may give you some clues.– William Robertson
Jan 19 at 10:07
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
});
}
});
ze boris is a new contributor. Be nice, and check out our Code of Conduct.
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%2fstackoverflow.com%2fquestions%2f54258880%2foracle-database-throwing-error-orapwsid-is-missing%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
ze boris is a new contributor. Be nice, and check out our Code of Conduct.
ze boris is a new contributor. Be nice, and check out our Code of Conduct.
ze boris is a new contributor. Be nice, and check out our Code of Conduct.
ze boris is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f54258880%2foracle-database-throwing-error-orapwsid-is-missing%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
What happens if you open a command prompt window and execute
sqlplus / as sysdba? If you manage to connect to the database, modify SYS password usingalter user sys identified by its_new_password;– Littlefoot
Jan 18 at 19:19
The error message is saying the TNS listener doesn't recognise the specified SID. It doesn't seem to be related to any password issue. What did you specify in the connection, how is that defined in tnsnames.ora, and what services are known to the listener?
tnsping yoursidmay give you some clues.– William Robertson
Jan 19 at 10:07