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: [suse-oracle] methods to increase sga size on SLES 9

Draghici Gabi

2006-02-20

Replies:
Isn't any other way to do this without to give up to db_cache_size,
db_Xk_cache_size (and more important for me : db_keep_cache_size) for
db_block_buffers and USE_INDIRECT_DATA_BUFFERS=TRUE ????

----- Original Message -----
From: "Angie Meeks" <ameeks@(protected)>
To: "Gabi Draghici" <gabi.draghici@(protected)>
Sent: Friday, February 17, 2006 7:57 PM
Subject: RE: [suse-oracle] methods to increase sga size on SLES 9


Are you following note 317139.1?

Did you change your init ora ?

Angie

-----Original Message-----
From: Gabi Draghici [mailto:gabi.draghici@(protected)]
Sent: Friday, February 17, 2006 9:57 AM
To: Magni Fabrizio; suse oracle
Subject: Re: [suse-oracle] methods to increase sga size on SLES 9

I finally had a little spare time to read more about the remapping and
hugepages !
The remapping way seems a bit safer(but with it's limits) and I want to
try the hugepages ! ;)) So I did what you describe in the document :

set  nr_hugepages :
  echo 2048 > /proc/sys/vm/nr_hugepages

create and mount hugetlbfs :

  mkdir /dev/hugetlbfs
  mount -t hugetlbfs -o uid=55,gid=59,mode=0777 hugetlbfs
/dev/hugetlbfs

but when I start oracle I still hit :
      ORA-27123: unable to attach to shared memory segment


After I modify db_cache_size back to 1G and I start oracle Ican see :

cat /proc/meminfo |grep Huge
HugePages_Total:   17
HugePages_Free:   17
Hugepagesize:   2048 kB

Any ideea ?

GAbi


----- Original Message -----
From: "Magni Fabrizio" <Fabrizio.Magni@(protected)>
To: "Gabi Draghici" <gabi.draghici@(protected)>
Sent: Tuesday, February 14, 2006 2:27 PM
Subject: RE: [suse-oracle] methods to increase sga size on SLES 9


Hi Gabi, unfortunately today I'm not totally free to support you since I
have obligations in the office.

I can send you this link: hugepages on SLES9:
http://www.gesinet.it/oracle/hugetlb.html

I used the ramapping technique only on redhat but I'm curios to know if
it works even on suse (probably you already know the metalink docs
describing it).

Regards
Fabrizio

> -----Original Message-----
> From: Gabi Draghici [mailto:gabi.draghici@(protected)]
> Sent: 14 February, 2006 9:38 AM
> To: Magni Fabrizio
> Subject: Re: [suse-oracle] methods to increase sga size on SLES 9
>
> I've learn a few things from this posts so I see no reason why I
> should'n give something back !!
> Sure I'll post it ! But, first you have to teach me how to use and
> more important how to test "base memory remapping or hugetlb
> filesystem" under sles 9 ! By the way there is any risk involve in
> this procedure ? I mean , we are talking about a production machine
> .... !
>
> Gabi
>
>
> ----- Original Message -----
> From: "Magni Fabrizio" <Fabrizio.Magni@(protected)>
> To: <suse-oracle@(protected)"
> <gabi.draghici@(protected)>
> Sent: Tuesday, February 14, 2006 10:21 AM
> Subject: RE: [suse-oracle] methods to increase sga size on SLES 9
>
>
> Hi Gabi,
> Sorry to ask but would you post the result of your decision/test if
> either you are going for base memory remapping or hugetlb filesystem?
>
> Many thanks
> Fabrizio
>
> > >
> > > Many appologise for the confusion !
> > > My sga is indeed "Total System Global Area 1778981864 bytes"
> > >
> > > So SGA is already about 1.7 G !
> > > Actually, I'm trying to increase db_cache_size (or any
> > other cache !)
> > > from 1G to 1.5 G which would raise SGA higher that
> > > 1.7 G !!!!
> > >
> >
>
>
> >>> Gabi,
> >>> I'm confused.
> >>>
> >>> ipcs -m showed a shared memory segment of almost 1.7GB
> >>> (1797259264) so close to the limit.
> >>> From what I see you have already a SGA of such size!!!
> >>>
> >>> What's the output of "show sga" from sqlplus?
> >>> The formula for calculating the SGA size is not related to the
> >>> operating system.
> >>>
> >> An example of a system of mine:
> >>>
> >>> SQL> show sga
> >>>
> >>> Total System Global Area 494927872 bytes
> >>> Fixed Size             779776 bytes
> >>> Variable Size         258742784 bytes
> >>> Database Buffers       234881024 bytes
> >>> Redo Buffers           524288 bytes
> >>>
> >>> ipcs -m
> >>>
> >>> ------ Shared Memory Segments --------
> >>> key     shmid    owner    perms    bytes    nattch
> >>>   status
> >>> 0xb4d51eec 229376   oracle   640     499122176 24
> >>>
> >>> As you can see the two values coincide.
> >>>
> >>> Regards
> >>> Fabrizio
> >>>
> >>>
> >>> > -----Original Message-----
> >>> > From: Gabi Draghici [mailto:gabi.draghici@(protected)]
> >>> > Sent: 13 February, 2006 12:59 PM
> >>> > To: Magni Fabrizio
> >>> > Subject: Re: [suse-oracle] methods to increase sga size
> on SLES 9
> >>> >
> >>> > No sir, it is't solve at all !!! so there is no fault !
> ;)) I was
> >>> > asking about calculating couse I thought there is
> something like a
>
> >>> > formula for sga under sles and I don't know about it !!!!
> >>> > The sga is currently 1 M and the problem is hit when I want
> >>> to raise
> >>> > it at
> >>> > 1.5 G ! : "ORA-27123: unable to attach to shared memory segment"
> >>> > So what do you think ???
> >>> >
> >>> > GABI
> >>> >
> >>> > ----- Original Message -----
> >>> > From: "Magni Fabrizio" <Fabrizio.Magni@(protected)>
> >>> > To: "Gabi Draghici" <gabi.draghici@(protected)
> oracle"
> >>> > <suse-oracle@(protected)>
> >>> > Sent: Monday, February 13, 2006 1:26 PM
> >>> > Subject: RE: [suse-oracle] methods to increase sga size
> on SLES 9
> >>> >
> >>> >
> >>> >
> >>> > >
> >>> > > what do you mean by "calculating the value correctly" ?
> >>> > >
> >>> >
> >>> > Sorry, I didn't uderstand you had the problem solved.
> >>> > I was aking if you were sure the SGA parameters were
> leading at a
> >>> > value of 1.7GB. Maybe it was 1.9 and that was the reason of
> >>> the error.
> >>> > This is not the case. My fault.
> >>> >
> >>> > Regards
> >>> > Fabrizio
> >>> >
> >>> >
> >>> > --
> >>> > To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> >>> additional
> >>> > commands, email: suse-oracle-help@(protected)
> >>> > http://www.suse.com/oracle/ before posting
> >>> >
> >>> >
> >>> >
> >>> > __________ NOD32 1.1404 (20060211) Information __________
> >>> >
> >>> > This message was checked by NOD32 antivirus system.
> >>> > http://www.eset.com
> >>> >
> >>> >
> >>> >
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected)

> commands, email: suse-oracle-help@(protected)
> http://www.suse.com/oracle/ before posting
>
>
>
> __________ NOD32 1.1407 (20060213) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.eset.com
>
>
>


__________ NOD32 1.1407 (20060213) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com



--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
commands, email: suse-oracle-help@(protected)
http://www.suse.com/oracle/ before posting



__________ NOD32 1.1413 (20060217) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com



--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting