Re: Re: standby_archive_dest in standby DB

From: Cyril Thankappan <cyril_thank_at_rediffmail.com>
Date: 6 Dec 2000 12:13:41 -0000
Message-Id: <10702.123769@fatcity.com>

Hi!

Allow me to make amends..
I deeply regret my statement below..

The LOG_ARCHIVE_DEST and STANDBY_ARCHIVE_DEST is suggested by oracle to be same.

Regards..
------------- Original Message -------------- "Cyril Thankappan" <cyril_thank_at_rediffmail.com> wrote: To:Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> From:"Cyril Thankappan" <cyril_thank_at_rediffmail.com> Date:Tue, 05 Dec 2000 00:20:31 -0800
Subject:Re: standby_archive_dest in standby DB

Hi!

Keep LOG_ARCHIVE_DEST and STANDBY_ARCHIVE_DEST different (preferably!)

Regards

Original Message -------------- Rahul <rahul_at_ratelindo.co.id> wrote: To:Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> From:Rahul <rahul_at_ratelindo.co.id> Date:Mon, 04 Dec 2000 21:00:26 -0800 Subject:standby_archive_dest in standby DB

List, i'm about to create a standby DB in 8.1.5 (AIX), i have a doubt about the online redo logs of the standby,

i have defined a remote destination in the primary DB log_archive_dest_2 = "service=STDBY OPTIONAL reopen=60"

my questions are..
1) the logs from the primary will be copied to the dir specified by the param "standby_archive_dest" of the standby machine, correct ?

2) as the standby DB is also in ARCHIVELOG mode, what should be the "LOG_ARCHIVE_DEST" in the standby db ? same as the STANDBY_ARCHIVE_DEST" ?

3) my dir structure is different ( but the datafile name are same) on both machines,
will i HAVE to use DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT ?

TIA Rahul

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Rahul
INET: rahul_at_ratelindo.co.id

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com

Participate in crazy auctions at http://auctions.rediff.com/auctions/

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Cyril Thankappan
INET: cyril_thank_at_rediffmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com

Participate in crazy auctions at http://auctions.rediff.com/auctions/

From: "Nagadevi Kavali" <Nagadevik_at_coreobjects.com> Date: Wed, 6 Dec 2000 17:57:48 +0530
Subject: RE: Urgent: Problem installing Oracle 817 on solaris8

Recently, I had the same problem while I was installing 816 on solaris 8. The reasons may be:

	1.SUN doesn't supply C/C++ compiler by default,
		You need to install trial C/C++ compiler from one of the CDs supplied by
SUN.
		Then you need to send an e-mail asking for your license info. which is
again only for 45 days.
	2. Set env. variable

LD_LIBRARY_PATH=/usr/lib;/usr/ccs/lib;/var/SUNWspro/lib;$ORACLE_HOME/lib;$OR ACLE_HOME/rdbms/lib;

The order also matters. make sure it's taking right C compiler, by giving 'which cc' command.

Nagadevi.
DBA & Database Architect
Core OBjects India Pvt. Ltd.,

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ravindra Basavaraja
Sent: Wednesday, December 06, 2000 12:47 AM To: Multiple recipients of list ORACLE-L Subject: RE: Urgent: Problem installing Oracle 817 on solaris8

right..i have many people logged on calls with similar errors but no reply fom oracle...

u need to check the permissions also...

ravindra

-----Original Message-----
Winnie_Liu_at_infonet.com
Sent: Tuesday, December 05, 2000 5:56 PM To: Multiple recipients of list ORACLE-L

I have similar error one time, as the log files saying something totally bizzare.

I even log a TAR with Oracle support which didn't really help me in any way.

I later on find out that it is a permission problem on the file system. Oracle will to be rwx on the ORACLE_HOME and a parent level to the ORACLE_HOME. After I make Oracle accessible to the file system prior to ORACLE_HOME, everything works fine.

WInnie

"Krishna Prasad" <krishna_at_nehanet.com>@fatcity.com on 12/05/2000 08:57:04 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Hi,

I had posted this last week but haven't got any responses. If anybody has run into a similiar problem, I would really appreciate any feedback.

Thanks,
-Krishna.

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, November 27, 2000 11:26 AM

> Hi,
>
> I'm running into a problem installing oracle 817 on Solaris8 - the box

does

> not
> have any compilers on it but does have the binaries expected under
> /usr/ccs/bin/...
>
> I don't understand why it needs to be relinked as i'm installing it as
> 'oracle' who
> is a member of groups 'oinstall' and 'dba' - in addition, i don't

understand

> why
> 'as' needs to be invoked - isn't it some assembly-level??? anyway, it's
> failing
> with several "syntax errors" in oracle files!!!!
>
> any help would be greatly appreciated - i've enclosed relevant portions

> the make.log
> below...
>
> Thanks,
> -Krishna.
>
>
/***************************************************************************

> **********************/
>
> /usr/ccs/bin/make -f ins_net_client.mk ntcontab.o
> ORACLE_HOME=/data1/app/oracle/8.1.7
> (if [ "assemble" = "compile" ] ; then \
>   /data1/app/oracle/8.1.7/bin/gennttab > ntcontab.c ;\
>   cc  -c ntcontab.c ;\
>   rm -f /data1/app/oracle/8.1.7/lib/ntcontab.o ;\
>   mv ntcontab.o /data1/app/oracle/8.1.7/lib ;\
>           /usr/ccs/bin/ar rv /data1/app/oracle/8.1.7/lib/libn8.a
> /data1/app/oracle/8.1.7/lib/ntcontab.o ; fi)
> (if [ "assemble" = "assemble" ] ; then \
>   /data1/app/oracle/8.1.7/bin/gennttab > ntcontab.s ;\
>   /usr/ccs/bin/as -P -o ntcontab.o ntcontab.s ;\
>   rm -f /data1/app/oracle/8.1.7/lib/ntcontab.o ;\
>   mv ntcontab.o /data1/app/oracle/8.1.7/lib ;\
>           /usr/ccs/bin/ar rv /data1/app/oracle/8.1.7/lib/libn8.a
> /data1/app/oracle/8.1.7/lib/ntcontab.o ; fi)
> /usr/ccs/bin/as: "ntcontab.s", line 6: error: statement syntax
> /usr/ccs/bin/as: "ntcontab.s", line 7: error: statement syntax
> /usr/ccs/bin/as: "ntcontab.s", line 8: error: statement syntax
> /usr/ccs/bin/as: "ntcontab.s", line 9: error: statement syntax
> /usr/ccs/bin/as: "ntcontab.s", line 10: error: statement syntax
> /usr/ccs/bin/as: "ntcontab.s", line 11: error: statement syntax
> .
> .
> .
> mv: cannot access ntcontab.o
> ar: cannot open /data1/app/oracle/8.1.7/lib/ntcontab.o
>  No such file or directory
> .
> .
> .
> /usr/ccs/bin/make -f ins_net_client.mk nnfgt.o ORACLE_HOME
> =/data1/app/oracle/8.1.7
> (if [ "assemble" = "compile" ] ; then \
>   /data1/app/oracle/8.1.7/bin/gennfgt > nnfgt.c ;\
>   cc  -c nnfgt.c ;\
>   rm -f /data1/app/oracle/8.1.7/lib/nnfgt.o ;\
>   mv nnfgt.o /data1/app/oracle/8.1.7/lib ;\
>           /usr/ccs/bin/ar rv /data1/app/oracle/8.1.7/lib/libn8.a
> /data1/app/oracle/8.1.7/lib/nnfgt.o ; fi)
> (if [ "assemble" = "assemble" ] ; then \

> /data1/app/oracle/8.1.7/bin/gennfgt > nnfgt.s ;\ > /usr/ccs/bin/as -P -o nnfgt.o nnfgt.s ;\ Received on Wed Dec 06 2000 - 06:13:41 CST