ORACLE overview
From YourSupportStoreWiki
Overview
"SID" is the databse name or service name
"Alias" is the Alias to the database name this is what you will connect to sqlplus user@alias
synonym is an alternate name for a table.
So you can have a table called my_data_is_foo_barred and create a synonym called foo_barred to get the date faster or make it easier for you to find.
Backend processes
Bequeath adapter is when the the db is on the same server.
TNS listener - Transparent network substrate listens to the network on a defined port in the tnslistener.ora so the server know what database is communicating over what port.
Tnsnames.ora - is on the client and points to where the listener is, including what port and IP to communicate to the listener on. you will also create your alias here and point the alias to the SID that exists on the Database server.
Mmon - performs manageability related background tasks.
Mman - talks to enterprise manager performs auto mem management tasks.
Pmon - registers clients with listener and monitors listener for idle session timouts.
Dbwriters (DBWR) are what writes to the database from the buffer. Can have 10 total 0-9 Logwriters (LGWR)
A Database is a series of waits.
so to design a good infrastructure for your database you have to ask yourself.
What is the database waiting on?
AWR ( Automatic Workload Repository)
Application waits
Data waits
io -- disk waits
Network waits
Processes / Threads
ERRORS
ORA - 12154 tnsnames entry doesn’t exist
ORA - 12203 tnslistener not available
here is a look up tool.
[link:http://www.dba-oracle.com/oracle_news/2004_11_10_easy_lookup_error_codes.htm]
Ports
/local/app/oracle/product/10.2.0/install/portlist.ini
Range is between 8000 through 12000 but varies
If shared server is used you can define a range of ports.
Works with checkpoint.
Use bin variables in program code.
