Re: Oracle 10g required services

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Thu, 26 Aug 2004 03:38:51 GMT
Message-ID: <fXcXc.55775$X12.9939@edtnps84>

jlopes wrote:

> So my question is has anyone else solved this problem? Is this Oracles
> way to get new users to buy support?
>

Not usually. Vendor-based automated resource startup and boot time is potentially a bad idea and I'd think you really do want control over that. Oracle supplies a 'dbstart' and 'dbshut' script that _might_ work if you are using the right config.

Better to learn it right, so you really want to look at the available resources ....

1. http://docs.oracle.com links to ALL of Oracle documentation (pick your version then open the View Library link to get access)
   • start with the 10g Concepts manual. Slog through that
   • browse through the DB Administration Guide and the Application Developer Fundementals
   • then bookmark the TOC for the SQL [Language] Reference and the SQL*Plus Reference
2. do some of the online 'Oracle by Example tutorials' provided by Oracle at http://otn.oracle.com/obe
3. browse other places at Oracle's Technet http://otn.oracle.com
4. look at the sample code on technet

Oracle is not a particularily easy system to understand from the ground up. Well worth learning, though (IMO).

Couple of pointers:

1. Connection between [oracle] client s/w and database is done using some sort of 'Oracle Networking'. Client talks to a Listener (not unlike inetd), so Oracle Listener must be up and running. (command is 'lsnrctl', eg: 'lsnrctl start')
2. Once listener is up, it wants to hand off DB requests to a DB _Instance_ which needs to have been started using something like

        sqlplus / as sysdba
           startup
           exit

3) Client then can talk to the specific database instance by requesting (from the listener) a connection for a user session. Oracle supplies a few client apps, the most common being the 'command line interpreter' called sql*plus.

        sqlplus scott/tiger_at_mydatabase
                ^       ^       ^
                |       |       +-- oracle net connection - see tnsnames.ora file
                |       +-- password (will be prompted if omitted)
                +----- name of user that has been created and is active

typical users:

- system (frequent pw=manager) is the default administrator
- scott (tiger)is the original demo account
- hr, oe, sh and others are demo accounts (Human Resources, Order Entry,

Shipping Handling)

most need to be activated using admin commands using the following sequence

        sqlplus system/manager_at_mydatabase
          alter user scott identified by tiger account unlock;
          rem "identified by" sets new password
          rem "account unlock" makes it available fr use

4) After you are used to sqlplus, you can create your own client apps using java (jdbc), 'stuff' (odbc), C (oci and proC), etc.

Hope the above is enough to kick-start you. Happy reading /Hans Received on Wed Aug 25 2004 - 22:38:51 CDT