Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

So i've installed 11g Standard on a VM, it's going to be connected to from other Computers/Users. Im not really used to Oracle setup/etc.. so bear with me. Anyways it installs successfully and everything but im not really sure how to create my first database on it (Using SQL Developer).

Im trying to connect with SQL developer, but im not really sure of the parameters? Should I be able to connect at this stage? what do I enter for Username/Password etc...?

I've seen guides but they are for Express Edition. This is on a Windows 8 64 Bit VM Btw.

Thank you

share|improve this question

1 Answer 1

up vote 3 down vote accepted

Ok, you have the database software installed. Here is the 11.2 Installation Quick Guide for Windows Here is the 11.2 documentation home. Now you need to install a database instance and start a listener. Then you need to create a connection in SQL Developer to the database instance.

Some essential tools during this are SQLPlus on the server. Enterprise Manager Database Control http://host.domain:1158/em/ You will need to Remote Desktop into the server to perform database setup tasks as the SYS user. On the server DOS window:

sqlplus /nolog
SQL>connect sys@myinstance AS SYSDBA
enter your password.

If you did not create a database instance during the install, use Database Configuration Assistant (DBCA). A universal approach for client connectivity is to use a tnsnames.ora file located in $ORACLE_HOME/network/admin. The parameters for this become the connection parameters in SQL Developer.

In a DOS window on the server, run the listener control with

lsnrctl help
lsnrctl status   tells you which instances are running. 

Once you have the instance created, create a new tablespace to hold your tables. Then create a user that will be the schema owner of the tables associated with that tablespace. It is a good practice to create a separate user for each person in addition to the schema owner. Then create tables, views, stored procedures, etc.

Hope this is enough to get you started. The links are good reads.

share|improve this answer
    
Thank you! this is the information I needed. –  Mercfh Jul 21 '13 at 22:44

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.