Error during CSSCAN of Oracle11 databasegetting error installing oracle 11gR2: cannot access nodeORA-12899:...
How can I differentiate duration vs starting time
The Late Queen Gives in to Remorse - Reverse Hangman
Identical projects by students at two different colleges: still plagiarism?
Does resurrection consume material components if the target isn’t willing to be resurrected?
Reading source code and extracting json from a url
What does an unprocessed RAW file look like?
Which was the first story to feature space elevators?
Build ASCII Podiums
Cryptic cross... with words
How can changes in personality/values of a person who turned into a vampire be explained?
Multiplying elements of a list
How do I avoid the "chosen hero" feeling?
Aligning Systems of Equations
What does @ mean in a hostname in DNS configuration?
Why is Bernie Sanders maximum accepted donation on actblue $5600?
Have the UK Conservatives lost the working majority and if so, what does this mean?
TikZtree with asymmetric siblings
How to achieve physical gender equality?
In a world with multiracial creatures, what word can be used instead of mankind?
Found a major flaw in paper from home university – to which I would like to return
Why is Shelob considered evil?
SFDX CLI - Locked with an active writer?
Is corrosion inhibitor paste conductive?
Are there any spells or magic items that allow for making of ‘logic gates or wires’?
Error during CSSCAN of Oracle11 database
getting error installing oracle 11gR2: cannot access nodeORA-12899: importing a .dmp file + character set conversionOracle 10g - Sudden change in execution time for specific queryInstalling Oracle 11gR2 on Oracle Linux 6 - error possibly related to database (unique) nameHow to find out the segment behind a corrupted block when the database cannot be opened?Specify NLS-Settings during Oracle installation under WindowsError during Oracle database 12c Release 1 installationOracle 12 startup issue: disk full?ORA-00205 error during the startup of physical standby databaseora-12514 Error While Connecting local Oracle EXPRESS EDITION 11
I have an issue when trying to change the character set on an Oracle 11.2 database.
Here are the particulars:
- Oracle 11.2 64 bit, running under Oracle Linux 7
- This is a new installation (i.e. the only users are those that were created during the Oracle install), using the defaults given during the Oracle installation
- The current NLS_CHARACTERSET is AL32UTF8, and I need to
convert it to either WE8MSWIN1252 or WE8DEC
Most of my experience with Oracle has been with Windows, and I've never had to change the character sets before.
Now I can't just change the character set from AL32UTF8 to WE8DEC or WE8MSWIN1252 because those aren't supersets. So, I ran CSINST.SQL, and ran the CSSCAN command. Most of the scan was successful, but I ended up receiving the following errors:
. processs 1 scanning XDB.PRIN_PT[AAAN9DAACAAAEGoAAA]
ORA-30967: operation directly on the Path Table is disallowed
CSS-00144: failed to scan table XDB.PRIN_PT
Does anyone have any idea what the problem can be and/or how to fix it?
I've done some searching.I did find someone who has mentioned deleting and recreating XML indexes, but I've never done that.
oracle character-set
edited Oct 26 '16 at 3:24
JSapkota
7,5761823
asked Oct 25 '16 at 22:01
segnosaursegnosaur
312
bumped to the homepage by Community♦ 43 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 |
I have an issue when trying to change the character set on an Oracle 11.2 database.
Here are the particulars:
- Oracle 11.2 64 bit, running under Oracle Linux 7
- This is a new installation (i.e. the only users are those that were created during the Oracle install), using the defaults given during the Oracle installation
- The current NLS_CHARACTERSET is AL32UTF8, and I need to
convert it to either WE8MSWIN1252 or WE8DEC
Most of my experience with Oracle has been with Windows, and I've never had to change the character sets before.
Now I can't just change the character set from AL32UTF8 to WE8DEC or WE8MSWIN1252 because those aren't supersets. So, I ran CSINST.SQL, and ran the CSSCAN command. Most of the scan was successful, but I ended up receiving the following errors:
. processs 1 scanning XDB.PRIN_PT[AAAN9DAACAAAEGoAAA]
ORA-30967: operation directly on the Path Table is disallowed
CSS-00144: failed to scan table XDB.PRIN_PT
Does anyone have any idea what the problem can be and/or how to fix it?
I've done some searching.I did find someone who has mentioned deleting and recreating XML indexes, but I've never done that.
oracle character-set
edited Oct 26 '16 at 3:24
JSapkota
7,5761823
asked Oct 25 '16 at 22:01
segnosaursegnosaur
312
bumped to the homepage by Community♦ 43 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
3
If this is a new installation, is there a reason that you don't just re-install with the character set that you want? That's generally going to be easier than trying to do a conversion. Functionally, I'm not sure why you'd want to convert away from a Unicode character set but I assume you have your reasons.
– Justin Cave
Oct 25 '16 at 22:20
Got to agree with @JustinCave on this one...
– Philᵀᴹ
Oct 26 '16 at 8:20
add a comment |
I have an issue when trying to change the character set on an Oracle 11.2 database.
Here are the particulars:
- Oracle 11.2 64 bit, running under Oracle Linux 7
- This is a new installation (i.e. the only users are those that were created during the Oracle install), using the defaults given during the Oracle installation
- The current NLS_CHARACTERSET is AL32UTF8, and I need to
convert it to either WE8MSWIN1252 or WE8DEC
Most of my experience with Oracle has been with Windows, and I've never had to change the character sets before.
Now I can't just change the character set from AL32UTF8 to WE8DEC or WE8MSWIN1252 because those aren't supersets. So, I ran CSINST.SQL, and ran the CSSCAN command. Most of the scan was successful, but I ended up receiving the following errors:
. processs 1 scanning XDB.PRIN_PT[AAAN9DAACAAAEGoAAA]
ORA-30967: operation directly on the Path Table is disallowed
CSS-00144: failed to scan table XDB.PRIN_PT
Does anyone have any idea what the problem can be and/or how to fix it?
I've done some searching.I did find someone who has mentioned deleting and recreating XML indexes, but I've never done that.
oracle character-set
edited Oct 26 '16 at 3:24
JSapkota
7,5761823
asked Oct 25 '16 at 22:01
segnosaursegnosaur
312
I have an issue when trying to change the character set on an Oracle 11.2 database.
Here are the particulars:
- Oracle 11.2 64 bit, running under Oracle Linux 7
- This is a new installation (i.e. the only users are those that were created during the Oracle install), using the defaults given during the Oracle installation
- The current NLS_CHARACTERSET is AL32UTF8, and I need to
convert it to either WE8MSWIN1252 or WE8DEC
Most of my experience with Oracle has been with Windows, and I've never had to change the character sets before.
Now I can't just change the character set from AL32UTF8 to WE8DEC or WE8MSWIN1252 because those aren't supersets. So, I ran CSINST.SQL, and ran the CSSCAN command. Most of the scan was successful, but I ended up receiving the following errors:
. processs 1 scanning XDB.PRIN_PT[AAAN9DAACAAAEGoAAA]
ORA-30967: operation directly on the Path Table is disallowed
CSS-00144: failed to scan table XDB.PRIN_PT
Does anyone have any idea what the problem can be and/or how to fix it?
I've done some searching.I did find someone who has mentioned deleting and recreating XML indexes, but I've never done that.
oracle character-set
oracle character-set
edited Oct 26 '16 at 3:24
JSapkota
7,5761823
asked Oct 25 '16 at 22:01
segnosaursegnosaur
312
edited Oct 26 '16 at 3:24
JSapkota
7,5761823
asked Oct 25 '16 at 22:01
segnosaursegnosaur
312
edited Oct 26 '16 at 3:24
JSapkota
7,5761823
edited Oct 26 '16 at 3:24
JSapkota
7,5761823
edited Oct 26 '16 at 3:24
JSapkota
7,5761823
7,5761823
asked Oct 25 '16 at 22:01
segnosaursegnosaur
312
asked Oct 25 '16 at 22:01
segnosaursegnosaur
312
asked Oct 25 '16 at 22:01
segnosaursegnosaur
312
312
bumped to the homepage by Community♦ 43 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♦ 43 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
3
If this is a new installation, is there a reason that you don't just re-install with the character set that you want? That's generally going to be easier than trying to do a conversion. Functionally, I'm not sure why you'd want to convert away from a Unicode character set but I assume you have your reasons.
– Justin Cave
Oct 25 '16 at 22:20
Got to agree with @JustinCave on this one...
– Philᵀᴹ
Oct 26 '16 at 8:20
add a comment |
3
If this is a new installation, is there a reason that you don't just re-install with the character set that you want? That's generally going to be easier than trying to do a conversion. Functionally, I'm not sure why you'd want to convert away from a Unicode character set but I assume you have your reasons.
– Justin Cave
Oct 25 '16 at 22:20
Got to agree with @JustinCave on this one...
– Philᵀᴹ
Oct 26 '16 at 8:20
3
3
If this is a new installation, is there a reason that you don't just re-install with the character set that you want? That's generally going to be easier than trying to do a conversion. Functionally, I'm not sure why you'd want to convert away from a Unicode character set but I assume you have your reasons.
– Justin Cave
Oct 25 '16 at 22:20
If this is a new installation, is there a reason that you don't just re-install with the character set that you want? That's generally going to be easier than trying to do a conversion. Functionally, I'm not sure why you'd want to convert away from a Unicode character set but I assume you have your reasons.
– Justin Cave
Oct 25 '16 at 22:20
Got to agree with @JustinCave on this one...
– Philᵀᴹ
Oct 26 '16 at 8:20
Got to agree with @JustinCave on this one...
– Philᵀᴹ
Oct 26 '16 at 8:20
add a comment |
1 Answer
1
active
oldest
votes
This is known issue for Oracle Database version 11.2 or higher where XDB is installed. My Oracle Support says this can be ignored and has been fixed in 11.2.0.2
Installing and configuring Csscan in 10g and 11g (Database Character Set Scanner) (Doc ID 745809.1)
answered Oct 26 '16 at 3:26
JSapkotaJSapkota
7,5761823
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%2f153320%2ferror-during-csscan-of-oracle11-database%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
This is known issue for Oracle Database version 11.2 or higher where XDB is installed. My Oracle Support says this can be ignored and has been fixed in 11.2.0.2
Installing and configuring Csscan in 10g and 11g (Database Character Set Scanner) (Doc ID 745809.1)
answered Oct 26 '16 at 3:26
JSapkotaJSapkota
7,5761823
add a comment |
This is known issue for Oracle Database version 11.2 or higher where XDB is installed. My Oracle Support says this can be ignored and has been fixed in 11.2.0.2
Installing and configuring Csscan in 10g and 11g (Database Character Set Scanner) (Doc ID 745809.1)
answered Oct 26 '16 at 3:26
JSapkotaJSapkota
7,5761823
add a comment |
This is known issue for Oracle Database version 11.2 or higher where XDB is installed. My Oracle Support says this can be ignored and has been fixed in 11.2.0.2
Installing and configuring Csscan in 10g and 11g (Database Character Set Scanner) (Doc ID 745809.1)
answered Oct 26 '16 at 3:26
JSapkotaJSapkota
7,5761823
This is known issue for Oracle Database version 11.2 or higher where XDB is installed. My Oracle Support says this can be ignored and has been fixed in 11.2.0.2
Installing and configuring Csscan in 10g and 11g (Database Character Set Scanner) (Doc ID 745809.1)
answered Oct 26 '16 at 3:26
JSapkotaJSapkota
7,5761823
edited Nov 4 '16 at 10:18
answered Oct 26 '16 at 3:26
JSapkotaJSapkota
7,5761823
answered Oct 26 '16 at 3:26
JSapkotaJSapkota
7,5761823
answered Oct 26 '16 at 3:26
JSapkotaJSapkota
7,5761823
7,5761823
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%2f153320%2ferror-during-csscan-of-oracle11-database%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
3
If this is a new installation, is there a reason that you don't just re-install with the character set that you want? That's generally going to be easier than trying to do a conversion. Functionally, I'm not sure why you'd want to convert away from a Unicode character set but I assume you have your reasons.
– Justin Cave
Oct 25 '16 at 22:20
Got to agree with @JustinCave on this one...
– Philᵀᴹ
Oct 26 '16 at 8:20