Home » RDBMS Server » Server Administration » DBCA on Putty (Oracle 10g, Suse Linux)
DBCA on Putty [message #342082] Thu, 21 August 2008 05:19 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I am accessing the unix bix through remote terminal by PUTTY.

I know that we can create the database with DBCA but i want to ask is that can we create database with DBCA commnad through PUTTY?

On Putty i tried this one.
oracle@linux:~> dbca
DISPLAY not set.
Set DISPLAY environment variable, then re-run.


Then i try to set the DISPLAY environment through

oracle@linux:~> DISPLAY=:0.0 ; export DISPLAY
oracle@linux:~> dbca


But the commnad doesnt show any activity. It just stops.

Please suggest.
Re: DBCA on Putty [message #342095 is a reply to message #342082] Thu, 21 August 2008 05:45 Go to previous messageGo to next message
alanm
Messages: 284
Registered: March 2005
Senior Member

hi,
when you open putty, there is an option on the left hadn side

called SSH

one option under this is X11 and then X11 forwarding, do you have this ticked?

also do you have a xclient on your laptop?

regards

Alan
Re: DBCA on Putty [message #342100 is a reply to message #342082] Thu, 21 August 2008 05:57 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Thanks alan for your reply.

Quote:
one option under this is X11 and then X11 forwarding, do you have this ticked?



I followed the way you said. Previously it was unchecked.

I do not have xclient. Please tell what is that?
Now i am accessing Putty on Windows XP.

Now itried with tick on X11 forwarding.
Then it gives me an error.

oracle@linux:~> dbca
X connection to localhost:10.0 broken (explicit kill or server shutdown).
oracle@linux:~>


How can i resolve this

Thanks,
Re: DBCA on Putty [message #342103 is a reply to message #342100] Thu, 21 August 2008 06:05 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You actual need an X SERVER on your machine.

Which makes is possible to start a GUI program remotely on the Unix machine, and then see the window locally on your box.

So you need a X Server like Exceed, Xming or Cygwin/X installed on your windows box.

Which usually requires at least some understanding on the network setup involved. If you don't have that talk to the network/system admin first.
Re: DBCA on Putty [message #342256 is a reply to message #342082] Thu, 21 August 2008 16:09 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
You can use dbca in silent mode if you want immediate solution.
Re: DBCA on Putty [message #342422 is a reply to message #342082] Fri, 22 August 2008 05:16 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
I just install Xming-6-9-0-31-setup.exe setup on my windows machine.
Now i can able to access the DBCA with Putty.

Steps:
1. Install Xming-6-9-0-31-setup.exe setup
2. Start putty with enable checkbox on X11 forwarding.
3. Start DBCA and it works perfectly.

Thanks to you all.
Re: DBCA on Putty [message #342424 is a reply to message #342422] Fri, 22 August 2008 05:25 Go to previous messageGo to next message
alanm
Messages: 284
Registered: March 2005
Senior Member

excellent news

Alan
Re: DBCA on Putty [message #407806 is a reply to message #342424] Thu, 11 June 2009 12:32 Go to previous messageGo to next message
irf4u88
Messages: 1
Registered: June 2009
Junior Member
hi alan
i tried these all steps.
but while executing dbca from putty it is giving me an error like........
Exception in Thread "main"
please sujjest me what to do....
thanx
Re: DBCA on Putty [message #407807 is a reply to message #407806] Thu, 11 June 2009 12:37 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello,

1/ Last updated thread date "Fri, 22 August 2008 15:55"; Why your replying very old thread.

2/ but while executing dbca from putty it is giving me an error like........

Quote:
You actual need an X SERVER on your machine.

Which makes is possible to start a GUI program remotely on the Unix machine, and then see the window locally on your box.

So you need a X Server like Exceed, Xming or Cygwin/X installed on your windows box.

Which usually requires at least some understanding on the network setup involved. If you don't have that talk to the network/system admin first.


Babu

Re: DBCA on Putty [message #407808 is a reply to message #342082] Thu, 11 June 2009 12:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.


Post Operating System (OS) name & version for DB server system.
Post Oracle version to 4 decimal place of database s/w.

does xlock work for you?
Re: DBCA on Putty [message #408042 is a reply to message #342082] Sat, 13 June 2009 04:36 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

You cann't connect to GUI from putty. Putty is only for CMI. You have some options to create database remotely

1. Install third-part utility to connect to GUI of that server
2. Use VNC on the server and connect to desktop of your server from Web
3. If you cann't do neither, then you can create the database manually
Re: DBCA on Putty [message #408146 is a reply to message #407806] Sun, 14 June 2009 17:19 Go to previous message
alanm
Messages: 284
Registered: March 2005
Senior Member

hi,
download and install xming onto your local pc.

http://sourceforge.net/projects/xming

then start xming before you start your putty session. to check if you x is working, try running the command 'xclock' is this appears then you will be able to run DBCA.

cheers

Alan
Previous Topic: Rc-50004 error when executing adcfgclone.pl
Next Topic: Resolving ORA-02050 error
Goto Forum:
  


Current Time: Sun Dec 01 17:26:04 CST 2024