How can i verify if the installed oracle 11g is licensed or not
I am in the process of moving an old server to AWS and as part of the transition I need to move the oracle 11g db server installed on it.
I am not sure how can I verify if the installed version is licensed or not, and if it is licensed what is the CSI number?
SQL> select * from v$license
SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MA CPU_COUNT_CURRENT CPU_CORE_COUNT_CURRENT CPU_SOCKET_COUNT_CURRENT CPU_COUNT_HIGHWATER CPU_CORE_COUNT_HIGHWATER CPU_SOCKET_COUNT_HIGHWATER
------------ ---------------- ---------------- ------------------ --------- ----------------- ---------------------- ------------------------ ------------------- ------------------------ --------------------------
0 0 24 25 0 8 8 1 8 8 1
oracle oracle11g
add a comment |
I am in the process of moving an old server to AWS and as part of the transition I need to move the oracle 11g db server installed on it.
I am not sure how can I verify if the installed version is licensed or not, and if it is licensed what is the CSI number?
SQL> select * from v$license
SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MA CPU_COUNT_CURRENT CPU_CORE_COUNT_CURRENT CPU_SOCKET_COUNT_CURRENT CPU_COUNT_HIGHWATER CPU_CORE_COUNT_HIGHWATER CPU_SOCKET_COUNT_HIGHWATER
------------ ---------------- ---------------- ------------------ --------- ----------------- ---------------------- ------------------------ ------------------- ------------------------ --------------------------
0 0 24 25 0 8 8 1 8 8 1
oracle oracle11g
1
You can have an answer for your question here: [dba.stackexchange.com/questions/60054/…
– Abhinav
Nov 12 '18 at 7:12
There isn't anything in the actual database which can give you this information. Somebody in your organisation should be tracking the paperwork. If they haven't been then you will probably need to approach Oracle Licensing Management Services. I say "you" but this is a management task. It would be worth verifying which options you've been using. Find out more
– APC
Nov 12 '18 at 7:28
@Abhinav I tried it but then I have to call Oracle and I am not sure what will happen if the DB we are using comes out to be unlicensed!!
– Jay
Nov 12 '18 at 23:12
@Chunky Don’t worry. Just make a call & get the details.
– Abhinav
Nov 13 '18 at 2:45
add a comment |
I am in the process of moving an old server to AWS and as part of the transition I need to move the oracle 11g db server installed on it.
I am not sure how can I verify if the installed version is licensed or not, and if it is licensed what is the CSI number?
SQL> select * from v$license
SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MA CPU_COUNT_CURRENT CPU_CORE_COUNT_CURRENT CPU_SOCKET_COUNT_CURRENT CPU_COUNT_HIGHWATER CPU_CORE_COUNT_HIGHWATER CPU_SOCKET_COUNT_HIGHWATER
------------ ---------------- ---------------- ------------------ --------- ----------------- ---------------------- ------------------------ ------------------- ------------------------ --------------------------
0 0 24 25 0 8 8 1 8 8 1
oracle oracle11g
I am in the process of moving an old server to AWS and as part of the transition I need to move the oracle 11g db server installed on it.
I am not sure how can I verify if the installed version is licensed or not, and if it is licensed what is the CSI number?
SQL> select * from v$license
SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MA CPU_COUNT_CURRENT CPU_CORE_COUNT_CURRENT CPU_SOCKET_COUNT_CURRENT CPU_COUNT_HIGHWATER CPU_CORE_COUNT_HIGHWATER CPU_SOCKET_COUNT_HIGHWATER
------------ ---------------- ---------------- ------------------ --------- ----------------- ---------------------- ------------------------ ------------------- ------------------------ --------------------------
0 0 24 25 0 8 8 1 8 8 1
oracle oracle11g
oracle oracle11g
edited Nov 12 '18 at 7:08
APC
118k15116229
118k15116229
asked Nov 12 '18 at 5:03
Jay
388
388
1
You can have an answer for your question here: [dba.stackexchange.com/questions/60054/…
– Abhinav
Nov 12 '18 at 7:12
There isn't anything in the actual database which can give you this information. Somebody in your organisation should be tracking the paperwork. If they haven't been then you will probably need to approach Oracle Licensing Management Services. I say "you" but this is a management task. It would be worth verifying which options you've been using. Find out more
– APC
Nov 12 '18 at 7:28
@Abhinav I tried it but then I have to call Oracle and I am not sure what will happen if the DB we are using comes out to be unlicensed!!
– Jay
Nov 12 '18 at 23:12
@Chunky Don’t worry. Just make a call & get the details.
– Abhinav
Nov 13 '18 at 2:45
add a comment |
1
You can have an answer for your question here: [dba.stackexchange.com/questions/60054/…
– Abhinav
Nov 12 '18 at 7:12
There isn't anything in the actual database which can give you this information. Somebody in your organisation should be tracking the paperwork. If they haven't been then you will probably need to approach Oracle Licensing Management Services. I say "you" but this is a management task. It would be worth verifying which options you've been using. Find out more
– APC
Nov 12 '18 at 7:28
@Abhinav I tried it but then I have to call Oracle and I am not sure what will happen if the DB we are using comes out to be unlicensed!!
– Jay
Nov 12 '18 at 23:12
@Chunky Don’t worry. Just make a call & get the details.
– Abhinav
Nov 13 '18 at 2:45
1
1
You can have an answer for your question here: [dba.stackexchange.com/questions/60054/…
– Abhinav
Nov 12 '18 at 7:12
You can have an answer for your question here: [dba.stackexchange.com/questions/60054/…
– Abhinav
Nov 12 '18 at 7:12
There isn't anything in the actual database which can give you this information. Somebody in your organisation should be tracking the paperwork. If they haven't been then you will probably need to approach Oracle Licensing Management Services. I say "you" but this is a management task. It would be worth verifying which options you've been using. Find out more
– APC
Nov 12 '18 at 7:28
There isn't anything in the actual database which can give you this information. Somebody in your organisation should be tracking the paperwork. If they haven't been then you will probably need to approach Oracle Licensing Management Services. I say "you" but this is a management task. It would be worth verifying which options you've been using. Find out more
– APC
Nov 12 '18 at 7:28
@Abhinav I tried it but then I have to call Oracle and I am not sure what will happen if the DB we are using comes out to be unlicensed!!
– Jay
Nov 12 '18 at 23:12
@Abhinav I tried it but then I have to call Oracle and I am not sure what will happen if the DB we are using comes out to be unlicensed!!
– Jay
Nov 12 '18 at 23:12
@Chunky Don’t worry. Just make a call & get the details.
– Abhinav
Nov 13 '18 at 2:45
@Chunky Don’t worry. Just make a call & get the details.
– Abhinav
Nov 13 '18 at 2:45
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
});
}
});
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%2f53256198%2fhow-can-i-verify-if-the-installed-oracle-11g-is-licensed-or-not%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
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f53256198%2fhow-can-i-verify-if-the-installed-oracle-11g-is-licensed-or-not%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
1
You can have an answer for your question here: [dba.stackexchange.com/questions/60054/…
– Abhinav
Nov 12 '18 at 7:12
There isn't anything in the actual database which can give you this information. Somebody in your organisation should be tracking the paperwork. If they haven't been then you will probably need to approach Oracle Licensing Management Services. I say "you" but this is a management task. It would be worth verifying which options you've been using. Find out more
– APC
Nov 12 '18 at 7:28
@Abhinav I tried it but then I have to call Oracle and I am not sure what will happen if the DB we are using comes out to be unlicensed!!
– Jay
Nov 12 '18 at 23:12
@Chunky Don’t worry. Just make a call & get the details.
– Abhinav
Nov 13 '18 at 2:45