Toad World® Forums

Unknown error: ORA-6831047


#1

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


#2

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


#3

Thank you for response.

Attached is the output per your suggestion…
Hope this helped


#4

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


#5

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


#6

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


#7
  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”).
    image001.jpeg


#8

[ Attachment(s) from henry sigalos included below]

Attached are Installed Clients screenshots…
Thank you


#9

Henry

i think my hotmail account people must’ve sent only the hotmail attachments!

Heres a workaround:

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


#10

[ Attachment(s) from henry sigalos included below]

new attachments…

Thanks again


#11

You still did not answer the question:

  1. What is the oracle client that you use for TOAD?

#12

#13

Copied from error message window, after the fact…
Hope this helps more.

EurekaLog 6.0.15
Application:


#14

Just an observation – you are using an Oracle client that even Oracle no
longer supports. It may not be related – BUT ……


#15

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


#16

Henry

if your oracle-client is no longer supported you wont be able to connect to
Oracle
also this 9.7.2.5 version of toad coded with Pascal is old
i’m sure the folks at Quest realising there is an issue with their product can
suggest a newer working version of toad.

Keep us apprised,
Martin Gainty
Do not alter or disrupt this communication. Thank You


#17

Actually Quest still supports versions 10.5, 10.0, and 9.7.

Jeff


#18

I am not having trouble connecting the first time. When database times out, then
communication is lost and have to reconnect. That is where I get error. Is there
memory leak somwhere?
Thanks,
Henry