SQL & PL/SQL :: ORA-29279 / SMTP Permanent Error / 550 (Dropped Spammer Pretending To Be Us)

Apr 13, 2011

We have scheduled many email alerts for management, these were running fine but from three days, we are facing problem.

We received following Error during sending email from Database.

ORA-29279: SMTP permanent error: 550 "Dropped spammer pretending to be us"

View 1 Replies


ADVERTISEMENT

SQL & PL/SQL :: Sending Mail ORA-29279 - SMTP Permanent Error 550

Oct 13, 2010

I'm trying to send email using utl_mail...code is below

BEGIN
UTL_MAIL.send(
sender => 'account@test1.com'
,recipients => 'acount@test2.com'
,subject => 'Test Mail'
,message => 'Hello World'
,mime_type => 'text; charset=us-ascii'
,priority => 3);
END;

but getting following error

ERROR at line 1:
ORA-29279: SMTP permanent error: 550 <account@test2.com[/email]> No such user here
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 99
ORA-06512: at "SYS.UTL_SMTP", line 241
ORA-06512: at "SYS.UTL_MAIL", line 424
ORA-06512: at "SYS.UTL_MAIL", line 594
ORA-06512: at line 2

View 4 Replies View Related

SQL & PL/SQL :: -29279ORA-29279 / SMTP Permanent Error / 501 5.1.7 Invalid Address

Aug 11, 2010

CREATE OR REPLACE PROCEDURE TEST_EMAIL_PO
AS
p_sender VARCHAR2(240):=[email]'techxis1@gear-india.com'[/email];
p_recipient VARCHAR2(240):=[email]'techxis1@gear-india.com'[/email];
p_subject VARCHAR2(240):='Po Summary Roport Result';
p_mailbodyhdr VARCHAR2(240):=null;

[code]....

PL/SQL procedure successfully completed.

but it does not sent mail and DBMS_OUTPUT show the error that -29279ORA-29279: SMTP permanent error: 501 5.1.7 Invalid address

View 9 Replies View Related

TimesTen In-Memory :: Error 802 / 6220 / Permanent Data Partition Free Space Insufficient

Oct 29, 2012

try to evaluate it as IMDB cache.I am facing this error repeatedly. I have increased perm size from 6.25 GB to 10 GB.After inserting about 460.000 rows I get the error again. Is it possible that 460.000 rows need 3.75 GB space?

In Oracle database these rows occupy about 200 MB space.

View 2 Replies View Related

SQL & PL/SQL :: UTL SMTP ORA-29278 - Transient Error?

Jul 2, 2011

Intention is to run the UTL_SMTP and send a mail to my mail id in gmail. Host used is localhost.

Oracle version is 11g

Since my machine is running on Windows 7 and since SMTP server is no more part of IIS, I have not configured any SMTP server for the Operating system.When I run the plsql block , I get the error.

ORA-29278: SMTP transient error: 421 Service not available

see the code below. Some suggesting the SMTP SERVER configuration in Operating system level.

I created the acl list and assigned acls

--Creating acls
begin
dbms_network_acl_admin.create_acl (
acl => 'utl_smtp.xml',
description => 'Allow mail to be send',

[code]....

View 9 Replies View Related

SQL & PL/SQL :: ORA-29278 - SMTP Transient Error - 421 Service Not Available?

May 6, 2008

i am trying to send mail using utl_smtp.but this error occurs. even smtp is installed on server.

ERROR at line 1:
ORA-29278: SMTP transient error: 421 Service not available
ORA-06512: at "SYS.UTL_SMTP", line 21
ORA-06512: at "SYS.UTL_SMTP", line 97

[code]...

View 13 Replies View Related

SQL & PL/SQL :: ORA-29278 / SMTP Transient Error - 421 Service Not Available

Dec 6, 2010

how to test utl_mail.send?

Does this work with [URL] on port 465. What about the authentication of the user who sent it? I have done the following steps, but its giving me some error.

1. sqlplus
2. Login with 'sys as sysdba'
3. Created package by executing 'utlmail.sql' and package body by executing 'prvtmail.plb'
4. ALTER SYSTEM SET smtp_out_server = 'smpt.gmail.com:465' SCOPE=SPFILE
5. shutdown immediate
6. startup

[code]....

It is giving me the following error:

ORA-29278: SMTP transient error: 421 Service not available.

And I read a lot, but there was nothing like authentication. It means if its working with any SMTP server, then any user can send mail from 'bilgates@microsoft.com' to any receiver on the same smtp.

View 7 Replies View Related

SMTP Transient Error - 452 4.3.1 Insufficient System Resources

Nov 13, 2012

We're using UTL_SMTP to send emails from Oracle, and about 2 weeks ago (2 days prior to daylight savings) we start seeing an intermittent "SMTP transient error: 452 4.3.1 Insufficient system resources".

When there's an issue, emails fail from all 3 of our database environments (on separate servers), which leads me to believe that it isn't Oracle's error. But, our Exchange server isn't showing anything in it's Application Event Log, nor it's Protocol Log (although we just changed settings to log more information).

I'm just trying to rule out Oracle at this point, so we can focus our efforts. I've been looking on Google for the past hour and a half, and I can't find anything which points to anything other than the mail server being the culprit in an error situation like this. But, how to determine if the database should stay on the list of items to look into.

View 5 Replies View Related

Backup & Recovery :: Error In Making Permanent Backup?

Jan 11, 2012

error while Making Permanent Backup

RMAN> run
2> {
3> allocate channel c3
4> device type disk
5> parms 'ENV=E:ackup';
6> backup database
7> tag 'Q1_2012'
8> keep forever;}
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "consistent, logs, nologs
"
RMAN-01007: at line 8 column 13 file: standard input

View 3 Replies View Related

SQL & PL/SQL :: Join Two Permanent Tables With Condition

Jan 15, 2013

I have two permanent tables. I want to add the column DELTA_STROM from the table "Delta" into the table "TEST2". Here, the value of the field "POWER_DELTA" in the table "TEST2" depends on the field "Trade_Date".

If the time of the timestamp in table "Test2" is smaller than 12:40 than the value (DELTA_STROM from DELTA) of the day must be added into the field. If the time is huger than 12:40, the value of the next day must be added into the field "POWER_DELTA". All values for "Power_DELTA" for every day are in table "Delta" in the field "DELTA_STROM".

I just added the right values of "Power_Delta" into the table "TEST2" manually to give an understanding.


DATUM DELTA_STROM
-------- -----------
01.01.12 1.92
02.01.12 5.78
03.01.12 0.73
04.01.12 2.84
05.01.12 11.41
06.01.12 -2.76
07.01.12 0.43
08.01.12 1.25
09.01.12 -0.21

TRADE_DATE POWER_DELTA
---------------------------- -----------
02.01.12 11:21:41,720000000 5.78
02.01.12 12:44:01,236000000 0.73
02.01.12 14:05:01,845000000 0.73
02.01.12 16:21:01,345000000 0.73
02.01.12 17:25:41,470000000 0.73
03.01.12 10:31:01,376000000 0.73
03.01.12 11:55:11,798000000 0.73
03.01.12 16:32:47,612000000 2.84
04.01.12 08:24:01,486000000 2.84
04.01.12 12:24:21,189000000 2.84
04.01.12 17:46:21,123000000 11.41

CREATE TABLE "TEST2"
("TRADE_DATE" TIMESTAMP (6),
"POWER_DELTA" NUMBER
);

[Code]....

View 19 Replies View Related

View All User That Was Dropped?

Aug 12, 2010

is it possible to view all user that was dropped? how can i know that one user was create by who>? i'm running on multi dba user in my db. are there any history record when we create user?

View 4 Replies View Related

Partition Table Is Not Getting Dropped?

May 2, 2012

I am trying to delete the partition, but I am getting error "ORA-01426: numeric overflow"

The original partitioning was:

TABLE_NAME PARTITION_NAME NUM_ROWS
F_TFP_CP_MONTH P_201108 0
F_TFP_CP_MONTH P_201201 (NULL)
F_TFP_CP_MONTH P_201202 (NULL)
F_TFP_CP_MONTH P_99999999 (NULL)
F_TFP_CP_MONTH P_201106 1159130358
F_TFP_CP_MONTH P_201105 0
F_TFP_CP_MONTH P_201104 1212566971
F_TFP_CP_MONTH P_201103 1002557990
F_TFP_CP_MONTH P_201102 0
F_TFP_CP_MONTH P_201101 0
F_TFP_CP_MONTH P_201012 0
F_TFP_CP_MONTH P_201011 0
F_TFP_CP_MONTH P_201010 0
F_TFP_CP_MONTH P_201009 0
F_TFP_CP_MONTH P_201112 (NULL)
F_TFP_CP_MONTH P_201111 (NULL)
F_TFP_CP_MONTH P_201110 (NULL)
F_TFP_CP_MONTH P_201109 (NULL)
F_TFP_CP_MONTH P_201107 1627218307

All partitions were dropped, but three; these three returned the same error when trying to drop them:

SQL> alter table dw.F_TFP_CP_MONTH drop partition P_201112;
alter table dw.F_TFP_CP_MONTH drop partition P_201112
*
ERROR at line 1:
ORA-01426: numeric overflow

SQL> alter table dw.F_TFP_CP_MONTH drop partition P_201111;
alter table dw.F_TFP_CP_MONTH drop partition P_201111
*
ERROR at line 1:
ORA-01426: numeric overflow

SQL> alter table dw.F_TFP_CP_MONTH drop partition P_201110;
alter table dw.F_TFP_CP_MONTH drop partition P_201110
*
ERROR at line 1:
ORA-01426: numeric overflow

So, the situation now is that the table only has these three partitions, and we are not able to empty the table, so that we can later purge it and recover the

space.

free that space and empty the contents of the table?

View 1 Replies View Related

How To Recover A Dropped Table

Apr 10, 2013

OS: AIX
DB: 11G

I need to recover a dropped table, I have a RMAN backup of midnight and the table was dropped at 7:00 PM today. I do not have flash back enabled on the database. I am thinking of restoring midnight backup and applying the archives just before the table was dropped and opening the database in resetlogs method.

View 4 Replies View Related

SQL & PL/SQL :: Blank Mail From SMTP

Mar 31, 2012

One more query need to be resolved.

1) I am getting a mail with only the SUBJECT through SMTP.

********* ALERT ********* Tablespace Alert Mail Send from DBA Team. ******** ALERT *********

2) This is from a procedure called 'TBLSPACE_MON_EMAIL'.

CREATE OR replace PROCEDURE "Tblspace_mon_email"
IS
v_smtp_server VARCHAR2(100) := '10.80.23.24';
v_smtp_server_port NUMBER(2) := 25;
v_crlf VARCHAR2(2) := Chr(13)
|| Chr(10);
[code].......

3) It was scheduled as below

What is the problem in this code.

View 18 Replies View Related

SQL & PL/SQL :: Emailing Through Oracle UTL-SMTP?

Oct 10, 2011

I am using Oracle 10.2.0.4, on redhat linux 5.1 and microsoft exchange 2003.

I have created below mentioned Procedure to send my email...I am able to send the mails successfully inside the premises (in same domain). But when i send them to another domain (Outside)..I get the error "SMTP permanent error: 503 5.5.2 Send hello first."

CREATE OR REPLACE PROCEDURE E_Mail(
p_to IN VARCHAR2,
p_from IN VARCHAR2,
p_subject IN VARCHAR2,
p_text IN VARCHAR2 DEFAULT NULL,

[code]...

View 9 Replies View Related

SQL & PL/SQL :: Smtp Mail Configuration?

Nov 23, 2010

I have created a procedure and i am scheduling the procedure to run in dbms jobs. In the procedure, i am using UTL_SMTP connection to receive mail everything is working fine it. In the receipent if i give one email id it is working fine. if i give multiple email id in it am getting error.

View 13 Replies View Related

SQL & PL/SQL :: Undo Dropped Column From Table

Jul 13, 2013

Flashback query is working fine for dropped table,but throwing error when trying to get back the previous date by dropping a column from a table.

FLASHBACK TABLE emp TO TIMESTAMP TO_TIMESTAMP('2013-07-13 05:00:00', 'YYYY-MM-DD HH24:MI:SS')

SQL Error: ORA-01466: unable to read data - table definition has changed

Is that a limitation of Oracle by not having query to flashback a column but a table.

View 4 Replies View Related

SQL & PL/SQL :: Triggers Dropped And Stored In Recycle Bin

Dec 5, 2012

Some triggers are dropped and stored in recycle bin. when i am trying to restore it by the command

1* alter trigger "BIN$FFRO1R1LSuSIZ6uyLocD6g==$0" rename to WFNOTIFICATION_GEN_PK
SQL> /
alter trigger "BIN$FFRO1R1LSuSIZ6uyLocD6g==$0" rename to WFNOTIFICATION_GEN_PK
*

ERROR at line 1:
ORA-38301: can not perform DDL/DML over objects in Recycle Bin

View 13 Replies View Related

SQL & PL/SQL :: Unable To Send Mail Using UTL SMTP

Mar 6, 2013

I am using utl_smtp to send emails. I am getting the below error message.

Error in XX(Package name) ORA-29279: SMTP permanent error: 501 5.5.2 Syntax error in parameters scanning "TO" at - 5150
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 5200
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 5200
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 7200
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 6000
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 7250
Error in XX(Package name) ORA-29277: invalid SMTP operation at - 8450.

I have checked the mail id in the "TO" list and found them to be valid. Is there could be any other reason? I have run this package in test instance and it is working fine. I am able to receive mails. In the test instance, I have put my mail id in the to list.

View 1 Replies View Related

Backup & Recovery :: Retrieve Dropped Tables?

Jun 20, 2012

One of the developer dropped 18 tables by mistake on USER@db schema. Developer asked whether I can restore those tables, but unfortunately they are not in the recycle bin. Developer is re-creating the table now though. But I am just curious whether we need to change these parameters (db_recycle_cache_size) in order support any similar requests in the future.

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recycle_cache_size big integer 0
recyclebin string on

View 10 Replies View Related

How To Audit When A Constraint Is Disabled / Enabled Or Dropped

Sep 3, 2013

Is it possible to audit when a constraint is disabled, enabled or dropped? Sometimes I wonder why some constraints are missing. To make sure someone is dropping I would like to audit that action. Further, I would need to compare schemas to realize if some constraints are missing. As it names are generated automatically by oracle, how could I easily run a select to compare the constraints that does not match between schemas?

View 10 Replies View Related

SQL & PL/SQL :: ORA-24247 With Valid ACL When Sending Smtp Mail?

Aug 1, 2012

I have users with the same privileges to the same ACL and some can send emails and some others cannot !

In principle I created the ACL for USER1:

BEGIN
dbms_network_acl_admin.create_acl
(acl=> 'mails_senden.xml',
description=> 'Mails senden ueber INTRANET Mail-Server ...',
principal=> 'USER1',
is_grant=> true,
privilege=> 'connect');
COMMIT;

[code]....

Then I added USER2:

BEGIN
dbms_network_acl_admin.add_privilege
(acl=> 'mails_senden.xml',
principal=> 'USER2',
is_grant=> true,
privilege=> 'connect');

[code]....

USER1 sent a mail via UTL_SMTP successful whereas USER2 got the errors:

DECLARE
*
ERROR at line 1:
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.UTL_TCP", line 17
ORA-06512: at "SYS.UTL_TCP", line 267

[code]....

There is still the following fact:

USER1 has the role DBA, USER2 got the EXECUTE privilege to packages UTL_TCP, UTL_SMTP (GRANT from SYS).

IF the role DBA was granted to USER2 too then he couldt send emails just as well as USER1.

View 7 Replies View Related

Server Administration :: Dropped User In Query Result?

Jul 17, 2005

I had droped one user from my oracle database..but when i run this below query i found that user exist

SQL>select username from dba_users;

but when i try to connect that user i get result

SQL> connect sunil/sunil
ERROR:
ORA-01017: invalid username/password; logon denied

Now tell me how to remove this user from result of this query

SQL>select username from dba_users;

View 11 Replies View Related

Backup & Recovery :: Restore Schema And Its Associated Objects Once Dropped?

Sep 11, 2011

Is there a way to restore the schema and its associated objects once it is dropped?

1. The flash back database feature is not ON in the database where schema was dropped.

2. The data files/ table space has not been dropped

3. There was no export taken for the schema.

View 4 Replies View Related

SQL & PL/SQL :: FDPSTP Failed Due To ORA-29277 / Invalid SMTP Operation

Apr 18, 2011

in the following program i am submitting a request and sending concurrent program log file (.REQ file)as an attachment but getting following error

ORACLE error 29277 in FDPSTP
Cause: FDPSTP failed due to ORA-29277: invalid SMTP operation
ORA-06512: at "SYS.UTL_SMTP", line 44
ORA-06512: at "SYS.UTL_SMTP", line 150
ORA-06512: at "SYS.UTL_SMTP", line 383
ORA-06512: at "SYS.UTL_SMTP", line 399

[code]....

View 3 Replies View Related

SQL & PL/SQL :: Procedure For Sending Mail With Excel / Pdf Attachment Using Smtp?

Nov 24, 2010

send script to send mail with excel attachment using smtp from Oracle 9i

View 1 Replies View Related

Automatic Storage Management :: Disk Dropped After The Time Has Passed?

Mar 16, 2013

After a power failure, I have now dropped disks in my 2 diskgroups DG_RACDATA1 and OCRVD.

Disks has been renamed and prefixed by DROPPED...

Their state is now "FORCING"
Mount status = missing
header status = unknown
Mode status = Offline

These disks was belonging to a failure group with redundancy so the cluster still works ...but I have lost the redundancy.

How to reuse these offline disk or confirm that what I plan to do is good:

Shall I put them online ? ALTER DISKGROUP DG_RACDATA1 ONLINE DISK DROPPED0000_DG_RACDATA1

Shall I drop them ? ALTER DISKGROUP DG_RACDATA1 DROP DISK DROPPED0000_DG_RACDATA1 FORCE

and then: zeroing them and readd to failgroup ? but how ?

View 4 Replies View Related

Backup & Recovery :: Recover A Dropped Table From Database As Well As Recyclebin?

Sep 23, 2011

can we recover a dropped table from database as well as recyclebin.

View 13 Replies View Related

Backup & Recovery :: Restore Dropped Or Wrongly Updated Table Using RMAN Backup?

Feb 9, 2011

Is it possible to restore dropped table OR wrongly updated table using RMAN backup.

View 18 Replies View Related

Error - ORA-06521 - PL/SQL Error Mapping Function

Nov 15, 2010

Oracle version - 10.1.0.4 OS - HP-UX

In my alert log I am getting the following error quite repeatedly; My application hangs, and have to restart the instance.

CODEORA-00604: error occurred at recursive SQL level 1
ORA-06521: PL/SQL: Error mapping function
ORA-06512: at "SYS.OLAPIHISTORYRETENTION", line 1
ORA-06512: at line 6

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved