How To Completely Remove 11g From Computer

Mar 12, 2011

how to Completely remove Oracle 11g from my computer ?

View 2 Replies


ADVERTISEMENT

How To Completely Remove Single-Sign On

Jul 9, 2013

RE: Partial install of SSO leaves orphaned instances.

Background: Lost connection to Linux system while attempting SSO install. During reinstall installer states instance name already in use - suggests using different name.

Using deconfig.pl tool (user: cn=orcladmin) to remove SSO configuration, but error encountered. Reason: incorrect SYS password. Note: Can access db using SYS password with no problem.

Question: Does deconfig.pl completely remove SSO configuration? If not, what other steps are required to completely remove SSO?

View 1 Replies View Related

SQL & PL/SQL :: Copy Data Of One Partition Completely To Another Table

Nov 16, 2010

I have 2 tables with same no of column and range partition based on date.At the end of month i want to copy the data of one table to another table.Instead of copy the data i want to copy the data of one partition completely to another table partition ..

View 2 Replies View Related

Real Application Clusters :: How To Completely Shutdown The Entire Crs Stack In All Nodes

Nov 11, 2013

Grid version: 11.2.0.4Platform : OEL 6.4 

To shutdown the entire crs stack, I ran crsctl stop cluster -all from one node. After the command execution,  the below mentioned processes were still running on all nodes.   

[root@intsmdp01 ~]# ps -ef | grep d.binroot     38562 33228  0 19:12 pts/2    00:00:00 grep d.binroot     80820     1  0 Nov09 ?        00:20:56 /crs/product/11.2.0/bin/ohasd.bin rebootgrid     81448     1  0 Nov09 ?        00:01:22 /crs/product/11.2.0/bin/mdnsd.bingrid     81459     1  0 Nov09 ?        00:01:55 /crs/product/11.2.0/bin/gpnpd.bingrid     81473     1  0 Nov09 ?        00:17:26 /crs/product/11.2.0/bin/gipcd.binroot     81484     1 20 Nov09 ?        09:10:27 /crs/product/11.2.0/bin/osysmond.bin  

So , I had to manually run crsctl stop crs on all nodes. 

[root@intsmdp01 ~]# /crs/product/11.2.0/bin/crsctl stop crsCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'intsmdp01'CRS-2673: Attempting to stop 'ora.crf' on 'intsmdp01'CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'intsmdp01'CRS-2673: Attempting to stop 'ora.mdnsd' on 'intsmdp01'CRS-2677: Stop of 'ora.crf' on 'intsmdp01' succeededCRS-2673: Attempting to stop 'ora.gipcd' on 'intsmdp01'CRS-2677: Stop of 'ora.mdnsd' on 'intsmdp01' succeededCRS-2677: Stop of 'ora.drivers.acfs' on 'intsmdp01' succeededCRS-2677: Stop of 'ora.gipcd' on 'intsmdp01' succeededCRS-2673: Attempting to stop 'ora.gpnpd' on 'intsmdp01'CRS-2677: Stop of 'ora.gpnpd' on 'intsmdp01' succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'intsmdp01' has completedCRS-4133: Oracle High Availability Services has been stopped.[root@intsmdp01 ~]#  

Is there a way to bring down the entire crs stack in all the nodes in the cluster from one node ?

View 3 Replies View Related

Real Application Clusters :: Newly Installed 11gR2 - Inserted Rows Completely Gone When Restart Cluster

Jan 2, 2013

I have recently setup a 2 node Rac on oracle linux 5.4 with oracel 11gR2, the installation went smoothly and all the cluster resources are up and running however the data is not syncing across the nodes, when I create a table it shows up on the other node but when I insert rows into the tables they don't show up on the other node and when I restart the cluster the inserted rows are completely gone even from the node where I inserted them.

View 4 Replies View Related

How To Delete SID Name (oracle) From Computer

Oct 29, 2010

How to delete SID name (oracle) from my computer ?

View 7 Replies View Related

Should DBConsole Be Crashing Computer

Nov 23, 2010

I have Oracle 11g downloaded on my laptop for personal use. Here are my specs-

Gateway T-6815
Processor: Intel® Core™2 Duo CPU T5250 @1.5GHz 1.50 GHz
RAM: 1.00 G
32-bit Operating System
Windows Vista -Home Premium
Disk Space Available : 16.8 GB free of 138 GB

Every time I start DBConsole it takes almost 30 minutes to start, slows down the computer to the point where its not usable and/or crashes it.

View 1 Replies View Related

Add Datafile On Remote Computer

Sep 19, 2012

i am working on oracle 10g windows & all my disks are full and i want to add a datafile on other computer . how can i do it ?

View 11 Replies View Related

PL/SQL :: Transferring Database From One Computer To Another

Oct 1, 2012

Im doing a project for my college and i need to transfer database. The thing is that i have created tables with databases and linked it to VB using ADODC.

I have done all this in the Computer at my home. So i have done all the project in my computer. I want to show the same project in my college, but i cant do it as the database is stored in my personal computer at home. Is there any ways i could transfer the database from my house to college like storing it in a pendrive. I used sqplus
oracle 9i to create the tables.

View 15 Replies View Related

Windows :: Oracle Developer 6i And 10g On Computer?

Dec 2, 2011

How I can install and use Oracle Developer 6i and Oracle Developer Suite 10g on the computer? It needed registry edition or is there any "official" way?

View 1 Replies View Related

SQL & PL/SQL :: How To Upload PDF Or JPG Files From Table To Computer

Feb 4, 2012

i have this table structure create table file (id number, media_file blob).how i upload pdf or jpg files from this table to computer for example to C:myfiles

View 3 Replies View Related

Windows :: Install Oracle R12 On Computer?

Sep 18, 2012

I need steps to install Oracle R12 on my Windows computer.

View 1 Replies View Related

Switch To Oracle DBA From Non Computer Science Background

Aug 16, 2010

I am on H1 visa and working as chemical engineer...but I am bored of this job... I wanted to switch to IT and particularly oracle dba..

How much is the risk for me as I am coming from non computer science background..there are various IT consulting companies who can provide training and do h1 transfer......currently (year 2010) the market for oracle is booming a lot...so I was thinking what can go wrong if I do this switch.

View 1 Replies View Related

Cannot Connect To Database From Remote Computer (ORA-12545)

Jul 19, 2013

I am trying to connect to a database located at my work from at home. I am running into the following issue (see command and error below):

ansichart@ansivm:~/src/perl$ sqlplus aspxdba/********@aspxp2 SQL*Plus: Release 11.2.0.3.0 Production on Thu Jul 18 21:15:09 2013 Copyright (c) 1982, 2011, Oracle. 

All rights reserved. ERROR:ORA-12545: Connect failed because target host or object does not exist-- Here is my tnsnames.ora file (I have the service_name censored out for privacy reasons):-

ansichart@ansivm:~/src/perl$ cat $ORACLE_HOME/network/admin/tnsnames.oraaspxp2 =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = orarac9-scan)(PORT = 1521))    )  (CONNECT_DATA =(SERVICE_NAME = *****************)(UR=A)    )  )-

I have verified that I can establish a TCP connection to this DB server on the port specified, using the same info from the TNSnames.ora file (see below):-

---ansichart@ansivm:~/src/perl$ nmap -sT -p 1521 orarac9-scan Starting Nmap 5.21 (URL.... ) at 2013-07-18 20:53 CDTNmap scan report for orarac9-scan (10.1.13.115)Host is up (0.0088s latency).PORT     STATE SERVICE1521/tcp open  oracle Nmap done: 1 IP address (1 host up) scanned in 0.09 secondsansichart@ansivm:~/src/perl$--

 I have another terminal opened up to a server at work and I can connect to the DB with sqlplus just fine.  I verified that the record for this database on the tnsnames.ora file is the same as it is at work. In conclusion, I can connect to the Database at work, but I cannot at home, even though I am using the same connection information and verified that port 1521 is accessible on this Database server from at home.  So why can't I establish a DB connection? 

View 6 Replies View Related

Server Administration :: Window Not Starting OracleserviceORCL On Local Computer?

Oct 29, 2013

i m facing an issue about TNS connectivity after some time i start my notebook and then sql butt it can not be login from any side like sql,pl/sql,forms or reports it shows same error ora-12203 tns unable to connect to the destination also my service of oracleserviceORCL can not start it shows an error like 'windows could not start the service on local computer '

View 4 Replies View Related

Server Utilities :: Copy Database On Another Computer Through Local Network

Feb 23, 2012

i've 0racle 9i database, i wanted to know the easiest way how to copy that database on another computer throw local network,

View 15 Replies View Related

Oracle 10g - Loading In Computer Select Statements Say No Data Found?

Jun 7, 2011

I am using oracle 10g i have a table on my computer that i made for a friend when i load it on their computer the select statements say no data found if i use select * from table name all the data will show

if a column name select * from table name where duty_date = '05-JAN-11'no data found

View 1 Replies View Related

Forms :: Exit Button Does Not Completely Exit?

Jul 20, 2011

I have received a service ticket from QA regarding one of the application forms does not close out even after the exit button is pressed. Instead, it goes to the previous record and continues to do so if there are multiple applications created and then exits at that point.

The end users are not liking that feature and I am unable to detect this error.. What kind of trigger should i apply and what do i write in this trigger.

View 7 Replies View Related

Backup & Recovery :: Store Backup To Another Computer Containing Same User And Service

Aug 9, 2011

I have created a backup by using rman. Now i want to store this backup to another computer containing same user and service.

View 2 Replies View Related

How To Remove Fragmentation

Sep 24, 2012

I have table of 60 gb(indexes 60gb ) and it is subject to fragmentation around 10gb .

I m going to remove fragmentation . As i know i have three options

1.expdp/impdp .
2.CTAS (create table ........as.......) with parallel option .
3.Moving table into another tablespace with parallel option .

I have 4 physical and 4 logical cores(total 8 cores) on server .

View 1 Replies View Related

SQL & PL/SQL :: Remove Only One Leading 0?

Jun 3, 2010

I receive source data with leading zeros. The Rules says: "If there is a leading 0 it has to be removed and data has to be shown starting with character 2".Here is my code I started with:

CREATE TABLE leading_0_test
(
col_1 VARCHAR2(10)
)

insert into leading_0_test values('00123')
select trim(leading'0' from COL_1),trim(leading'0' from substr(COL_1,1,1)),COL_1 from leading_0_test

The first trim removes all leading zeros. Therefore I tried to solve it with the substr, but without success.

View 7 Replies View Related

SQL & PL/SQL :: How To Remove Space

Oct 20, 2010

query string in such like that index.php?name=tejaspatel

i have table in record is available below

select * from emp where name = :name // it is query string parameter

emp
name
tejas patel

then how to match this record ?

View 8 Replies View Related

SQL Statement To Remove Extension

Oct 15, 2008

I have a file name field in my database that stores each file name with the extension .TXT and almost each file name is different.I would like to remove this extension from all of the file names without using the different file name each time I update. Is there any SQL statement that will allow me to do this? I am using Oracle.

View 1 Replies View Related

How To Remove Obsolete Values

Sep 7, 2012

In V$BACKUP_PIECE there are many backup pieces OBSOLETED and EXPIRED with fields: handle set to null and deleted to as "YES"

I ran the CROSSCHECK BACKUP and DELETE OBSOLETE and DELETE EXPIRED BACKUP, and they works.

But how can I remove these lines? Are they still important for anything?

View 3 Replies View Related

Install And Remove Oracle 10 G

May 26, 2008

I install oracle 10 g but I don't remember password . so I then remove oracle 10 g by select Universal Installer and click Deinstall and then reinstall but I can't reinstall because I don't remove/delete oracle_home I then delete folder in path C:Oracle and reinstall Question

1.in this remove oracle 10 g method true or wrong if wrong , How effect on my computer
2.why after reinstall my computer is very slow.

View 5 Replies View Related

SQL & PL/SQL :: How To Remove Duplicates From Collection

Mar 24, 2011

remove duplicates from my collection(table type).Or an alternate solution for my issue is get clean data into my collection which i am not able to get to either.

Object creation

create table testingtype_table(ordernumber number,org_id number , company_name varchar2(10))
insert into testingtype_table values (1124,2424,'cbaaa');
insert into testingtype_table values (1124,2424,'cbaaa');

create or replace type testingtype_obj as object (ordernumber number,org_id number , company_name varchar2(10));
create or replace type testingtype_tab as table of testingtype_obj;

Code Block
declare
l_testingtype_tab testingtype_tab := testingtype_tab();
begin
select distinct testingtype_obj(ordernumber
,org_id
,company_name)
bulk collect into l_testingtype_tab
from testingtype_table;
end;

If only i can get a way to bulk collect only distinct values into the table type that will just do great but when i try the above (with distinct highlighted in red) it throws an error

ORA-22950: cannot ORDER objects without MAP or ORDER method

View 4 Replies View Related

SQL & PL/SQL :: Remove String Duplicates

Oct 11, 2013

Removing duplicates from a string that contains years and "-".

Example: 1988-1997-2000-2013-1998-1965-1997-1899

I know this can be done in regular expressions but have no experience in this subject.

select REGEXP_REPLACE(.....) from dual;

View 16 Replies View Related

SQL & PL/SQL :: Remove Repeating Duplicates

Aug 3, 2011

i have two tables

Quote:
Table has following data.

id indicator
---------------
1 A
2 A
3 A

Quote:
Table2 has

id indicator
---------------
1 X
1 X
2 X
3 X

I would like to have following output ( Am running query on Toad)

t1_id t1_indicator t2_id t2_indicator
---------------------------------------------
1 A 1 X
1 X
2 A 2 X
3 A 3 X

View 4 Replies View Related

SQL & PL/SQL :: How To Remove Special Characters

Mar 22, 2013

I need to removed special characters (!, ", #, $, %, &, /, () from a string, i have a table with sll this special characters and words that i have to remove from the string.

How can i do that ?

i have a string with |R!$#&2-_D%2 and i want to get R2-D2

SELECT '|R!$#&2-_D%2' as Original, 'R2-D2' as Correct
FROM DUAL

View 5 Replies View Related

Forms :: Remove Duplicate Value

May 28, 2012

how can i get distinct records through this coding, when i add select distinct col1, col2, col3 from tablename where RECD_ON between :control. REC_ FROM and :control.REC_TO; in 1st qry after begin, this form not retrive any data from database, then how i get distinct rows through this coding. is there any option in property plattee to get distinct rows.

declare
qry varchar2(5000);
n number;
alert number;
Begin
[code]....

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved