Oracle 9i [ SQL username/password?? ]?

Question

After installing oracle 9i, what are the steps to be followed to start working with sql plus. How to create a database? scott/tiger doesn't seems to work as username/password for sql plus. please help/guide.

Answer 1

The installation should have created a sample database for you. If so you need to start the database bu running SQL*Plus and then entering the command "connect / as sysdba" (without the quotes). Once your connected you can start the database by issuing the command "startup" (again without the quotes). Once the databases has started (it will tell you) you can reconnect as the user scott by issiuing the command "connect scott/tiger" in SQL*Plus (again without the quotes).



Oracle 9i is very old in technology terms so you might want to use Oracle 10g or 11g instead. Both are available for Windows (and othe rplatforms) although 11g requires a great deal of resources under Windows. There is a small footprint version of Oracle 10g called the Express Edition which has no licensing restrictions and is ideal for installing on a personal computer or laptop. This can be downloaded from the Oracle Technology Network http://www.oracle.com/technetwork/database/express-edition/overview/index.html .



Oracle 11g can also be downloaded from the Oracle Technology Network http://www.oracle.com/technetwork/index.html for Windows, Linux and other platforms. One way to experiment with this version and with Linux is to install Linux in a vritual environment on your pc which you create using VirtualBox (acquired by Oracle when they bought Sun). For instructions on downloading and installing VirtualBox and creating a virtual Linux environmnet in which you can install Oracle 11g (or any othe rversion of Oracle for Linux) see

http://www.smart-soft-nz.com/oracle-11g-linux-installation.html

Answer 2

I am a bit rusty on Oracle but this may help The user name is a user that has the desired access to the tablespace "system" is the usual default for teh Oracle equivalent of the root user the password is whatever you set for the system account password when you did the install. "manager" is the default I believe the host string is the Oracle instance name you gave the installation during the install

Answer 3

try link give below for your answers.