|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
You should always keep a regular backup of your production database -- ours
runs every 12 hours.
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL 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.
|Trying to install oracle on Scientific Linux release 6.2|
wget https://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol6 -O
Run the above command. I just now did the same.
Or go to the link http://public-yum.oracle.com/ to scroll down to get the
link compatible to your OS.
|how to find oracle listener port in linux|
From the command prompt you can use lsnrctl status, here is the relevant
You can also use the Oracle Enterprise Manager web interface under General
|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?
|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.
|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.
ps.setTimestamp(1, ts, Calendar.getInstance(TimeZone.getDefault()));
|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.
|Will killing a Linux process, stop it's query job in Oracle database?|
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
|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"
|HTTP Authentication headers with no "realm"|
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.
|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.
|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.
|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.
userTable="users" userNameCol="user_name" userCredCol="user_pass"
|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:
|Authentication using Tomcat realm or Facebook login|
One option could be to use a Combined Realm: See
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
username = username/userId in your application
password = password
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
|Service jboss.web.deployment.default-host./.realm is already registered|
Generally the containers such as Jboss have a context root of
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
<connector name="http" protocol="HTTP/1.1" socket-binding="http"
<virtual-server name="localhost" enable-welcome-root="false">
|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.
|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
|Hadoop map stuck on Word Count tutorial - Unable to load realm info from SCDynamicStore|
go to http://localhost:50030/jobtracker.jsp
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
|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
|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
|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
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
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
|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)
|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
|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.
|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.
|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.
|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.
|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
select to_date('01/08/2013 2:00:00 AM', 'dd/mm/yyyy hh:mi:ss AM') as res
select to_date('01/08/2013 2:00:00 PM', 'dd/mm/yyyy hh:mi:ss AM') as res
|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
/* package body */
CREATE OR REPLACE PACKAGE BODY perfrormance_test AS
/* select all records from source table */
CURSOR big_table_cur IS
/* create nested table type and variable that will hold BIG_TABLE's
TYPE big_table_ntt IS TABLE OF big_table_cur%ROWTYPE;
/* open pointer to SELECT statement */
/* collect data in the collection */
FETCH big_table_cur BULK
|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
|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.
|OALL8 is in an inconsistent state in Oracle Oracle Database 11g Enterprise Edition Release 22.214.171.124.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.
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.
|getting date fields from oracle in correct format using Python and cx-oracle|
You can use strftime.
>>> import datetime
>>> print datetime.datetime.now().strftime("%Y-%m-%d %H:%M")
In your case, this can make it:
%b locale's abbreviated month name (e.g., Jan)
%d day of month (e.g., 01)
|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
If the database server is a Windows machine, look at ECHO %ORACLE_HOME% at
the command prompt and proceed from there.
|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
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
|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
|Difference in oracle 126.96.36.199.0 and oracle 188.8.131.52.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.
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
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
|fedora linux --- compiling first linux module|
As guido said, you have to match your current kernel and the kernel-devel
To get your kernel version run
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.
|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
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
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