Cannot Establish Ftp Connection To Xmldb-filesystem?
Aug 29, 2012
how can I connect via ftp to the xmldb-filesystem ?
I tried the instructions from this website [URL] ..... Now I can connect to the filesystem via "win7 shell ftp", but i cannot connect via "win7 explorer" using "ftp://host:port/foo/bar" or filezilla. Everytime i try i got an errormsg like:
filezilla: cannot read filesystem
and
win7
an error appears :
detail:
200 Type set to A.
277 Entering Passive Mode.... see sreenshot -> [URL]
I have an application in VB6 that connects to an Oracle Database 10g with Oracle native ole db but win7 can not make the connection with a standard user, only makes the connection to a user with administrator permissions. The error that shows the application's rubbish eg @, H, etc.. only rare characters.
I have installed oracle 11g in my personal laptop, when i open the sql developer and try creating the new connection. am getting "The network adapter could not establish the connection".
I am trying to create a secure connection and getting the following error. I have tested the password via sqlplus and it works just fine.
oracle[/u01/app/oracle] emctl config emkey -repos -sysman_pwd TZ set to US/Eastern Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0 Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
enter repository password..Invalid Password caught Exception java.sql.SQLException: Io exception: The Network Adapter could not establish the connection
I was able to connect to the above server from my machine.But when i was trying to connect the above server from my neighbours system i am getting an error Network adapter could not establish the connection.
Note:when i ping the ip address 10.10.50.50 from my negihbours system in the command prompt
Reply from 10.10.50.50:bytes=32 Reply from 10.10.50.50:bytes=32 Reply from 10.10.50.50:bytes=32 Reply from 10.10.50.50:bytes=32
In the recent past we have been observing the DB connection from application to database using ODBC is taking long time. When I fire LSNRCTL SERVICE command, for our instance the ESTABLISHED = count is being shown a huge number like 45000 and even more some times.
When we restart the instance suing shutdown immediate or abort commands. The established connections count is becoming 0 and again getting increased slowly. Once the count is reduced the connections are getting established quickly without any issue.
I am attempting to read from the maillog of our server, but I wish to make as few changes as possible for fear of blocking other systems access to the file.
I was initially going to call create directory maillogs as '/var/log/maillog' and then drop directory maillogs; when I was done but I found my user does not have "create any directory" permissions.
Rather than compromise security of the existing database configuration, I thought I would permanently add the maillogs to the list of available data directories. Are there any implications to the filesystem if I do this, or should I be able to add this without consideration of affects.
Understand that I will only be opening the file for (R) READ TEXT access only.
Primarily I am concerned that Oracle (in the background) will keep a file pointer open or something of that nature that would block other programs from writing to the file even after I close the file pointer. I want to make as little impact as possible to the file system.
I am configuring RAC with two nodes. I have mapped iscsi targets successfully. I am unable to mount the ocfs2 filesystem.
mount -t ocfs2 -o datavolume,nointr -L "oracrsfiles" /u02
When execute the above command, it displays the follwing error:
ocfs2_hb_ctl: Device name specified was not found while reading uuid mount.ocfs2: Error when attempting to run /sbin/ocfs2_hb_ctl: "Operation not permitted"
I have got backup pieces in ASM, I guess about more than 100 files. Now, I need to copy all of them from ASM to FileSystem, there are 2 methods still now:
1- Copy from ASM to FileSystem using cp command. 2- Copy from ASM to FileSystem using DBMS_FILE_TRANSFER.
But:
In the first method, when I copy one file, I took more than 1 minute, so the following script would take me more than 1 days (I guess so).
#!/bin/ksh # # This script copies files from FRA on ASM to local disk # ORACLE_SID=+ASM2 ASMLS=/vasgatedb/app/vsgbkp/asm_ls.txt ##{ASM files list}
[Code]...
The second method, DBMS_FILE_TRANSFER took me less than 1 second to copy one file completely.
sys@VSGDB> set timing on sys@VSGDB> exec dbms_file_transfer.COPY_FILE('asm_dir','level_0_vsgdb_9998_813844797.bkp','fs_dir','level_0_vsgdb_9998_813844797.bkp');
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.38
Of course, I wish I used the second method as soon as possible, however, said I below, I've got about ~200 files, and I could not copy one by one file.
I am using Oracle 11.2.0.3 RAC (2 nodes) + ASM on AIX 7.1
I am backing up my Oracle database through RMAN to ASM disk groups..I have a requirement to backup also to an OS file systems. So what I did that I mounted an NFS across the 2 nodes of my RAC database.I am running backup from node 2 only.My issue now is that I am facing a real performance issue when backing up to NFS.My question is there any way to take an RMAN backup to local file system on node 2? or in other way what are the options to take RMAN backups to an OS file system?
I tried to copy from ASM to OS file system but i was advised to backup to file system using the format command.what should i do in such case? since I am facing performance issue to backup to NFS.
I have a requirement where I have to generate monthly filesystem usage report(graphical) in an automated fashion,I checked the built in reports from the grid control 10g but not able to find any thing....
What is correct way to move the default oracle spfile to ASM diskgroup so i can successfully bring up the instance . After bring up the instance , it should point to ASM diskgroup. My oracle database 11.2.0.3 is siting on sun solaris 64 Bit.
There is a question come up in my mind that can we perform the copy/delete/move of ASM files to the host filesystem while the ASM instance is down. For instance... To copy the file ASM file through AMCMD utility when the ASM instance is running.
I am currently in the favorable situation in which I have excess amounts of memory available on the database server - a single node setup. The server only serves the single instance and no other processing. Database size is around 2.3tb and memory is 50gb. For the majority of processing, AIX is allocating a significant amount (anywhere from 30-40%) of the memory to the AIX file system cache (persistent pages).
I've been trying to find documentation about this, but have not had any luck yet. My guess is that it would be better to allow Oracle to cache this data - meaning increase the SGA target and max size to allow for a larger buffer cache. However, the nice thing about the AIX cache is if process memory is needed, the file system cache gives up pages. If the memory was allocated to the SGA, its pretty much locked in.
I have read several articles stating that a larger buffer cache is not always better, as a larger cache takes more management. But having both of the caches active seem to be a waste of memory, effectively storing the data twice - once in AIX persistent pages and a second time in Oracle database buffer cache.
I am attempting to install Oracle 10g R2 on Oracle Enterprise Linux 5 update 5 but facing some errors. Can't believe i have done everything right as far as oracle docs n my understanding concern. when i try to invoke runInstaller for CRS it fails with following error: ------------------------------ [oracle@server01 clusterware]$ ./runInstaller Starting Oracle Universal Installer...
Checking installer requirements...
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2 Passed
All installer requirements met.
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2010-11-15_04-36-47PM. Please wait ...[../stage/Components/oracle.swd.oui.core/10.2.0.1.0/1/DataFiles/filegroup1.jar] End-of-central-directory signature not found. Either this file is not a zipfile, or it constitutes one disk of a multi-part archive. In the latter case the central directory and zipfile comment will be found on the last disk(s) of this archive. note: ../stage/Components/oracle.swd.oui.core/10.2.0.1.0/1/DataFiles/filegroup1.jar may be a plain executable, not an archive
Error in writing to directory /tmp/OraInstall2010-11-15_04-36-47PM. Please ensure that this directory is writable and has atleast 60 MB of disk space. Installation cannot continue. : Success [oracle@serverr01 clusterware]$ --------------------------------------------------
I am also attaching the cluster verfication result, if you wish to have a look at this.
I have some problem connecting with the database. I have downloaded jdeveloper and oracle 10g express edition. I was trying to connect to the 10g express edition from j developer but i am unable to.
I right clicked on the application and then new in that. In that i choose database tier. there i gave my user id and password and changed the side to XE. and when i click on test connection it says IO exception: the network adapter could not establish the connection. I can even log in with the same user name and password in to the database home. I don't know whats the problem.
Currently weblogic has 120 concurrent connections to the database.There is a requirement to scale up the number ofconcurrent connections to 300.We have did some study and quite be quite sure that the current sga and pga is required. (the additional connections will be firing the same sql which is very well tuned.
However each additional connection to the database will take up additional memory just for the connection?Will is be using the memory in the PGA? Or outside the PGA for the connection overhead?We are not using MTS.
i am trying to insert records (with varchar2 fields) into mysql database from oracle through heterogeneous connection..but after insert, and when i query the inserted data which inserted in arabic, it appears as question marks '?????????'
the character set of oracle database is AR8MSWIN1256...and the character set of mysql database is UTF8...
is there any configuration to the heterogeneous connection that configure the character set ?
We have two database instances on the same server. One was left at 9.2.0.7 and one was upgraded to 10.2.0.3. Connecting externally (sqlplus '/as sysdba') to the 9.2.0.7 database is lightning fast. Connecting externally to the 10.2.0.3 database is very slow, comparatively speakiing. This is on an IBM AIX-5L (64-bit) machine. We are using "tnsnames".
I am using UTL_TCP package of Oracle to connect to remote server. As per my architecture, I am opening multiple connections TCP in the same Oracle session.
I have come arround the limiation of 16 connections with this package.
Our Oracle Application & Database 10.2.0.4 is installed on Windows 2003 R2 32 bit and our development team trying to access this database from windows 2008 64 bit.where we have the Oracle client 10g installed for 64bit but when they are trying to access the instance they are getting below error
[#|2010-03-17T19:00:26.689+0530|SEVERE|glassfishv3.0|tcplistener.ModuleHandler|_ThreadID=30;_ThreadName=Thread-1;|The log message is null. java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:168) at java.net.SocketInputStream.read(SocketInputStream.java:182) at java.io.FilterInputStream.read(FilterInputStream.java:66) at tcplistener.ByteWrapper.unwrapFromStream(ByteWrapper.java:136) at tcplistener.ModuleHandler.run(ModuleHandler.java:106) at java.lang.Thread.run(Thread.java:619) |#]
I have an issue with an Oracle 9 database where I can connect if I do not specify a database to connect to but when i do specify one i get an error. For example, my database is called WEB. If i open sqlplus and type connect username/password it will connect fine. If I type connect username/ password @web I get an error.The full error that appears in the log is:
TNS-12500: TNS:listener failed to start a dedicated server process TNS-12546: TNS:permission denied TNS-12560: TNS:protocol adapter error TNS-00516: Permission denied 32-bit Windows Error: 5: Input/output error
I have checked the tns entries and listener file and both are fine. Here are the entries: TNSNAMES:
I working on data transferring from one database server to another database server. but at starting i want to check weather remote database is connected or not?
for e.g.
a := get_remote_connection; --- Calling function for check remote connection return boolean if a then <call my data_transfer_proc> else exit; end if; reply.
