RMAN memory issue

Links

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

RMAN memory issue

RMAN memory issue

2006-07-17 - By John P Weatherman

Reply: 1 2 3 4 5 6 7 8

All,

I am trying to get RMAN configured to handle one of my older databases.
The target is 8.1.7.4, the repository database 9.2.0.7. I have created
an 8.1.7 repository from the target server and registered the target
database. So far, no problems. When I try to allocate channels, I am
getting ORA-4031 (See ORA-4031.ora-code.com) errors (see below). This happens for both maintenance
channels and regular backup channels declared in a run{} block.

-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---
RMAN> allocate channel for maintenance type disk;

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03007: retryable error occurred during execution of command:
allocate
RMAN-07004: unhandled exception during command execution on channel
delete
RMAN-10035: exception raised in RPC: ORA-19554 (See ORA-19554.ora-code.com): error allocating device,
device type: DISK, device name:
ORA-04031 (See ORA-04031.ora-code.com): unable to allocate 1065004 bytes of shared memory ("large
pool","unknown object","large pool hea","KSFQ Buffers")
RMAN-10031: ORA-19624 (See ORA-19624.ora-code.com) occurred during call to
DBMS_BACKUP_RESTORE.DEVICEALLOCATE
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---

The catalog database should have plenty of room:

NAME TYPE VALUE
-- ---- ---- ---- ---- ---- ---- --- -- ---- --- -- ---- ---- ---- -----
large_pool_size big integer 33554432
shared_pool_reserved_size big integer 26843545
shared_pool_size big integer 536870912

as should the target (though the errors says it is coming from the RPC,
so this shouldn't be the issue):

NAME TYPE VALUE
-- ---- ---- ---- ---- ---- ---- --- -- ---- --- -- ---- ---- ---- -----
large_pool_size string 1572792
shared_pool_reserved_size string 2000000
shared_pool_size string 20000000

Has anyone else seen this or have any suggestions?

TIA,

John

John P Weatherman
Oracle DBA
Madison River Communications

--
http://www.freelists.org/webpage/oracle-l