Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've installed oracle11g on OracleLinux5, in order to replicate a customers oracle configuration. I only have access via SSH and the web interface, and i need to setup the character set,and a few other parameters NLS, N-NLS. Of what i understand it seems i cannot alter the parameters of the current database, and i would need to install a new one and set the parameters at creation time. Is this true ? If yes, how could i do this via SSH ?

thank you!

share|improve this question

migrated from stackoverflow.com Jul 13 '11 at 3:35

This question came from our site for professional and enthusiast programmers.

1 Answer 1

You do not need to reinstall the software. You only need to create a new database if you got the information wrong the first time (and delete the old one probably).

You can create a new database using dbca. You can find more information here: http://download.oracle.com/docs/cd/E11882_01/server.112/e10897/install.htm#ADMQS0232

You can do this over ssh. If you are on windows, download Xming. You will need to install and download Xming and Xming fonts. The public domain version of these are enough.

share|improve this answer
1  
Just to add, after installing you could use something like putty to connect to the server with X11 Forwarding. This will allow you to run DBCA remotely though SSH –  katriel Jul 13 '11 at 5:10

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.