bash_profile

[Tim...]

Hi.

It looks like you have empty lines in your script. This is a problem. Remove them and it may well work.

Cheers

Tim...

[syedhafeez69]

no sir i just want to see what's the error at the second line which i posted in previous posts... After i am typing the whole scripts in the method its giving the error in the line 2.. I want you to look at that

[Tim...]

Hi.

The point is if you have empty lines in the file that is a syntax mistake. The text you posted has an extra newline before the data files clause. That is a mistake. You posted this,

Code: Select all

create database demo

datafile '/demo/system.dbf' size 300m
sysaux datafile '/demo/sysaux.dbf' size 300m
default tablespace userdata datafile '/demo/userdata.dbf' size 200m
default temporary tablespace tempdemo tempfile '/demo/tempdemo.dbf' size 200m
undo tablespace undodemo datafile '/demo/undodemo.dbf' size 200m

logfile

group 1 '/demo/redo1.log' size 10m,
group 2 '/demo/redo2.log' size 10m
/

Line 2, 8 and 10 are blank lines. They should not be!

Cheers

Tim...

[syedhafeez69]

as soon as i am typing the first line i.e. create database demo and the i am typing the next line as
{datafile '/home/oracle/app/oracle/oradata/test/system.dbf' size 300m;} I am not giving any space after that first line... The procedure i posted is document of step by step procedure.. I am not giving any gap between any lines... I typed the whole procedure in the editor and after executing all the steps in SQL its giving the error in the first line.. After that when I am getting errror while typing in the editor I tried typing in the SQL, soon after typing the second line
{datafile '/home/oracle/app/oracle/oradata/test/system.dbf' size 300m;} the error is

[create database test
*
ERROR at line 1:
ORA-30045: No undo tablespace name specified ].. Please tell the step by step procedure to rectify the error.... Please remember i am not at all using any spaces...

[Tim...]

Hi.

The first thing I would do it put your command into a script and run that rather than typing. it's much more efficient. You can run a script in sqlplus using:

SQL> @/path/to/script.sql

Where "/path/to" is the real path substituted and script.sql is the name of your script.

The second thing I would do is generate the create database scripts using the DBCA, then compare your script to the generated script. That should give you an idea of where your script is wrong.

As I've said before, it is many years since Oracle recommended manually building databases rather than using the DBCA to generate them. You should probably ask your lecturer why he/she is asking you to do something that is not considered good practice.

Also, please stop putting "Please tell the step by step procedure to rectify the error". It's a sure fire way to piss anyone off on a forum. When people are helping you for free you can't demand any level of service. The manuals are available for free ans provide step by step instructions. If that is what you want I suggest you read them.

http://docs.oracle.com/cd/E11882_01/ser ... m#BABEIAID

Cheers

Tim...

[syedhafeez69]

Ok I am extremely sorry Sir.. I didn't have any intensions to demand you..I was just requesting you for that. I dont know about that. Infact you are the person helped me a lott and I am very thankful to you for that..

In realtime what method we use for creating Database ?

[Tim...]

Hi.

As mentioned previously, I *always* use the DBCA to create a database. One of the reasons for that is the templates allow you to do a very quick installation.

If I want to do a non-template installation and save the creation scripts I do a custom installation using the DBCA, but at the end check the checkbox asking if you want to create the scripts.

Cheers

Tim...

[syedhafeez69]

Hi Sir, How to install 10g when i already have 11g.. I want to do this for patching and upgradation.. Thanks...

[Tim...]

Hi.

If this is Windows I would suggest you should always install the software starting with the oldest version and moving forwards. That kinda suggests it is not a good idea to install 10g after 11g.

If it is UNIX/Linux, then this installation should be fine. Just make sure you install it into another ORACLE_HOME.

Cheers

Tim...