Prev: xpdp via network_link fails when specifying parallel
Next: Need example for 11g's new response file db_install.rsp
From: Robert Weiss on 4 Aug 2010 02:17 >> > I start doing some oracle admin work.. I also need ftp the files from >> > my desktop to Unix server from time to time.. is there any good tools >> > which could do both SSH and FTP ? > I tried winscp before , not sure if that is the same scp you > mentioned, it seems need to input userid and PW again.. I'm looking > for some tools which just need login once and could do FTP and SSH > without going through login process again... use pagent for loading your ssh keys and write the public keys into the authorized_keys file on the server
From: Mark D Powell on 4 Aug 2010 08:32 On Aug 3, 9:41 am, riverdance <esthershe...(a)yahoo.com> wrote: > Hi, > I still new in oracle world. > I had a basic question..about what kind of tools DBA used to access > oracle server to do their daily job. > > I start doing some oracle admin work.. I also need ftp the files from > my desktop to Unix server from time to time.. is there any good tools > which could do both SSH and FTP ? > > I used to use secure SSH, but it seems not good in oracle. every time, > from oracle sqlplus session, if I mistype something, it cannot be > corrected by backspace, the only way is retype the whole command from > begining.. > > so I had to switch to putty, since putty don't have this problem. but > it don't have FTP function, I had to use secure SSH to do the FTP , it > mean another login process.. > > I don't know what kind of tools oracle DBA use to do their daily admin > work? if the tool had xwindows function, that would be great. since > it looks like some oracle software, must install under GUI , there is > no command option . > > your suggestion is really appreciated. "what kind of tools oracle DBA use to do their daily admin work?" I use sqlplus for most all my Daily Administration work. I use my own scripts for querying and monitoring the database(s). Oracle Enterprise Manager tool is OK if you buy the additional cost Performance and Diagnostic Packs otherwise I feel you are better off to stick to using sqlplus or maybe Oracle's free SQL Developer tool. IMHO -- Mark D Powell --
From: Carlos on 4 Aug 2010 08:50 On Aug 4, 2:32 pm, Mark D Powell <Mark.Powe...(a)hp.com> wrote: > On Aug 3, 9:41 am, riverdance <esthershe...(a)yahoo.com> wrote: > > > > > Hi, > > I still new in oracle world. > > I had a basic question..about what kind of tools DBA used to access > > oracle server to do their daily job. > > > I start doing some oracle admin work.. I also need ftp the files from > > my desktop to Unix server from time to time.. is there any good tools > > which could do both SSH and FTP ? > > > I used to use secure SSH, but it seems not good in oracle. every time, > > from oracle sqlplus session, if I mistype something, it cannot be > > corrected by backspace, the only way is retype the whole command from > > begining.. > > > so I had to switch to putty, since putty don't have this problem. but > > it don't have FTP function, I had to use secure SSH to do the FTP , it > > mean another login process.. > > > I don't know what kind of tools oracle DBA use to do their daily admin > > work? if the tool had xwindows function, that would be great. since > > it looks like some oracle software, must install under GUI , there is > > no command option . > > > your suggestion is really appreciated. > > "what kind of tools oracle DBA use to do their daily admin work?" > > I use sqlplus for most all my Daily Administration work. I use my own > scripts for querying and monitoring the database(s). > > Oracle Enterprise Manager tool is OK if you buy the additional cost > Performance and Diagnostic Packs otherwise I feel you are better off > to stick to using sqlplus or maybe Oracle's free SQL Developer tool. > > IMHO -- Mark D Powell -- "I use sqlplus for most all my Daily Administration work. I use my own scripts for querying and monitoring the database(s)." "I feel you are better off to stick to using sqlplus" +1 I'm definitely with Mark on this one. Cheers. Carlos.
From: gazzag on 4 Aug 2010 08:56 On 4 Aug, 13:50, Carlos <miotromailcar...(a)netscape.net> wrote: > > +1 > > I'm definitely with Mark on this one. > > Cheers. > > Carlos. I agree. Also, SQL Developer is included as a replacement to the Windows version of SQL*Plus with Oracle 11gR1 onwards. -g
From: Tim X on 5 Aug 2010 20:51 riverdance <esthershensh(a)yahoo.com> writes: > On Aug 3, 11:33 am, Rob Burton <burton....(a)gmail.com> wrote: >> On Aug 3, 2:41 pm, riverdance <esthershe...(a)yahoo.com> wrote: >> >> >> >> >> >> > Hi, >> > I still new in oracle world. >> > I had a basic question..about what kind of tools DBA used to access >> > oracle server to do their daily job. >> >> > I start doing some oracle admin work.. I also need ftp the files from >> > my desktop to Unix server from time to time.. is there any good tools >> > which could do both SSH and FTP ? >> >> > I used to use secure SSH, but it seems not good in oracle. every time, >> > from oracle sqlplus session, if I mistype something, it cannot be >> > corrected by backspace, the only way is retype the whole command from >> > begining.. >> >> > so I had to switch to putty, since putty don't have this problem. but >> > it don't have FTP function, I had to use secure SSH to do the FTP , it >> > mean another login process.. >> >> > I don't know what kind of tools oracle DBA use to do their daily admin >> > work? if the tool had xwindows function, that would be great. since >> > it looks like some oracle software, must install under GUI , there is >> > no command option . >> >> > your suggestion is really appreciated. >> >> scp can be used to transfer files, or pscp if you're using putty (a >> separate download , which also has psftp which I'd guess would do ftp >> too.)- Hide quoted text - >> >> - Show quoted text - > > Hi, Thanks. > > I tried winscp before , not sure if that is the same scp you > mentioned, it seems need to input userid and PW again.. I'm looking > for some tools which just need login once and could do FTP and SSH > without going through login process again... > > I would try to find pscp /psftp to see if that works.. > This is normally handled by an ssh-agent. Don't know what the state is under windows, but under Linux and probably Mac, you simply start up an ssh-agent as part of your session startup (the agent needs to run in the parent process of processes you wish to use it from). With the ssh-agent running, the first time you try to go to a remote host, using either ssh or scp, you are asked for you passphrase via a popup (or command line if not running under a GUI). From that point on, the ssh-agent handles the passphrase for you - you will not be prompted again for the passphrase when you next visit that host or use scp to copy files to that host. Other alternatives would be * use emacs with its built-in 'tramp' mode. Allows you to edit remote files and copy files from local to remote host and vice-versa. Steep learning curve if your not familiar with it. * Set up an NFS, SMB or similar share. If your on windows, setup samba on your server * Use something like dropbox There are many other possible solutions. A lot depends on exactly what you need to do and how often and what level of control/access you have to the remote server. I personally rarely need to copy files to the database. I run the Oracle instant client from my workstation and that pretty much provides all I need 90% of the time. The only time I need to copy files around is when I'm using external tables. Tim -- tcross (at) rapttech dot com dot au
First
|
Prev
|
Next
|
Last
Pages: 1 2 3 Prev: xpdp via network_link fails when specifying parallel Next: Need example for 11g's new response file db_install.rsp |