Home
All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

RE: ora-12500 on windows

Paul Drake

2004-02-18

Replies:
--- "Koivu, Lisa" <Lisa.Koivu@(protected):
> Hi Paul,=20
>
> Thanks for your reply and for the link. I am not
> using
> pga_aggregate_target any longer. It was a mess.
> Instead I am tweaking
> down sort_area_size. It's at 1MB right now.
>
> The bottom line is we have all this memory, the
> loads want to run
> screaming parallel, and I need to find the right
> config to do so.
>
> When sga_max_size is at or over 1800m, I get 12500's
> and failed
> sessions.
>
> When the loads run under choose, hash joins begin
> and ora-4030's start
> happening. First_Rows takes care of this, but
> hashing is faster, and I
> do have memory to support it. I just have to config
> it correctly.
>
> Choose + big sga_max_size = Monkey Hunting.
>
> When I bring sga_max_size down and set first_rows,
> everything seems
> happy for the time being. However, it's going to
> change fast and I'll
> have to pursue VLM.
>
> If you read note 225349.1 it states, "What the PAE
> switch allows you to
> do from the Oracle perspective is to increase the
> amount of memory that
> can be used for the Oracle Database Block Buffer
> Cache. It is important
> to note that this additional memory can ONLY be used
> by Oracle in the
> form of an increased value for DB_BLOCK_BUFFERS."
> This makes me wonder
> if it's even worth pursuing. My cache is only set
> around 50m or so.
>
> Thoughts? I'll have to dig through the Microsoft
> link and links given
> on that page in more detail when I don't have people
> breathing down my
> neck. Hey, I may even learn something about
> Windows.
>
> Thanks again, Paul
> Lisa
<snip>

Lisa,

I think that if you get large memory support working,
not /PAE, just /3GB, you'll probably have enough
headroom. 2.7 GB for the oracle.exe will hopefully be
sufficient.

Can you set a logon trigger for your loads, to set the
hash_area_size, sort_area_size to larger values for
the loads, and have the defaults be small for all
other users?

Paul

__________________________________
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------