SMTP Error. Getting below error while trying to send email in XXXXXXX instance

Getting below error in EBS R12.1.3 in Oracle Database 

SMTP Error. Getting below error while trying to send email in XXXXXXX instance

Oracle Error in Send Mail prog--ORA-29277: invalid SMTP operation

ORA-06512: at "SYS.UTL_SMTP", line 82

ORA-06512: at "SYS.UTL_SMTP", line 540

ORA-06512: at "SYS.UTL_SMTP", line 525

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

It can be below different issues.

1. You don't have enough privileges.

2. SMTP server not given properly.

3. Check WF config to validate SMTP server.

4. Firewall ports are opened for the SMTP mail. Use command prompt to send email.

Oracle DBA Startup guide Post 3

Oracle Database 10g is an Relational Database or RDBMS. There are two part of this RDBMS and they are Physical Database and Oracle Instance. Physical files, redo log files and control file are comutatively called as physical database. Oracle instance consists of a big memory area and some background process. It provide a way to the users to do an activity on the data. i.e. to retrive, add, modify or delete.

Data files - Physically stores the data
Redo log file - It contains the changes made to data. It is required for recovery.
Control files - It contains tipical information about database

1. Datafile location
2. Synchronization Information
3. Backup and recovery information

Supporting files i.e. parameter file, password file, alert log are important to database but is not a part of the database.

Naming convention of the database objects

1. Max 30 characters are supported
2. It have to start with a latter
3. Can include latter, number and underscore
4. Should not user reserved words

Removing Your Oracle Database

Removing Your Oracle Database
The task of removing an Oracle database differs based on what OS you are running on. For example, if you are running on UNIX, generally you must remove the related database files (database data files, online redo logs, and control files), files in the admin directories related to the database (database parameter files, trace files, etc.), and entries in ancillary database files such as the oratab, tnsnames.ora, and listener.ora files. If you are running on Windows, you need to make the same changes required on UNIX systems, but you also need to remove the database services for the database that you are removing. This will prevent errors from occurring when you start your Oracle database.

You can also use the DBCA to remove a database. The DBCA can be used to drop a database that you created with the DBCA or one that you manually created.

Oracle Database 10g offers a new command, drop database, that takes care of dropping your database for you. You still need to perform ancillary tasks, such as removing the database service and changing database files such as oratab, tnsnames.ora, and listener.ora.

Removing an Oracle database is quite different than removing the Oracle database software. If removing the software is your quest, you should first remove all Oracle databases on your system, and then use the Oracle Universal Installer to remove the Oracle RDBMS software. To completely remove the Oracle RDBMS software, you will probably have to manually remove files from the old ORACLE_HOME, as the installer is not always perfect in its removal process.