w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
can't start oracle service in linux
You can try this recovery mechanism, but it's not guaranteed. Back up your database (even in its broken state) BEFORE you try any recovery suggestions. You can torpedo all of your data if you fail to do this. You should always keep a regular backup of your production database -- ours runs every 12 hours. STARTUP MOUNT ALTER DATABASE BACKUP CONTROLFILE TO TRACE; STARTUP NOMOUNT RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL; enter CANCEL; ALTER DATABASE OPEN RESETLOGS; This may get your database back into a corrupt state, just allow it to process then fix any inconsistent data manually (will only be transactions that were running when it failed). Hope it helps.

Categories : Oracle

Trying to install oracle on Scientific Linux release 6.2
wget https://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle Run the above command. I just now did the same. [Edit] Or go to the link http://public-yum.oracle.com/ to scroll down to get the link compatible to your OS.

Categories : Linux

how to find oracle listener port in linux
From the command prompt you can use lsnrctl status, here is the relevant documentation. You can also use the Oracle Enterprise Manager web interface under General -> Listener.

Categories : Java

oracle temporary ora 12505 error after linux startup
I think I found the problem, looks like I am starting oracle-xe instance before I assign network interfaces an IP address, in that case it takes some time for oracle to receive connections, that requires me to set static ip on the linux boxes, which is something I don't want. Is there a solution so that I can still assign IP addresses later on?

Categories : Linux

fail to connect tomcat 7 webpage in Linux Oracle 6.3
Some of the latest Nolio versions doesn't support Mysql out of the box, and require some configuration for it. This is the Nolio knowledge base, on how to configure version 4.7 to work with Mysql - Nolio 4.7 - Custom Installation without Database Configuration This should solve your problem.

Categories : Mysql

Timestamp in database query in linux vs windows on Oracle
Ok, I was able to find the solution. The problem still alludes me but this solves it at least. Change: ps.setTimestamp(1, ts); To: ps.setTimestamp(1, ts, Calendar.getInstance(TimeZone.getDefault()));

Categories : Java

Oracle JDBC not giving expected output on Linux
The fetch size is different from the total number of rows returned. For example, if your query finds 10,000 matches, it won't return all 10,000 rows from the database. This is where fetch size comes in to play. If fetchSize is 10, then it will initially retrieve the first ten rows.

Categories : Java

Will killing a Linux process, stop it's query job in Oracle database?
It depends. When the client process sends a request to the database, the database will continue processing that request until it has a response. If the client process dies after sending the request, the database has no way of knowing this until it is ready to send the response. At that point, it can determine that the client process has failed and abandon the request. If the performance issue that you are worried about is that it takes the database a long time to run the query in order to return the first row of the result, killing the client process will have no effect on that. On the other hand, if the performance issue that you are worried about is that it takes a long time for the database to run the query to fetch all the rows and that it takes a long time for the client applic

Categories : C++

JAX-WS basic authentication using realm
You should have a servlet mapping in the web.xml based on the web service engine you are using. For example, I use the Metro stack on tomcat and have the following web.xml: <?xml version="1.0" encoding="UTF-8"?> <web-app version="3.0" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"> <listener> <listener-class>com.sun.xml.ws.transport.http.servlet.WSServletContextListener</listener-class> </listener> <servlet> <servlet-name>CallNotificationService</servlet-name> <servlet-class>com.sun.xml.ws.transport.http.servlet.WSServlet</servlet-class> <load-on-startu

Categories : Java

HTTP Authentication headers with no "realm"
WWW-Authenticate: Negotiate WWW-Authenticate: NTLM The problem is that your webserver is requesting NTLM authentication, so it wont accept BasicAuth. Use NTML authentication while sending request or change your webserver config to allow Basic authentication. Dont use BasicAuth because it sends user/pwd in plaintext over the network. Minimum safe is DigestAuth or NTLM or GSSNegotiate auth.

Categories : Python

Custom Tomcat Realm : ClassNotFoundException
From the stack trace, I discovered that the org.eclipse.gemini.web.tomcat bundle was attempting to load my custom realm. My solution was to create a new fragment bundle that uses org.eclipse.gemini.web.tomcat as a host. I placed my custom realm in this bundle, which resolved this exception.

Categories : Java

Getting Session Object in Tomcat Custom Realm
The way I always do this is with a Filter that runs after the authentication has been completed. If the HttpSession contains a user token, then I do nothing and call-down the chain. If the HttpSession does not contain that user token, I do everything I need to do to set-up the session using the Principal available from the request (because authentication has already occurred). It doesn't sound like this really needs to be part of authentication (the Realm), so separate the two.

Categories : Tomcat

How do I set up a Realm with a MySql Connection Pool in Tomcat 7?
Met the same problem with you, solved it by adding localDataSource="true" to the realm. <Realm className="org.apache.catalina.realm.DataSourceRealm" localDataSource="true" dataSourceName="jdbc/Tomcat" userTable="users" userNameCol="user_name" userCredCol="user_pass" userRoleTable="user_roles" roleNameCol="role_name"/>

Categories : Java

Realm configuration in tomcat for forms authentication
Yes, you can put realm into server.xml but also into context.xml. Moreover this is recommended configuration. Please refer to the following document for details: http://tomcat.apache.org/tomcat-5.5-doc/config/context.html

Categories : Java

Authentication using Tomcat realm or Facebook login
One option could be to use a Combined Realm: See http://tomcat.apache.org/tomcat-7.0-doc/realm-howto.html#CombinedRealm Realm 1 should be JDBCRealm, then implement realm 2 (FacebookRealm). You might change the order, based on which one is the most frequently used. See Tomcat docs for how to implement a realm. Of course you don't have a password in FacebookRealm, but you could do the following trick: JDBCRealm: username = username/userId in your application password = password FacebookRealm: username = username/userId in your application password = unique user id provided by Facebook This could allow users to log in with whatever method they want. Basically, this could be a possible use case for logging in through FacebookRealm (first steps might be a little bit different with JS SDK, b

Categories : Facebook

Service jboss.web.deployment.default-host./.realm is already registered
Generally the containers such as Jboss have a context root of <context-root>/</context-root> to intercept all the incoming requests and pass on to the application server. In your I suspect the conflicting app is JBoss AppServer root itself, you can disable that using the following (enable-welcome-root="false") <subsystem xmlns="urn:jboss:domain:web:1.0"> <connector name="http" protocol="HTTP/1.1" socket-binding="http" scheme="http"/> <virtual-server name="localhost" enable-welcome-root="false"> <alias name="example.com"/> </virtual-server> </subsystem>

Categories : Java

How to list all user principals from realm in an application server (glassfish)?
This is not possible. A realm or (Jaspic) authentication module can connect to any authentication provider like an LDAP server or OAuth provider. Especially with social networks like Google or Facebook you can't expect to retrieve a listing of all available users, Because of this universal connectivity such a method cannot be made available in the standard API.

Categories : Java

SHA-256 Message Digest in Tomcat 6.0 in normal webapp form (no realm related)
Ok! Finally I've noticed that GWT's MessageDigest implementation in compiled mode only supports MD5 algorithm, so SHA-256 is not compatible. During DevMode it's using the standard Java MessageDigest which also supports SHA-256. Best regards

Categories : Java

Hadoop map stuck on Word Count tutorial - Unable to load realm info from SCDynamicStore
go to http://localhost:50030/jobtracker.jsp and select the stuck job under running, find which map is stuck. go to the map job which is stuck and click all link on the right side which will point you to the exact error. Not sure if this helps you

Categories : Java

Why is a Maven plugin failing with error messages about 'API incompatibility', 'foreign imports' and the 'maven.api Class realm'?
It eventually occurred to me to look in the lib/ext directory of the JDK (on Mac, the equivalent directories are /Library/Java/Extensions and $HOME/Library/Java/Extensions) and, lo and behold, there was a version of SLF4J in there, along with a bunch of other stuff. Removing the SLF4J jars got my build working normally again. (Note: I have had the ATO's AUSKey software deposit things in the lib/ext directory before, which is why I thought to look there. I haven't yet checked to see whether AUSKey will still work after I removed SLF4J from the directory.)

Categories : Maven

How can I invalidate and login using realm login-config in tomcat
I found that it is not possible to use the <login-config> form in this way. However, the servlet 3.0 spec has given us access to a few helpful functions that allow you to write your own servlet that can log a user in. HttpServletRequest#login and HttpServletRequest#logout let you log a user in an out of the realm associated with the servlet context. Further, you can check if a user is logged into the realm by checking the user principal object with HttpServletRequest#getUserPrincipals. I set up my custom login page using these functions in a servlet at the path /login and I also have a near identical servlet/jsp that the realm authenticator will forward to but the difference is that the form will submit to the j_security_check. There is probably a fancy way to reuse the first login

Categories : Java

Exec(Linux). How it functions internally? Linux executable attributes(rlimit)
The RLIMIT_CORE is used to place a limit on the amount of info that coredump is allowed to produce, before it is aborted. Once this limit is hit, no more info is logged and the message Aborting Core is logged to the console. From the man page of core : A process can set its soft RLIMIT_CORE resource limit to place an upper limit on the size of the core dump file that will be produced if it receives a "core dump" signal. Use setrlimit() to configure RLIMIT_CORE to a larger value to obtain complete coredumps. The most common format of executables/shared-objects is ELF. On Linux, the dynamic loading and linking of these shared-objects is performed by ld.so ld.so is loaded in the address space of a newly created process (by exec in this case) and executed first. This is possible as

Categories : Android

Linux users', specifically Apache, permissions settings, [Linux noob :]
usually any daemon will need to access a number of ressources. it is therefore good practice to run each daemon under a special user:group, rather than nobody:nogroup. traditionally (e.g. on Debian systems) apache runs as www-data:www-data. finally, user permissions take precedence over group permissions (which in turn take precedence over other permissions). this means that a directory where the user does not have write perms but the user's group can write is effectively r/o for that user (but not for other members of the group)

Categories : Linux

Purpose of Curly Brace Usage of C Code found in Linux (include/linux/list.h)?
This is a GNU language extension known as a statement expression; it's not standard C.

Categories : C

Write C++ on Windows but use Linux System calls through a Linux emulator
You've already tagged your question with Cygwin. That seems like the best solution for what you want. Cygwin is basically a collection of programs which emulate a GNU/LInux environment through the use of a DLL (cygwin1.dll) which acts as a Linux API layer providing substantial Linux API functionality. Here's the link to the documentation for its API Edit: Most of the Cygwin source code that I've looked at is written in C++ and makes system calls using MS Windows API to do provide the *nix emulation. The source is well written and very readable (even to to a non-C++ programmer such as myself). I think using Cygwin would be a good transition from programming on Windows to a GNU/Linux environment.

Categories : C++

What's a good way to set up Closure Compiler on Linux? Or, where should Java .jar's live on a Linux?
If you using the java command directly, then you'll have to provide a path to the jar in question. It's probably easier to place the jar in one place and create a shell script that handles the invocation and jar path.

Categories : Java

How to turn a Linux application in C/C++ into a Desktop Enviroment for a Linux distro?
You either want to create a boot loader, or you want to replace the 'shell'. This would be governed by per-user or global xinit and Xsession files.

Categories : C

Oracle: Fastest way to UPSERT and return the last affected Row ID in oracle for large data sets
If you're trying to return the maximum value of a sequence-generated PK on the table then I'd just run a "Select max(id) .." directly afterwards. If other sessions are also modifying the table then maybe reading the currval of the sequence would be better.

Categories : C#

Oracle 01830 error while converting string to date in oracle procedure
If you are passing in a string of the following format 01/08/2013 12:00:00 AM then in order to successfully convert that string into a date datatype you should use the following format mask 'dd/mm/yyyy hh:mi:ss AM' which includes meridian indicator: to_date(vDateFrom, 'dd/mm/yyyy hh:mi:ss AM') but how do i make it variable?it could be PM too Meridian indicators are interchangeable. For both strings 01/08/2013 2:00:00 AM and 01/08/2013 2:00:00 PM for instance, you can use date format model with one of the meridian indicators, whether it AM or PM. Here is an example: select to_date('01/08/2013 2:00:00 AM', 'dd/mm/yyyy hh:mi:ss AM') as res from dual Result: Res ----------- 01.08.2013 2:00:00 select to_date('01/08/2013 2:00:00 PM', 'dd/mm/yyyy hh:mi:ss AM') as res from du

Categories : Oracle

Oracle PL/SQL - How do i copy a large amount of data from one table to another using oracle collections
/* package header */ CREATE OR REPLACE PACKAGE perfrormance_test AS PROCEDURE nested_table; PROCEDURE associative_array; END perfrormance_test; /* package body */ CREATE OR REPLACE PACKAGE BODY perfrormance_test AS PROCEDURE nested_table AS /* select all records from source table */ CURSOR big_table_cur IS SELECT col1 , col2 , col3 FROM big_table; /* create nested table type and variable that will hold BIG_TABLE's records */ TYPE big_table_ntt IS TABLE OF big_table_cur%ROWTYPE; l_big_table big_table_ntt; BEGIN /* open pointer to SELECT statement */ OPEN big_table_cur; /* collect data in the collection */ FETCH big_table_cur BULK

Categories : SQL

Getting an error when try to connect to Oracle java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
Add your Oracle JDBC Driver jar to the classpath Can download the driver for your Oracle Database Version from here

Categories : Oracle

Do i need to install mono on every Linux PC to run .NET application on Linux platform?
"can I run a mono application on a machine that doesn't have mono installed": no; the same as you can't run a java application on a machine that doesn't have java installed. And at the same time (to both): yes. There are tools that attempt to make this work, but they tend to be fiddly and a bit unreliable. However, it should also be noted that several (not all, by any means) distros ship with mono by default.

Categories : Dotnet

OALL8 is in an inconsistent state in Oracle Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
This post (Oracle: OALL8 is in an inconsistent state) suggest that it's an OJDBC bug that was related to the CURSOR_SHARING mode SIMILAR. So: Check with Oracle if a fix exists. Check whether there are any differences in the settings between development and production and fix them. Set Cursor Sharing to EXACT if it's set to a different mode.

Categories : Database

getting date fields from oracle in correct format using Python and cx-oracle
You can use strftime. For example: >>> import datetime >>> print datetime.datetime.now().strftime("%Y-%m-%d %H:%M") 2013-08-13 13:10 In your case, this can make it: strftime("%d-%b-%Y") where: %b locale's abbreviated month name (e.g., Jan) %d day of month (e.g., 01) %Y year

Categories : Python

What is location of built in SQL functions and Oracle Packages in Oracle Database
The scripts to create the build-in functions, packages and procedures are stored on the database server machine. You have to find the value of the environment variable $ORACLE_HOME, and then go to $ORACLE_HOME/rdbms/admin/. Just use grep to find the file you're looking for. If the database server is a Windows machine, look at ECHO %ORACLE_HOME% at the command prompt and proceed from there.

Categories : SQL

In SAS, how do I connect to a remote Oracle database by specifying the IP address of the Oracle's host?
To use SAS/Access to Oracle on your server "A", that server must have the Oracle networking client software installed and configured. Normally that is managed by an Oracle administrator on that server. It can be as simple as adding an entry into the tnsnames.ora file on your server that "points" to the Oracle instance running on your Windows machine "B". The details of what needs to be added should come from your Oracle DBA. Once you can successfully connect to that Oracle environment from your server "A" (using something like sqlplus or testing with the tnsping command), SAS will use the same connection. The point is that this does not have anything directly to do with SAS; you must set up the environment first. However, note that there are certain posit-installation steps that must

Categories : Oracle

Connect Oracle Forms builder to Oracle XE database, both 10G
You need to configure your DevSuiteHome environment to look at your OracleXE tnsnames.ora, or copy the tns entry from the OracleXE environment to the DevSuiteHome one... In my environments, I just set the TNS_ADMIN registry key in DevSuiteHome to point to the OracleXE TNS_ADMIN directory...

Categories : Oracle

Difference in oracle 11.2.0.1.0 and oracle 11.2.0.2.0 while inserting a value into the table using sequence
The problem may have to due with the fact that NOORDER is the default with Oracle Sequences, especially if you're running a RAC environment. http://docs.oracle.com/cd/B12037_01/server.101/b10759/statements_6014.htm I've learned that with Sequences, if I want to guarantee that they be sequential I usually have to add the following keywords when creating the sequence: CREATE SEQUENCE m1_id_sq ORDER NOCACHE; Edit to refer to above comments: As noted by Alex Poole in the comments above: "This shouldn't really matter anyway - you'll get gaps in sequences for other reasons so you shouldn't rely on it starting with 1" The NOORDER being the default for sequences explains this issue. Alex Poole also noted a known issue: Oracle Note 1050193.1 (requires an Oracle Support account) rela

Categories : Oracle

fedora linux --- compiling first linux module
As guido said, you have to match your current kernel and the kernel-devel package. To get your kernel version run uname -r I get 3.6.10-4.fc18.x86_64, download that kernel-devel version sudo yum install kernel-devel-3.6.10-4.fc18 Or update your system and boot with the new kernel, I believe those two will automatically match.

Categories : Linux

How do I export a 'database' from Oracle 11g XE and import it to Oracle 10.2?
EXP and IMP are ancient - do not use them unless you absolutely have to. They cannot handle some of the features of newer Oracle versions. The tools of choice are EXPDP and IMPDP (short for EXP datapump and IMP datapump). Unfortunately, using them is a little more complicated, because you can run them only on the database server (contrary to old-style EXP/IMP, which you could run from any client computer). So, to get your schema from the 11g source DB to the 10g target DB, you'll have to: open a terminal session on the 11g DB server run expdp with version set to 10 (so you can import it on the 10g server) copy the dump file fom the 11g server to the datapump directory of the 10g server (look for a directory called "dpump") open a terminal session on the 10g DB server run impdp with

Categories : Windows



© Copyright 2017 w3hello.com Publishing Limited. All rights reserved.