Re: newbie: startup and import question

On Fri, 25 Mar 2005 17:08:37 -0800, Bill wrote:

> Hi,
>
> I am so new to oracle. I have no prior knowledge
> of this big thing that you guys deal with. Looking for some
> info to get started on linux:
>
> My questions:
> 1. Is there a cheatsheet that might mention the steps
> required to startup the oracle server.
>

Since you are using Linux, hopefully you will get started on Oracle 10g.

1. If you want to go to a free Linux, use WhiteBoxLinux, TaoLinux, CentOS which are pure clones of Red Hat EL 3. Or download the eval copy of SuSE Linux Enterprise (SLES9).

Stick with a certified linux, or pure derivative, and your life will be easier BECUASE there are resources to help. Fedoras, Debian, etc. will work, but you will be looking for help a lot as, wrt Oracle, they are fringe , not supported, and not well documented. (IOW - YOYO)

2) Go to http://www.puschitz.com to learn how to preconfigure one of the above Linux' for Oracle

3) Go to Oracle's Technet at http://otn.oracle.com, for

1. tutorial, called Oracle By Example [OBE] as listed in the menu currently on the left side. The reason I suggest 10g is the OBE for 10g is on Linux, whereas for 9i it's Windows
2. documentation (also tahiti.oracle.com or docs.oracle.com) also listed in the menus. For 10g, Oracle has set a group of books as an intro for new DBAs. Otherwise, start with the Concepts manual.
3. I encourage you to get a copy of 'Oracle Essentials", published by O'Reilly (see http://oracle.oreilly.com). It gives a decent overview of Oracle terminlogy and Oracle operations. Once you have read it, give it to your boss (it is readable by moderately intelligent managers) and you _might_ get some sympathy for the learning curve they've thrown at you.

> 2. I need to import a *.dmp file to my database. Do I need
> to first start the database server and then use the "imp"
> command?
>
> Bill

Yes - Oracle needs to be started. The OBE will help. Then you'll understand the following sequence - done by the Oracle DB owner, not root:

1. Start the listener

        lsnrctl start

2) Start the database's instance

	sqlplus "/ as sysdba"
	startup
	exit

3) Start the import

        imp scott/tiger_at_mydb file=xyz.dmp {+ more options}

The import (and export) are considered UTILITIES and are fully documented in the Utilitiies manual found in the docco identified above. There are samples and examples in the docco.

And - when asking for specific help, tell us which Linux and which Oracle version, as well as what you've tried, and WHY you are trying something. There are dozens of ways to do many things in Oracle, and we may be able to give non-intuitive (but possibly superior) solutions.

G'Luk
/Hans Received on Fri Mar 25 2005 - 20:17:06 CST