|
Replies:
17
-
Pages:
2
[
1
2
| Next
]
-
Last Post:
Aug 5, 2010 7:59 AM
by: henry sigalos
|
|
|
|
|
|
|
Unknown error: ORA-6831047
Posted:
Jul 26, 2010 10:47 AM
|
|
|
Hi,
I just installed TOAD 9.7.2.5 (because that is the version company has for now)
and when I press Session -> Test Connections (Reconnect), I am getting the
following error every the time:
Unknown error: ORA-6831047
Thank you
|
|
|
Posts:
343
Registered:
2/4/09
|
|
|
|
RE: Unknown error: ORA-6831047
Posted:
Jul 27, 2010 12:22 AM
in response to: henry sigalos
|
|
|
Morning Henry,
>> I just installed TOAD 9.7.2.5 (because that is the version
>> company has for now) and when I press Session -> Test
>> Connections (Reconnect), I am getting the following error
>> every the time:
>>
>> Unknown error: ORA-6831047
Well, I hate to say but that is not an Oracle error code of any known
kind and a Google search turns up three separate hits, all yours! One on
this list, one on blog.gmane.org which mirrors this list and one on
toadfororacle.com.
When you press the "test connections" button, are you connected to any
databases? (Stupid question, I know!)
Please try the following:
Database->Spool SQL->To Screen.
Session->Test Connections.
The window at the bottom of the screen should show you the SQL commands
sent to test the connection(s) and the results received back. If you
post the results here, it may be helpful.
Cheers,
Norm. [TeamT]
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.
We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.
If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk
|
|
|
|
|
|
|
RE: Unknown error: ORA-6831047
Posted:
Jul 27, 2010 12:33 PM
in response to: Norm [TeamT]
|
|
|
Thank you for response.
Attached is the output per your suggestion...
Hope this helped
|
|
|
Posts:
73
Registered:
2/5/09
|
|
|
|
RE: Unknown error: ORA-6831047
Posted:
Jul 27, 2010 1:54 PM
in response to: henry sigalos
|
|
|
end-of-comm is fatal so you have to fix that first otherwise you have no comm
with DB
//go to someone that has god access and create a database profile
CREATE PROFILE HENRY_PROF
LIMIT
SESSIONS_PER_USER default
CPU_PER_SESSION default
CPU_PER_CALL 1000
CONNECT_TIME 120
IDLE_TIME 15
LOGICAL_READS_PER_SESSION default
LOGICAL_READS_PER_CALL default
COMPOSITE_LIMIT default
PRIVATE_SGA default
//now alter henry user to take on the characteristics of that profile
ALTER USER HENRY PROFILE HENRY_PROF
//if 15 min is not enough goto 30 but i wouldnt exceed 30 for security reasons
*norm/roger/somebody please check this*
hth
Martin
______________________________________________
please do not alter/modify or disrupt this transmission. Thank You
|
|
|
Posts:
73
Registered:
2/5/09
|
|
|
|
RE: Unknown error: ORA-6831047
Posted:
Jul 27, 2010 1:54 PM
in response to: henry sigalos
|
|
|
end-of-comm is fatal so you have to fix that first otherwise you have no comm
with DB
//go to someone that has god access and create a database profile
CREATE PROFILE HENRY_PROF
LIMIT
SESSIONS_PER_USER default
CPU_PER_SESSION default
CPU_PER_CALL 1000
CONNECT_TIME 120
IDLE_TIME 15
LOGICAL_READS_PER_SESSION default
LOGICAL_READS_PER_CALL default
COMPOSITE_LIMIT default
PRIVATE_SGA default
//now alter henry user to take on the characteristics of that profile
ALTER USER HENRY PROFILE HENRY_PROF
//if 15 min is not enough goto 30 but i wouldnt exceed 30 for security reasons
*norm/roger/somebody please check this*
hth
Martin
______________________________________________
please do not alter/modify or disrupt this transmission. Thank You
|
|
|
|
|
|
|
RE: Unknown error: ORA-6831047
Posted:
Jul 27, 2010 2:21 PM
in response to: MGainty
|
|
|
How come in the previous TOAD version I did not have this issue, when the
database is the same and only TOAD version changed?
It is hard to get a DBA here, so I am curious if anything I can do first.
Thanks,
Henry
|
|
|
|
|
|
|
RE: Unknown error: ORA-6831047
Posted:
Jul 28, 2010 8:41 AM
in response to: henry sigalos
|
|
|
|
|
1. What oracle client are you using?
2. What are the installed clients? (you can see it in the TOAD login screen
under "Installed Clients").
|
|
|
|
|
|
|
RE: Unknown error: ORA-6831047 [1 Attachment]
Posted:
Jul 28, 2010 9:23 AM
in response to: George.Meltser@...
|
|
|
[ Attachment(s) from henry sigalos included below]
Attached are Installed Clients screenshots...
Thank you
|
|
|
Posts:
73
Registered:
2/5/09
|
|
|
|
RE: Unknown error: ORA-6831047
Posted:
Jul 28, 2010 5:47 PM
in response to: henry sigalos
|
|
|
Henry
i think my hotmail account people must've sent only the hotmail attachments!
Heres a workaround:
<ALT><PrintScreen>
find your FavoritePaintProgram (in windows pbrush.exe will do)
cmd>pbrush.exe
edit/paste (sometimes it says paste image)
file/save as ClientScreen1.jpg
repeat process for each Client Screen and retransmit
thanks,
Martin Gainty
______________________________________________
Do not alter/modify/disrupt this Transmission. Thank You
|
|
|
|
|
|
|
RE: Unknown error: ORA-6831047 [2 Attachments]
Posted:
Jul 29, 2010 7:39 AM
in response to: MGainty
|
|
|
[ Attachment(s) from henry sigalos included below]
new attachments...
Thanks again
|
|
|
|
|
|
|
RE: Unknown error: ORA-6831047
Posted:
Jul 29, 2010 8:01 AM
in response to: henry sigalos
|
|
|
You still did not answer the question:
1. What is the oracle client that you use for TOAD?
|
|
|
|
|
|
|
RE: Unknown error: ORA-6831047
Posted:
Jul 30, 2010 7:14 AM
in response to: George.Meltser@...
|
|
|
|
|
|
|
|
|
|
RE: Unknown error: ORA-6831047
Posted:
Aug 2, 2010 8:18 AM
in response to: henry sigalos
|
|
|
Copied from error message window, after the fact...
Hope this helps more.
EurekaLog 6.0.15
Application:
|
|
|
Posts:
304
Registered:
5/19/06
|
|
|
|
RE: Unknown error: ORA-6831047
Posted:
Aug 3, 2010 5:14 AM
in response to: henry sigalos
|
|
|
Just an observation – you are using an Oracle client that even Oracle no
longer supports. It may not be related – BUT …..
|
|
|
Posts:
343
Registered:
2/4/09
|
|
|
|
RE: Unknown error: ORA-6831047
Posted:
Aug 3, 2010 5:28 AM
in response to: bscalzo
|
|
|
I wonder why I'm never getting any of the emails for this topic.
I've had the original post, my reply, and nothing until this one from
Bert, and yet, looking down the email trail, lots of replies have been
sent. Spooky!
Nothing in my junk folder and my ISP Spam Trap shows nothing either. I
feel I'm missing out!
Cheers,
Norm. [TeamT]
Norman Dunbar
Contract Senior Oracle DBA
Capgemini Database Team (EA)
Internal : 7 28 2051
External : 0113 231 2051
>>
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
