Links
• Home
• 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
-none-

-none-

2004-06-10       - By -not available-

Reply:     <<     101     102     103     104     105     106     107     108     109     110     >>  


Oracle 10.1 documentation
----++++++++++++++++++++++++++ UNIX ++++++++++++++++++++++++++----
http://download-west.oracle.com/docs/html/B10812_01/appendix_f.htm#sthre
f837
<http://download-west.oracle.com/docs/html/B10812_01/appendix_f.htm#sthr
ef837 >=20
Oracle(r) Database Administrator 's Reference
10g Release 1 (10.1) for UNIX Systems: AIX-Based Systems, hp HP-UX
PA-RISC (64-bit), hp Tru64 UNIX, Linux x86, and Solaris Operating System
(SPARC)
Part No. B10812-01 =20
Appendix F Database Limits

Table F-1 CREATE CONTROLFILE and CREATE DATABASE Parameters
Parameter Default Maximum Value=20
MAXLOGFILES 16 255=20
MAXLOGMEMBERS 2 5=20
MAXLOGHISTORY 100 65534=20
MAXDATAFILES 30 65534=20
MAXINSTANCES 1 63=20

...


Table F-2 File Size Limits
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Data Files
Operating System Maximum Size=20
Any 4,194,303 multiplied by the value
of the DB_BLOCK_SIZE parameter=20

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Import/Export files and SQL*Loader files

Operating System Maximum Size=20
Tru64 UNIX 16 TB

AIX, HP-UX, Linux, Solaris: 2,147,483,647 bytes
32-bit with 32-bit files

AIX, HP-UX, Linux, Solaris: Unlimited
32-bit with 64-bit files

AIX, HP-UX, Linux, Solaris: Unlimited
64-bit =20


=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Control files
Operating System Maximum Size=20
Solaris, HP-UX, Linux 20000 database blocks=20
AIX 10000 database blocks=20
Tru64 UNIX 19200 database blocks=20



----++++++++++++++++++++++++++ Microsoft Windows
++++++++++++++++++++++++++----
http://download-west.oracle.com/docs/cd/B13789_01/win.101/b10113/specs.h
tm#i1005859
<http://download-west.oracle.com/docs/cd/B13789_01/win.101/b10113/specs.
htm#i1005859 >=20
Oracle(r) Database Platform Guide
10g Release 1 (10.1) for Windows
Part Number B10113-01
Chapter 13 Oracle Database Specifications for Windows


Table 13-3 Block Size Guidelines
Type Size
Maximum block size 16,384 bytes or 16 kilobytes (KB)
Minimum block size 2 kilobytes (KB)
Maximum blocks for each file 4,194,304 blocks
Maximum possible file size 64 Gigabytes (GB)
with 16 K sized blocks


Table 13-4 Maximum Number of Files for Each Database
Block Size Number of Files
2 KB 20,000
4 KB 40,000
8 KB 65,536
16 KB 65,536


Table 13-5 Maximum File Sizes
Type Size
Maximum file size for a FAT file 4 GB
Maximum file size in NTFS 16 Exabytes (EB)
Maximum database size 65,536 * 64 GB equals approximately 4
Petabytes (PB)
Maximum control file size 20,000 blocks=20


-- ---_=_NextPart_001_01C44F41.FD9EEC18
Content-Type: text/html; charset= "us-ascii "
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN " >
<HTML > <HEAD > <TITLE > </TITLE >
<META http-equiv=3DContent-Type content=3D "text/html; =
charset=3Dus-ascii " >
<META content=3D "MSHTML 6.00.2800.1400 " name=3DGENERATOR > </HEAD >
<BODY > <!-- Converted from text/plain format -- >
<P > <FONT face=3D "Courier New " size=3D2 >Whilst writing up a document =
contrasting SQL=20
Server object storage versus Oracle object storage, I was suprised to =
find out=20
that <BR > </FONT > </P >
<P > <FONT face=3D "Courier New " size=3D2 >a) according to documentation, =
the maximum=20
size of a SQL Server database (1 EB) is orders of magnitude greater than =
the=20
maximum size of an Oracle database (8 PB for a 32 KB blocksize database =
if I=20
read the documentation correctly); also a SQL serve datafile can be up =
to 32 TB=20
and an Oracle datafile is limited to 128 GB (in a 32 KB blocksize =
database). And=20
since there can be up to 32,767 databases per SQL Server instance, a SQL =

Server instance can have 32,767 EB =3D 32 ZB of =
data? </P > </FONT >
<P > <FONT face=3D "Courier New " size=3D2 >b) The maximum size of an Oracle =
database=20
hasn 't changed from version 9.2 </FONT > </P >
<P > <FONT face=3D "Courier New " size=3D2 >Does anyone know any =
different? </FONT > </P >
<P > <FONT face=3D "Courier New " size=3D2 >(N.B. SQL Server 2000=20
terminology: <BR > </FONT > <FONT face=3D "Courier New " > <SPAN=20
style=3D "FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman '; =
mso-fareast-font-family: SimSun; mso-ansi-language: EN-US; =
mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA " > <FONT=20
face=3D "Courier New " size=3D2 >instance =3D full installation: the =
program=20
binaries, the processes (Windows services) and registry entries, and the =

physical data files and log files for the databases. The set of physical =

datafiles and log files for all databases of an instance would roughly=20
correspond to an Oracle database. <BR >one instance =3D several =
databases. <BR >one=20
database =3D several filegroups and transaction logs. <BR >one filegroup =
=3D several=20
data files.) <BR > </FONT > <FONT size=3D2 > </SPAN > <SPAN=20
style=3D "FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman '; =
mso-fareast-font-family: SimSun; mso-ansi-language: EN-US; =
mso-fareast-language: ZH-CN; mso-bidi-language: =
AR-SA " >  </SPAN > </FONT > </FONT > <FONT > <BR > <FONT=20
face=3D "Courier New " size=3D2 >Here are some documentation=20
extracts. </FONT > </FONT > </P >
<P > <FONT face=3D "Courier New " size=3D2 > </FONT > <FONT > <FONT =
face=3D "Courier New "=20
size=3D2 > <BR > <BR > </FONT > </FONT > <FONT face=3D "Courier New " size=3D2 >From =
SQL Server=20
2000 Online books: <BR > =20
Object           &=
nbsp;           &n=
bsp;   =20
Maximum sizes/numbers <BR > </FONT > <FONT face=3D "Courier New " =
size=3D2 >Database=20
size           &nb=
sp;           =20
1,048,516 TB (=3D 1 EB) <BR >Databases per instance of SQL =
Server   =20
32,767 <BR >Filegroups per=20
database           =
;        =20
256 <BR >Files per=20
database           =
;          =20
32,767 <BR >File size=20
(data)           &=
nbsp;           &n=
bsp;   =20
32 TB <BR >File size=20
(log)           &n=
bsp;           &nb=
sp;    =20
32 TB <BR >Instances per=20
computer           =
;          =20
16 <BR >Objects in a=20
database           =
;=20
2,147,483,647 <BR > <BR > <BR >Oracle 10.1=20
documentation <BR >----++++++++++++++++++++++++++ UNIX=20
++++++++++++++++++++++++++---- <BR > </FONT > <A=20
href=3D "http://download-west.oracle.com/docs/html/B10812_01/appendix_f.ht=
m#sthref837 " > <FONT=20
face=3D "Courier New "=20
size=3D2 >http://download-west.oracle.com/docs/html/B10812_01/appendix_f.h=
tm#sthref837 </FONT > </A > <BR > <FONT=20
face=3D "Courier New " size=3D2 >Oracle® Database Administrator’s =
Reference <BR >10g=20
Release 1 (10.1) for UNIX Systems: AIX-Based Systems, hp HP-UX PA-RISC =
(64-bit),=20
hp Tru64 UNIX, Linux x86, and Solaris Operating System (SPARC) <BR >Part =
No.=20
B10812-01    <BR >Appendix F Database Limits <BR > <BR >Table =
F-1=20
CREATE CONTROLFILE and CREATE DATABASE=20
Parameters <BR >Parameter      =20
Default    Maximum=20
Value  <BR >MAXLOGFILES      =20
16            =
;=20
255  <BR >MAXLOGMEMBERS     =20
2            =
  =20
5  <BR >MAXLOGHISTORY   =20
100          =20
65534  <BR >MAXDATAFILES     =20
30          =20
65534  <BR >MAXINSTANCES      =20
1            =
 =20
63  <BR > <BR >... <BR > </P > </FONT >
<P > <FONT face=3D "Courier New " size=3D2 >Table F-2 File Size=20
Limits <BR >=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D <BR >=
Data=20
Files <BR >Operating =
System        =20
Maximum Size  <BR >    =20
Any           &nbs=
p;   =20
4,194,303 multiplied by the=20
value <BR >          &nbs=
p;           =20
</FONT > <FONT face=3D "Courier New " size=3D2 > of the DB_BLOCK_SIZE=20
parameter  <BR > <BR >=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D <BR >Import/Export=20
files and SQL*Loader files <BR > <BR >Operating=20
System           &=
nbsp;  =20
Maximum Size  <BR >Tru64=20
UNIX           &nb=
sp;          =20
16 TB <BR > <BR >AIX, HP-UX, Linux, Solaris:  2,147,483,647 =
bytes <BR >32-bit=20
with 32-bit files <BR > <BR >AIX, HP-UX, Linux, Solaris:   =20
Unlimited <BR >32-bit with 64-bit files <BR > <BR >AIX, HP-UX, Linux,=20
Solaris:    Unlimited <BR > =20
64-bit     <BR > <BR > <BR >=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D <BR >Control=20
files <BR >Operating=20
System            =
Maximum=20
Size  <BR >Solaris, HP-UX, Linux   20000 database=20
blocks  <BR >AIX         =
           =20
10000 database blocks  <BR >Tru64=20
UNIX           &nb=
sp; =20
19200 database =
blocks  <BR > <BR > <BR > <BR >----++++++++++++++++++++++++++=20
Microsoft Windows ++++++++++++++++++++++++++---- <BR > </FONT > <A=20
href=3D "http://download-west.oracle.com/docs/cd/B13789_01/win.101/b10113/=
specs.htm#i1005859 " > <FONT=20
face=3D "Courier New "=20
size=3D2 >http://download-west.oracle.com/docs/cd/B13789_01/win.101/b10113=
/specs.htm#i1005859 </FONT > </A > <BR > <FONT=20
face=3D "Courier New " size=3D2 >Oracle® Database Platform Guide <BR >10g =
Release 1=20
(10.1) for Windows <BR >Part Number B10113-01 <BR >Chapter 13 Oracle =
Database=20
Specifications for Windows <BR > <BR > <BR >Table 13-3 Block Size=20
Guidelines <BR >Type         &=
nbsp;           &n=
bsp;           &nb=
sp;=20
Size <BR >Maximum block=20
size            =
16,384=20
bytes or 16 kilobytes (KB) <BR >Minimum block=20
size           &nb=
sp;    =20
2 kilobytes (KB) <BR >Maximum blocks for each file   4,194,304=20
blocks <BR >Maximum possible file =
size       =20
64 Gigabytes (GB) <BR > with 16 K sized blocks <BR > <BR > <BR >Table 13-4 =
Maximum=20
Number of Files for Each Database <BR >Block Size Number of =
Files <BR > 2=20
KB        20,000 <BR > 4=20
KB        40,000 <BR > 8=20
KB        65,536 <BR >16=20
KB        65,536 <BR > <BR > <BR >Table =
13-5=20
Maximum File=20
Sizes <BR >Type          =
            &=
nbsp;           &n=
bsp;=20
Size <BR >Maximum file size for a FAT=20
file         4 GB <BR >Maximum =
file size=20
in=20
NTFS           &nb=
sp;  =20
16 Exabytes (EB) <BR >Maximum database=20
size           &nb=
sp;=20
65,536 * 64 GB equals approximately 4 Petabytes (PB) <BR >Maximum control =
file=20
size           20,000 =
blocks=20
</FONT > </P > </BODY > </HTML >

-- ---_=_NextPart_001_01C44F41.FD9EEC18--
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --