Try this:
COTT3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = COTT3)
)
)
If that doesn't work, replace "SERVICE_NAME" with "SID".
Put this in $ORACLE_HOME/network/admin/listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = COTT3)
(ORACLE_HOME = /opt/oracle/oracle/product/10.2.0/db_1 )
)
)
Then restart the listener with:
lsnrctl reload
Are you 100% sure that the database has started up?
Does:
ps auxww | grep pmon | grep -i cott3
... produce any output?
Oracle provides several sample schema, but as with Rolando's answer, you would have to convert these for the other databases.
My answer in a nutshell is Don't use identical scripts.
The problem with using scripts that are as similar as possible for each database is that you will be using least common denominator functionality. Using a database requires an investment in infrastructure, installation, support and development that will not reach it's full potential if the advantages of each platform are not utilized.
To truly do a comparison of these platforms, I suggest you determine what your requirements are and then implement those requirements in the best way possible for each database. This will of course require significantly more knowledge of the platforms, but any other comparison would only be academic.
Here are two examples.
Requirement: Show all days in a given date range with sales data for the day regardless of whether any sales were made that day or not.
Solutions: In Oracle you might do a cross join with a hierarchical query on dual returning all the days in the range. In SQL-Server you might use a CTE to generate the days. In MySQL you might use something else entirely.1
Requirement: Be able to run a query at any time to retrieve the data for any table as it existed at any point in time within the last four hours.
Solution: In Oracle you would only need to ensure that the undo retention was guaranteed and set to at least four hours. In other databases the implementation would be dramatically different.2
Best Answer
The example schemas are now on Github.
https://github.com/oracle/db-sample-schemas