Home » RDBMS Server » Server Administration » Manual DB Creation in UNIX (Unix - oracle 10.2.0.1.0)
Manual DB Creation in UNIX [message #493343] Mon, 07 February 2011 06:45 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

please any one answer me for the below questions.

I am trying to create a DB manually.

1) How to create a unix services as we use oradim in windows.
2) While trying to use DBCA command it shows the below message.

SET DISPLAY ENVIRONMENT THEN RE-RUN.

My login is already in admin group only.

Regards:
Muktha
Re: Manual DB Creation in UNIX [message #493345 is a reply to message #493343] Mon, 07 February 2011 06:49 Go to previous messageGo to next message
knight
Messages: 111
Registered: January 2009
Senior Member
oradim not required in unix
post
echo $DISPLAY


Re: Manual DB Creation in UNIX [message #493346 is a reply to message #493343] Mon, 07 February 2011 06:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) It does not exist in Unix
2) So set it up.

Maybe read the install documentation for your platform could help.

Regards
Michel
Re: Manual DB Creation in UNIX [message #493347 is a reply to message #493346] Mon, 07 February 2011 06:53 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel, Knight,

Thanks
Re: Manual DB Creation in UNIX [message #493433 is a reply to message #493347] Mon, 07 February 2011 22:10 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

If we are not setting up the Environment variable in unix like we do in windows,
How it does perform with out setting it?

Regards:
muktha
Re: Manual DB Creation in UNIX [message #493434 is a reply to message #493433] Mon, 07 February 2011 22:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>How it does perform with out setting it?
ERROR results
Re: Manual DB Creation in UNIX [message #493438 is a reply to message #493433] Mon, 07 February 2011 23:25 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

URGENT -- I am facing the below problem, while create a DB manaully in UNIX.

Steps:

1) I created pfile and placed inside the directory --> "oracle_home/dbs/initpragati.ora" and "/.../pfile/initpragati.ora".

2) Sqlplus /nolog
3) Conn sys/change_on_install as sysdba
4) shutdown immediate
5) startup nomount pfile='path'
6) copying and past the DB creation files from notepad to the unix platform, it shows the below error.

ORA-01034: ORACLE NOT AVAILABLE

Regards:
Muktha
Re: Manual DB Creation in UNIX [message #493450 is a reply to message #493438] Tue, 08 February 2011 01:24 Go to previous message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do NOT explain, SHOW.
Copy and paste your SQL*Plus session.
Before, Please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel
Previous Topic: Updating table through concurrent sessions
Next Topic: Oracle 11g patch installation
Goto Forum:
  


Current Time: Tue May 07 23:43:02 CDT 2024