All versions of Oracle. Also add a version-specific tag like oracle-11g-r2 if that context is important in the question.

learn more… | top users | synonyms

0
votes
3answers
330 views

lsnrctl is not working on Ubuntu 14.04

I have managed to install Oracle 11g on Ubuntu 14.04 through lots of pain. I managed to install it in the end but listener does not seem to be working and even responding any command. My ...
0
votes
2answers
648 views

Can't login ORA-28031: maximum of 148 enabled roles exceeded

I can't login - and receive the error code above. How do I fix this?
0
votes
1answer
44 views

Oracle: i want to setup some variables for login.sql

I use this login.sql for my oracle session select 'You are: '||upper(user) "Welcome to Oracle on AIX 7.1" from dual union all select 'Logged into: ...
0
votes
2answers
58 views

ORA-01422 Error Occurred When I Call Procedure with Number Parameter

I want to write PL/SQL Procedure that updates salary which is less than 2000. I wrote this procedure.And when i call it with integer id 'ORA-01422: exact fetch returns more than requested number of ...
0
votes
1answer
122 views

How can I partitioning oracle table when the table still working?

How can I partitioning oracle table when the table still working? Explain: - I need to partitioning table of Oracle but the table didn't partitioned before. - I have many scheduler I can't close it ...
0
votes
1answer
49 views

restoring database using RMAN [closed]

If I have new data like new users and tables created after backing up database with RMAN , in case of restoring database will the operation affect my new data made after taking the backup?
0
votes
1answer
128 views

Is possible do an online snapshot backup , without archive logs at Oracle Database?

Using Oracle Database Standard Edition 11r2 . I'm looking a way to backup the database with zero downtime , using a snapshot of datafiles (LVM snapshots) and without need backup de archive logs. ...
0
votes
1answer
2k views

SQL Developer - trying to import an excel file into a table

I'm trying to import an excel file into a table. The excel file has dates in the following format: 20/08/2008 12:00:00 AM and I am telling SQLDEV the following: DD/MM/YYYY H24:MI:SS AM To import the ...
0
votes
1answer
62 views

Logging into Oracle

I am new to Oracle (coming from a SQL Server world). This is going to probably be some simple newbie question. I just did a fresh install of Oracle 12c Express. The install was successful, but now I ...
0
votes
2answers
1k views

RMAN restore from tag

oracle 11.2.0.4 on redhat 6 SERV1 is prod server running database MAZ, SERV2 is developemt server with no databases on it. i have noted the dbid and last SCN, and then taken a backup on SERV1 using ...
0
votes
1answer
194 views

ORA-19809 & ORA-12560

Following some maintenance on our server (change raid battery + reboot) my database (Oracle 11g) is not available anymore. I m a newbie in Oracle and I have been through the forum and I can t find the ...
0
votes
1answer
510 views

How to quickly increase column size in Oracle?

In our Oracle 11 database we have a table with more that 100 million rows and we would like to increase size of one column (not used in any index). I tried to execute command alter table shipment ...
0
votes
1answer
273 views

optimizing init.ora oracle database server

Can anybody help me in optimizing my SGA, PGA and other paramters of the init.ora file. We usually have average of 159 sessions on the database server. I think there's some thing wrong with my SGA, ...
0
votes
1answer
283 views

How can I use Oracle's CONNECT BY PRIOR to only get specific revisions of hierarchical records?

I've got a table schema in Oracle 11 which is storing records that are linked together. The table schema is roughly like this CREATE TABLE "SOMEDATA" ( "ID" INTEGER NOT NULL, "ITEMNAME" ...
0
votes
3answers
204 views

Oracle monitor tool [closed]

Our Oracle server continues with out of memory problem, and we don't have an Oracle DBA in our team. Is there any Oracle monitor tool or ways to find the reason? We have a lot of stored procedure ...
0
votes
2answers
81 views

To know list of users having access to Views

Please help me to find out the list of users who are having access to particular user defined views in Oracle.?
0
votes
2answers
12k views

ORA-12518: TNS:listener could not hand off client connection ORACLE XE 11.2 x64

Im starting to be very very frustrated by this Oracle. So, I have installed Oracle XE 11.2 64 bit and ODAC121012_x64. I can start listener, I can do tnsping xe, but when I try to connect as via ...
0
votes
1answer
8k views

ora 20001 error in oracle dbms scheduler

i have written a test job like begin DBMS_SCHEDULER.CREATE_JOB ( job_name => 'test_job' ,job_type =>'plsql_block' ,job_action => 'null' ,enabled => true ); end; / after a while when ...
0
votes
1answer
988 views

lsnrctl: cannot execute binary file: Exec format error [closed]

When I type lsnrctl from my command prompt the below error message is displayed: oracle@Gaurav:~$ lsnrctl bash: /u01/app/oracle/product/12.1.0/dbhome_1/bin/lsnrctl: cannot execute binary file: Exec ...
0
votes
1answer
97 views

How to add a new target in Oracle Enterprise Manager 12 C

I just installed Oracle Enterprise Manager 12 C Grid Control from a ready made image that Oracle provides and now I am trying to add targets to it (monitoring targets i mean). It might be a stupid ...
0
votes
1answer
619 views

Recover data from bak Oracle 9i file

Our customer gave us a .bak archive with name file_decrypted_379299.bak which we know was created with Oracle 9i in "hot" style. We tried to recover the bak file with Oracle 9i RMAN but we don't know ...
0
votes
1answer
961 views

Installing Oracle Database 12c in Windows 7, INS-08109 error [closed]

I'd like to learn PL/SQL so I'm trying to install Oracle. I downloaded the 2 zip files and extracted to the same directory. I run the "setup.exe" file and the install GUI starts: In step 1 I enter ...
0
votes
2answers
14k views

Oracleasm deletedisk failed Unable to clear disk

I have dropped the disk from ASM diskgroup: > ALTER DISKGROUP DATA01 DROP DISK DISK1; Oracle did a rebalance operation and then dropped the disk. Now, I want to delete the disk from ASM library ...
0
votes
1answer
87 views

How to fix this error Idk?

how to fix it I am new in Oracle? I tried to connect RMAN and it showed me this error...
0
votes
1answer
904 views

Oracle installation fails due to ORA-00443

I hope that you help me to resolve my problem. I'm trying to install Oracle 11g on RHEL 6. All prerequisites are ok, but I'm getting such error during step "Creating and starting Oracle instance". The ...
0
votes
1answer
704 views

Oracle 11G Startup failed after altering the number of system processes

When I alter the number of system processes to 100000 and restart the database, I get the error below: ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semids_per_proc ...
0
votes
1answer
811 views

Oracle 11g http listener configuration for PL/SQL server pages

Could please someone point me how to configure oracle db to be able to display PL/SQL Server pages. I have successfully created and mapped dad with the DBMS_EPG. Here is the listener: # listener.ora ...
0
votes
1answer
2k views

How to count number of rows inside Oracle dump file?

I have a huge (38Gb after bzip2) Oracle EXP dump file. It contains one table. Such big dumps usually end up with an error, but in fact contain the full table. Earlier I was importing these tables ...
0
votes
1answer
196 views

Oracle TRANSLATE Not Returning Expected Result

We are trying to execute TRANSLATE on a couple hundred rows of data. We have a temporary table containing ID's to rows that need to be updated using TRANSLATE. The odd part is if we attempt to select ...
0
votes
1answer
6k views

PLS-00049 bad bind variable when compiling a trigger

I'm trying to implement a dedupe trigger to a table. CREATE OR REPLACE TRIGGER USER.TBL_ACTION_DEDUP BEFORE INSERT ON USER.ERRORTABLE REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW BEGIN IF ...
0
votes
2answers
5k views

Cannot connect to database remotely (not even locally when using ip address)

I can login using this command: sqlplus test/test@127.0.0.1:1521/local But not this one: (where 192.168.0.240) is my IP sqlplus test/test@192.168.0.240:1521/local I am absolutely sure that my ip ...
0
votes
3answers
993 views

Oracle won't start

While it was working fine, I had to stop the server once. When trying to start Oracle using a script we have, I got the following error: SQL> Connected to an idle instance. SQL> ORA-01081: ...
0
votes
2answers
86 views

Change archivelog location in Oracle

Oracle instance I set up is using USE_DB_RECOVERY_FILE_DEST for archivelog location. log_archive_dest_1 string LOCATION=use_db_recovery_file_ dest, valid_for=(ALL_ROLES,ALL ...
0
votes
4answers
4k views

Stored Procedure result is not showing in Datagrid pane in Toad for Oracle

I have created a procedure in Toad for Oracle 12. When I execute the procedure it does not show the dataset in datagrid pane, while the procedure is being executed successfully. What I am doing wrong? ...
0
votes
2answers
4k views

ORA-12154: TNS:could not resolve the connect identifier specified [closed]

I've initially posted this question on serverfault.com, but because lack of answers decided to post it here... I'm trying to use bat file/CLI to run SQL script against certain Oracle database with ...
-1
votes
3answers
22k views

Creating an admin user in Oracle

How can I create a "root" (like on MySQL) in Oracle? I installed Oracle database on my system, for homework, for school (faculty) but it didn't give me the option to make a root user. Well at least I ...
-1
votes
2answers
505 views

Oracle SQL Query/SubQuery Single column with mutilple data [closed]

Id File-Name Descrption 1 yyyy Started 2 yyyy incompleted 3 rrrr Started 4 tttt started 5 uuuu started 6 rrrr completed 7 tttt completed 8 uuuu ...
-1
votes
2answers
70 views

Finding the number of columns a table has

How can I find out the number of columns a table has? I use oracle 10g and I want to develop a J2EE application to count the number of columns of different tables.
-1
votes
2answers
5k views

maximum number of interval partitions in Oracle 11g

Does anyone know the maximum number of interval partitions permitted in Oracle 11g? didnt find anything in Oracle documentation -perhaps missed something. Thanks in advance!
-1
votes
1answer
62 views

Need help with this policy function: Shows compilation errors [closed]

Create or Replace FUNCTION Hello_Fun ( P_SCHEMA IN varchar2, P_OBJECT IN varchar2) Return varchar2 IS V_Hello Varchar2(400); BEGIN If User = 'Admin' then V_Hello := ''; Else V_Hello := 'cus_id ...
-1
votes
1answer
75 views

Switching from Oracle database to Ubuntu [closed]

I need support please. I am the CEO of a Life Assurance company. We are currently building our own core application under the leadership of my Head of ISD. We are using Oracle for our database and ...
-1
votes
5answers
456 views

What is a DB Link good for? [closed]

Here is defined what a DBLink is but I really understand for what kind of situations you need it? What I could imagine is a situation where I have a limited (in size like sql-server express) ...
-1
votes
1answer
16k views

where is the oracle 12c logfile?

I am getting all of the following error first: ORA-12162: TNS:net service name is incorrectly specified When I export the ORACLE_SID , I can run any command and I get the following error: ...
-1
votes
1answer
979 views

Adding a column at a specific position using DBMS_REDEFINITION

Can anybody tell me how I can add a column to table at a specific position using the DBMS_REDEFINITION package from Oracle?
-1
votes
2answers
85 views

Oracle audit log to other server?

How can I configure audit log records to other server? Because: DB Server is full because it is very big. Our IT team manages DB server and our team (security team) is going to get audit log in our ...
-1
votes
1answer
52 views

kind help to correct syntax [closed]

create table first as (SELECT * FROM edge1 h1 inner join edge1 h2 ON ( h1.e1=h2.e1 AND h2.e1 != h1.e2 AND h2.e1 != h1.e3 AND h2.e1 != h1.e4 AND h2.e1 != ...
-1
votes
1answer
7k views

Commit and rollback in Oracle stored procedure

In my Oracle stored procedure, I have multiple insert and update statements like below: create or replace PROCEDURE SPTest AS BEGIN insert into emptest(empid,empname,deptno) (1,'ravi',10); ...
-1
votes
3answers
2k views

Full table scan even after adding index

i have two tables in Oracle 11g server one is partitioned and another is having a 3GB of data. I've added a composite index on both the tables based on the where clause, in the order it appears. The ...
-1
votes
1answer
63 views

How to compare a result of a query to a number? [closed]

I have a query that return selects a table and returns one column with a number, and I want to know if the result is > 0. SELECT * FROM Table WHERE (SELECT amount from Table2) > 0 ...
-1
votes
1answer
104 views

Select query from two tables which only specified rows [closed]

I want to try querying two tables, like this: Table A user_id primary_indicator ------- ----------------- 9012445 Y 9012445 N 9012442 N 9012332 Y 9012332 N 9012445 9012332 Table B ...