can we query this without login to the oracle database from linux os?database is up and running . /apps/oracle/product/11.2.0/dbhome/bin/sqlplus system/passwd select name from v$database;
View 5 RepliesHow can I to connect and execute query from Oracle without to use others products ( DG4MSQL ....etc) ?using 9.2.08
View 5 Replies View RelatedI am trying to have an encryption logic written in Pl/SQL that could decrypt the value which is encrypted in Dot Net, using AES128 algorithm. Everytime when i try to have the decryption done, i lands up in one or the other error message. Below is the code snippet which i use. create or replace
FUNCTION decryptAES (EncryptedText IN VARCHAR2,EncKey IN VARCHAR2) RETURN VARCHAR2 DETERMINISTIC IS key_bytes_raw RAW (2048); l_ decrypted_raw RAW (2048); encryption_type PLS_INTEGER := DBMS_CRYPTO.ENCRYPT_AES128; BEGIN key_bytes_ raw:= UTL_RAW. CAST_TO_ RAW (EncKey); l_decrypted_raw := dbms_crypto.decrypt (src =>utl_raw.cast_to_raw(EncryptedText), typ => encryption_type, key => key_bytes_raw ); RETURN (UTL_RAW.CAST_TO_VARCHAR2 (l_decrypted_raw)); END decryptAES.
I was trying to execute below query inside a sql script which is called from a shell script on linux environment. EXECUTE IMMEDIATE 'alter session set events ''10176 trace name context forever'' ';
This thing works at our test environment. But giving error "SP2-0670: Internal number conversion failed" when tried on live(production) environment. What could be the reason? I found another way of writing such queries on net as follows, will it be useful? EXECUTE IMMEDIATE q'|alter session set events '10176 trace name context forever'|
I have two table APPLICATION_1 and APPLICATION_2, where user's login date is captured.There will be multiple records for each user.Same user may or may not be present in both tables.
The requirement is to find those users who have not logged-in in the last 3 years.
-- Test Case
DROP TABLE application_1;
DROP TABLE application_2;
CREATE TABLE application_1
(
seq NUMBER ,
user_id VARCHAR2(30),
[code].....
Using the below query I'm able to get the desired output.
SELECT user_id, MAX(login_date) last_login_date FROM (
SELECT user_id, MAX(login_date) login_date FROM application_1 GROUP BY user_id
UNION ALL
SELECT user_id, MAX(login_date) login_date FROM application_2 GROUP BY user_id
) GROUP BY user_id
[code].....
We are planning Database Migration From Windows to Linux Using RMAN..We required Oracle database 10.2.0.4 for Linux 64 bit.
View 3 Replies View Relatedi am new to linux os . the step by step process of oracle database 10gR2 and oracle 10g client installation in linux os
View 6 Replies View RelatedI need to design my login form to be able to connect to different database environment (Env1 and Env2).When the login form is loaded it is already connected to Env1, after the user enters his login details he has option to continue with Env1 or connect to Env2.I used the "Logout;" to disconnect from already connected Env1 and used "Logon(<username>,<pwd>@<Db instance>);" but i see that the form will connect to Env1 irrespective of what environment credentials i provide in Logon. how i can disconnect from Env1 and connect to Env2. Is this possible?
View 2 Replies View RelatedI have laptop by this specification:
1) Operating System: Windows 7 64-bit
2) Virtual Machine: Windows XP Service Pack 3
3) DB: Oracle 11.2
4) Oracle Form Designer 4.5
i try to connect to SQL*PLUS 3.3 i got this error after defining in TNSNAMES.ORA in this folder c:orant networkadmin nsnames.ora
SQL*Plus: Release 11.2.0.1.0 Production on Thu Aug 18 19:49:12 2011
Copyright © 1982, 2010, Oracle. All rights reserved.
SQL> SHO USER
USER is ""
SQL> CONN SYSTEM@LOC
Enter password:
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
I have a problem to login on my database 11.1.0.7 on linux 64. It were migrated from 9.2.0.4 and everything was fine but now I am not able to connect to database.
Only one way when I can connect is when the database is started in RESTRICTED mode and I cold login under sys (sysdba).
But when i leave this mode, nobody can connect . sqlplus is freeze and I have to kill that session. What could be a reason? Any parameters? It's strange for me because It was working..
I am not able to Login database , what should i do?
View 2 Replies View RelatedI need to migrate a 500 GB 10.2 database from windows to linux. Of course I found Alejandro Vargas paper on how to do that ("Database Migration From Windows to Linux Using RMAN"). My problem is that the source database will be up again for 7 days and I need to apply all changes made to the source database to the migrated linux database.
Can I just take all redo log files generated from the source database and apply those to the destination database? I might have a problem with a) file conversion and that the redo log are not in sync with the target database (different check points?).I just found that on an exotic website: "The contents of a redo log file depend on a combination of Oracle version, operating system and server architecture. In general redo logs written on one architecture cannot be read on another. There are a few exceptions to this rule. For example, in Oracle 10.2 a redo log written in Linux can be read by a Windows database."
So if this is true, does it also work the other way AND will the database migration from window to linux create a perfect clone of the database where those redo log files actually can be applied to?
We are planning to migate Oracle database from Linux 10gR2 (non-ASM) to Solaris (ASM) and then Oracle upgrade that database from 10gR2 to 11gR2 on Solaris.
View 4 Replies View RelatedHow I can maintain a replication scheme from a production database and a standby. I was watching the advanced replication methods of Oracle, but what I want is in the evening to run a process and modify the database incrementally and thus leave until the next night.
And the server I want to allocate to the standby database, also implements other processes, so my settings would be:
Production: Oracle Database 11g Linux 5.5
Standby: Windows 2003 Database 11g
Maybe that data is important, let me make clear that what I want is that the database is updated incrementally.
URL.....Where can I download Oracle database express edition for x86 Linux? I can only see Windows and x64 Linux in Oracle's download page URL....
View 2 Replies View RelatedI am trying to understand how to enable some audit so we can capture OEM logins as well.
Here is my setup. Lets say my DB that i am auditing is called audit_db (audit trail set to DB) sitting on host called host_db. and we have grid control agent on this box.now my grid control is as this. Lets say my OMS and repository is on host called OMS_host.
we run query aginst dba_audit_session to get info as to who tried failed login attemps and stuff.
Now to the part that is not working.
-- this is the good part When i intentionaly login to the audit_db with sqlplus client from my laptop with wrong username/password that is captured. we get the username,os_username,userhost,terminal.
here is the sample output
username is the wrong user that i tried to login as
os_username is the my local username(ad account)
userhost is my_laptop_name
terminal is laptop_name
from above we can figure who was trying to login(failed).
-- this is the bad part But lets say i try to login to audit_db through grid control and use wrong username/password.that gets captured too(but not all of it). we get the username,os_username,userhost,terminal.
here is the sample output
username is the wrong user that i tried to login as
os_username is the user of OMS repository db(oracle)
userhost is oms_host
terminal is unknown
Now with the above info, we cannot figure out who tried to login with bad login credential.
I tried to login and start my db this evening and I receive the following message
[oracle@dbs]$ export ORACLE_SID=ORCL
[oracle@ukedxdtmtdbs01a dbs]$ sqlplus '/ as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Sat May 14 19:59:48 2011
Copyright © 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
ORA-01075: you are currently logged on
How can I resolve - none of the passwords I enter seem to work? I have these init files
ls -ltr init*.ora
-rw-r--r-- 1 oracle oinstall 2867 May 14 18:53 init.ora
-rw-r--r-- 1 oracle oinstall 2867 May 14 19:12 initORCL.ora
my init.ora file looks like this:
db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/adump'
audit_trail ='db'
[code]...
db had been up and running for about 2 weeks with no issues since installation..I am just trying to get the db up and running - nothing more
I installed oracle database 10g on my laptop, it installed successfully. I see sql plus in my program, how will i get login details for my database?
View 6 Replies View RelatedI need to migrate database from Windows to Linux. The current size is ~50GB.
Current Env:
OS = Windows 2003
DB version = 10.2.0.3
Proposed Env:
OS = Linux
DB version = 11.2.0.2
Would using datapump be a correct choice for this migration? Also do the step below seem correct?
01. Pre-create tablespaces on target 11g database
02. Export full database of source 10g database
03. Copy dumpfile to Destination Server
04. Grant IMPORT_FULL_DATABASE system privilege to user SYSTEM of target 11g database
05. Import full database to target 11g database
We have 3 databases with version 10.2.0.3.0 running on RHEL AS 4.5 32 bit operating system. We are planning to move these databases to RHEL 64 bit Operating system.
let me know the highest 64 bit RHEL version supported by these databases(10.2.0.3). Will it support with RHEL 5.5 64 bit version?
I am new in oracle I have installed Oracle in work group, while i work group it is working fine. But latter I have change the server from work group to domain. At that time Oracle was not working , not able to connect.
After that I change the Domain to work group again. And same problem exist. But I found that lsnrctl is working fine. But OracleServiceXXX is not able to startup in services.msc
I have installed Oracle in workgroup, while i workgroup it is working fine. But latter I have change the server from workgroup to domain. At that time Oracle was not working , not able to connect. After that I change the Domain to workgroup again. And same problem exist. But I found that lsnrctl is working fine. But OracleServiceXXX is not able to startup in services.msc
View 7 Replies View RelatedI am using Oracle forms 6i. I want to create an application that does not require any connection with Oracle database. My Application fetch all its data from an Excel file. I do not want Login with Database,so i want to bypass it. How can i do it ?
View 6 Replies View RelatedI instaledl Oracle Database 11g in my PC and try to login to it. I am able to log to it via SQLDeveloper but I can not login via SQLPLUS and I got ORA-12154. Here is my TNSname.ora and SQLplus.ora
# sqlnet.ora Network Configuration File: C:appmhakimjavadiproduct11.2.0dbhome_1
etworkadminsqlnet.ora
# Generated by Oracle configuration tools.
# This file is actually generated by netca. But if customers choose to
# install "Software Only", this file wont exist and without the native
[code]....
I need to login remote DB writing a shell script where our DB is on a separate node, i have to test the script only with
SCHEMA USERNAME
PASSWORD
HOSTNAME
PORT NO
SID/SERVICE NAME
these details. May be am wrong to ask this question but i need to login and check the requirement. Is there any other anyway to login without sqlplus utility?
can we import oracle 10g database table into oracle 8i database on linux platform?
View 7 Replies View RelatedWe have a scenario where Oracle Database R1 is installed on Windows System and the Client is present on Linux. Both the system is on same network. We can access Windows -2-Windows using TNS entry.
I am unable to connect to this scenario where Database is on Windows and Client is on Linux.
Issue : NOT able to start the Oracle Data Base 11g on Linux machine
I've successfully installed Oracle-DB-11g on my Linux machine.
Note : I haven't declared or exported any variable(s) , actually I'm not sure how and where to do this.
I was trying to create a 11g database on linux using dbca.
At very end "create database" I got 'The file pach +DATADG/orcl/system01.dbf in invalid. Check the permissions.'
How to check the permission?
I need to do the following:
(1) Move my 10gR2 database from 32-bit Linux to 11gR2 64-Bit Linux (using an RMAN backup from 10gR2 restored on the 64-bit machine) then
(2) Bring up the database on 64-bit hardware and then upgrade to 11.2.0.3 (64-Bit) [Without installing the 10.2.0.3 64-Bit software]
Haven't tried restoring to 11.2.0.3 from a RMAN 10.2.0.3 backup. I was trying not to have to install the Oracle 10.2.0.3 software for 64-bit on the 64-bit machine. Was hoping to go directly to 11.2.0.3 (64-bit).