RE: Upgrade to 8.1.7.4?

[M B Shibu]

Hi  

I upgraded my server from 8.1.7.0 to 8.1.7.4.1 on july and still now
there 
is no problem at all.

Thanks
Shibu
Oracle DBA 
Acusis 






-Original Message-
Naude
Sent: Tuesday, August 27, 2002 12:08 PM
To: Multiple recipients of list ORACLE-L

Hi there.

Has anyone picked up any problems while installing the 8.1.7.4 patch?
I am going from 8.1.7.0 to 8.1.7.4 and would like to know if tehre are
any
known problems?

Thanks

Clint

*   Clinton S. Naudé
*   Head DBA Services 
*   Tel: 011 685 4304
*   Fax: 011 685 4303
*   Cell: 082 377 1726
*   E-mail: [EMAIL PROTECTED] 


Confidentiality Warning

===

The contents of this message and any attachments are intended solely for
the
addressee's use and may be legally privileged and/or confidential. If
you
are not the addressee indicated in this message, any retention,
distribution, copying or use of this message is strictly prohibited. If
you
received this message in error, kindly notify the sender immediately by
reply e-mail and then destroy the message and any copies thereof. The
content and any views expressed therein are, unless otherwise stated,
the
views of the author and not those of the company or any of its
management or
directors.

Whilst all reasonable steps are taken to ensure the accuracy and
integrity
of information transmitted, the company does not accept responsibility
for
any corruption of the information or data or breach of confidentiality
as a
result of electronic submission.

When addressed to the Momentum Employee Benefits clients any opinion or
advice contained in this e-mail is subject to the terms and conditions
expressed in any applicable terms of business.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Clinton Naude
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: M B Shibu
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: move table to differnt datafile

[M B Shibu]

Thanks a lot  Irfan  

ORA-20001

[M B Shibu]

Hi friends 



My procedure to send email from oracle server  is working fine with oracle 8.1.7.0.0 but not
working in  Oracle 8.1.7.4.1 .

The error which I get is 
given below .

ERROR at line 1:

ORA-20001: 421 Service not available

ORA-06512: at SYS.UTL_SMTP, line 83

ORA-06512: at SYS.UTL_SMTP, line 121

ORA-06512: at SYSTEM.SEND_MAIL, line 18

ORA-06512: at line 1





Did anyone get this error in 8.1.7.4.1? I doubt this is a
bug. Can anyone make this more  clear??



Thanks 

Shibu

error when acessing table_privileges

[M B Shibu]

Hi friends .



I am getting the error ora-24238  when accessing  the table table_privileges . 

  How can I solve this
.?? Oracle version is 8.1.7.4.1 in win2k.



[EMAIL PROTECTED] SELECT * FROM TABLE_PRIVILEGES;

ERROR:

ORA-24328: illegal attribute value

Thanks 

shibu

batch file for Scheduling hotbackup in win2k

[M B Shibu]

HI friends ..

I am having a problem in scheduling my 
hotbackup in win2k . Can anyone send me 
a sample batchfile program which takes 
backup up daily , zip the backup file and 
delete the old backup , old redo logs after 
the backup completion .


regards,
shibu

tns-12541 no listener while using connection manager

[M B Shibu]

Hi friends.
I am having a problem when trying to connect 
through connection manger i have in my tnsnames.ora and cman.ora as given 
below then use_cman = TRUE in sqlnet.ora
and my server is configured for MTS . It's on 
oracle 8.1.7 in win 2k . 
-
TNSNAMES.ORA
-
ABC = (DESCRIPTION 
= (load_balance=on)  
(failover=on) (ADDRESS_LIST = 
( SOURCE_ROUTE = YES ) ( ADDRESS = ( PROTOCOL 
= TCP )( HOST = oracle )(SERVICE = CMAN)( PORT = 1610 
)) ( ADDRESS = (PROTOCOL = TCP)(HOST = 
oracle)(SERVICE = CMAN )( PORT = 1521)) 
) ( CONNECT_DATA = 
 ( SERVICE_NAME = oracledb 
) ) 
)
---
CMAN.ORA
---
cman = 
(ADDRESS_LIST= 
( ADDRESS=( PROTOCOL=tcp 
) 
( HOST= oracle 
) 
( PORT=1630 
) 
( QUEUESIZE=32 
) 
) )cman_profile = ( 
parameter_list= 
( MAXIMUM_RELAYS=1024 
) 
( LOG_LEVEL=1 
) 
( TRACING=yes 
) 
( RELAY_STATISTICS=yes 
) 
( SHOW_TNS_INFO=yes 
) 
( USE_ASYNC_CALL=yes 
) 
( AUTHENTICATION_LEVEL=0 
) 
( REMOTE_ADMIN=FALSE 
) 
)CMAN_ADMIN = 
(ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1650))CMANAGER_NAME = 
cman

But i am getting the error 12541 no 
listener .Please help me in solving this
This is urgent

shibu