_Hi everybody _i wanna all steps to create instance, parameter file , password file and database _manually in oracle 10g _i hope from all to help me
closed as not a real question by Mark Storey-Smith, Nick Chammas, jcolebrand♦ Jan 17 '12 at 3:13
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. If this question can be reworded to fit the rules in the help center, please edit the question.
Oracle configuration is very complex and someone could easily write dozens of pages of documentation describing the things you are asking about. Try to find a tutorial or (better yet) an experienced DBA to help you get started.
Short of that, find a good book on Oracle database administration. One of the best DBA books I've read is Pro Oracle Database Administration by Darl Kuhn. Chapter 2 covers almost everything you are asking about.
Once do get started, come back here if you're still having trouble and post specific error messages. You'll have a much better chance of getting some useful assistance that way.