Tablespace Administration - 1

ORA-XXXX: unable to extend ...in tablexpace XYZ

The error will always have a tablespace name defined at the place of XYZ above.
The error code may be different as the issue may be with table, index, temp segment etc, but the reason and resolution are same.
Reason:- Running short of space
Resolution:- Add space

Database Link 11G

With 11G some new features and some releated changes came in picture.
Password is case sensitive in 11g, and so is needed for all the db links.

So for creating a db link b/w 10g to 11g, keep in mind to plece the password in double quotes.

Like:

Important File Paths for DB and APPS - 1

Some very basic file paths for oracle applications daily trouble shooting and user requirements are listed below. At some places this paths may vary according to environments, but the basic location will be similar.

 Context Files: 

• This is one of the most important files, to make the application work.

DB Links

DB Links or Database Links are used to connect mainly one database to another. It may be used to point to same database in some cases.
The information related to DB Link can be found from "DBA_DB_LINKS".

The syntax for db links is
SQL> Create [PUBLIC] database link "<Link_name>"
        connect to <remote_dbuser> identified by <remoteuser_pasword>
        using '<host>';