RMAN

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

RMAN

2005-04-18 - By Justis Durkee

Reply: 1 2 3 4 5 6 7 8 9 10 >>

Hello,

I ran into this very same problem just the other day.

In order to connect to the nomount aux db, you have to set up a static
service for the listener in listener.ora.

SID_LIST_LISTENER =
(SID_DESC=
(global_dbname=...)
(sid_name=standy_sid)
(oracle_home=...)
)
)

Then reload the listener configuration, lsnrctl reload.

Hope that helps.

Justis

Maurice Kemmann wrote:

>Hi Scott,
>
>Am Samstag, den 16.04.2005, 12:50 -0400 schrieb Scott Miller:
>
>
>>looks like a tns config error. check that your listener provides a service
with a name
>>identical to the one in your tnsnames.ora entry. use "lsnrctl status", etc.
>>
>>
>
>yes i think so too but i have no idea which entry i need. All tnspings
>between the two servers work fine. Somehow the command
>
>rman target / catalog rman/rman@(protected) auxiliary sys/PASSWORD@(protected)
>
>makes the problem. Setting the ORACLE_SID to STANDBY( alias in the
>tnsnames) and using
>
>rman target / catalog rman/rman@(protected) auxiliary sys/password
>
>works for the connection ! RMAN says:
>
>Recovery Manager: Release 10.1.0.3.0 - 64bit Production
>
>Copyright (c) 1995, 2004, Oracle. All rights reserved.
>
>connected to target database (not started)
>connected to recovery catalog database
>connected to auxiliary database (not started)
>
>RMAN>
>
>
>But the following script does not work. I guess because of the wrong
>ORACLE_SID.
>
>Script:
>
>run {
> allocate auxiliary channel aux1 device type disk;
> duplicate target database for standby nofilenamecheck;
> release channel aux1;
>}
>
>Error:
>
>RMAN-00571: ===========================================================
>RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
>RMAN-00571: ===========================================================
>RMAN-03002: failure of allocate command at 04/16/2005 19:15:26
>RMAN-06403: could not obtain a fully authorized session
>RMAN-04006: error from auxiliary database: ORA-01034 (See ORA-01034.ora-code.com): ORACLE not
>available
>
>RMAN> **end-of-file**
>
>Any idea ?
>
>Thanx in advance,
>
>Maurice
>
>
>
>
>
>

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