SQL & PL/SQL :: First Created Contact To Account?

Jun 3, 2011

I'm trying to write a query where I grab the first contact created of an account. I've tried everything but I can't get this to work.

Here is the normal query we used to get the contacts from an account:

select
con.row_id,
con.created,
con.fst_name,
con.last_name,
con.email_addr
from s_contact con
join s_org_ext org
on org.row_id = con.pr_dept_ou_id

I've tried different variation of aggregate functions, but its not working.

View 5 Replies


ADVERTISEMENT

Sys Account Locked And System Account Is Already Deleted

Jun 5, 2013

In event of sys account locked and system account is already deleted also no other user is having dba privilege, how to unlock the sys user??

View 5 Replies View Related

Server Administration :: Find When Database Role Created And Who Has Created?

Feb 14, 2013

Is there a way to find when was a database role created and who has created?

View 5 Replies View Related

REFRESH GROUP Is Automatically Created When A Materialized View Is Created?

Aug 17, 2012

tell me if a REFRESH GROUP is automatically created when a materialized view is created?

View 3 Replies View Related

ORA-03135 - Connection Lost Contact

May 4, 2013

Yesterday everethig was fine and I were able to connect / as sysdba

When í try it today sqlplus freez and I have to kill that session from other terminal.
When I try to connect as normal user, I am getting this error.

normal user
[oracle@oracle admin]$ sqlplus surad@evidence

SQL*Plus: Release 11.1.0.7.0 - Production on Sat May 4 15:46:44 2013

Copyright (c) 1982, 2008, Oracle. All rights reserved.

Enter password:
ERROR:
ORA-03135: connection lost contact
Process ID: 0
Session ID: 0 Serial number: 0

---
sysdba

[oracle@oracle admin]$ sqlplus /nolog

SQL*Plus: Release 11.1.0.7.0 - Production on Sat May 4 16:01:09 2013

Copyright (c) 1982, 2008, Oracle. All rights reserved.

SQL> connect / as sysdba
--> There are waiting .... solution is to kill that session.
----
[oracle@oracle admin]$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.7.0 - Production on Sat May 4 16:04:06 2013

Copyright (c) 1982, 2008, Oracle. All rights reserved.
--> There are waiting .... solution is to kill that session.

View 17 Replies View Related

ORA-03135 Connection Lost Contact Errors

Aug 15, 2013

Since our upgrade from 10.2.0.4 to 11.2.0.3, we are experiencing occaisional overnight job failures throwing the ORA-03135 Connection lost contact errors. It doesn't happen often, but every once in a while. Even so, it is bugging me because I can't find anything wrong!

We have a dual server setup, with one IA64 HPUX 11.31 server hosting the database, and a second IA64 HP-UX 11.31 running all of the application code. I'm seeing errors in the Alert log that is pointing me to a specific cjq0 trace file, and the contents of that trace file are pretty much as follows:

*** 2013-08-15 02:05:45.541
Waited for process J001 to initialize for 107 seconds
*** 2013-08-15 02:05:45.544
Process diagnostic dump for J001, OS id=19302
-------------------------------------------------------------------------------
os thread scheduling delay history: (sampling every 1.000000 secs)
0.000000 secs at [ 02:05:45 ]
NOTE: scheduling delay has not been sampled for 0.312200 secs 0.000000 secs from [ 02:05:41 - 02:05:46 ], 5 sec avg
0.000000 secs from [ 02:04:46 - 02:05:46 ], 1 min avg
0.000031 secs from [ 02:00:45 - 02:05:46 ], 5 min avg
loadavg : 0.31 0.17 0.09
[code]....

There were jobs that completed successfully just prior to this failure, and subsequent jobs ran successfully as well. I'm stumped - not sure what's going on here. I have reviewed a lot of posts relative to the ORA-03135, and followed as many of the recommendations as I can, but I'm still seeing this errors periodically. Their frequency has not changed since I started applying these changes, so I know I haven't stumbled on the cause as yet.

View 1 Replies View Related

ORA-03135 / Connection Lost Contact Table Name

Dec 28, 2012

I am using a database link from between oracle 10g enterprise & oracle 10g express edition on window based system.

We are getting below given error at one client system and others clients system is working fine..

ORA-02068: following server error from dblink name

ORA-03135: connection lost contact table name <tablename>

View 9 Replies View Related

Server Administration :: ORA-03135 - Connection Lost Contact

Oct 11, 2010

My application is using "Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production" and Oracle 11g client v11.1.0.6.0.My application server runs continuously and checks for new requests. But problem occurs when I do not send any request to my server for 40-45 minutes i.e. server is idle or doing nothing except checking new incoming requests for those 40-45 minutes. After that if I try to connect my server by sending some request, it shows following error message and my server crashes:

Message String: ORA-03135: connection lost contact
Process ID: 7586034
Session ID: 61

View 9 Replies View Related

ORA-12547 / TNS / Lost Contact / Access Oracle Database 11.2.0.3

Dec 7, 2012

I installed a server on a Linux server Oracle11.2.0.3 5.8 from 64 bits.The user who installed the Oracle software is "oracle" and belongs to oinstall and dba groups.

ID ORACLE
uid=503(oracle) gid=504(oinstall) groups=504(oinstall),505(dba),506(cvargas) context=user_u:system_r:unconfined_t

The software has been installed correctly and have been able to create two databases. As a requirement of the application, you must create an operating system user that launches processes.This user belongs to dba.But when trying to access Oracle via sqlplus gives this error:

-bash-3.2$ sqlplus davinci/xxxxxxx
SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 7 23:22:40 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
Enter user-name:

However, if you connect using a network descriptor works correctly.

SQLPLUS DAVINCI/xxxx@tns_alias

So there must be a problem with access to local resources.This user has the same profile file variable (. Bash_profile)

View 6 Replies View Related

Server Administration :: New Instance Not Starting / ORA-12547 / TNS / Lost Contact

Mar 29, 2011

I have successfully installed Oracle R12 on my machine but after rebooting I can not start.

This is what I did

/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addlnctl.sh start listener

/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start

You are running addbctl.sh version 120.1

Starting the database VIS ...

SQL*Plus: Release 11.1.0.7.0 - Production on Tue Mar 29 21:02:42 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
addbctl.sh: exiting with status 9
/d01/oracle/VIS/db/tech_st/11.1.0/appsutil/scripts/VIS_localhost/addbctl.sh start

[code]....

BTW I have not set $ORACLE_HOME, $ORACLE_BASE, $ORACLE_SID yet.

View 18 Replies View Related

SQL & PL/SQL :: Cursor Implement / Strings Of Data Concatenated Into One Sales Contact Record

Sep 23, 2013

how to write below query in pl/sql cursor. The help table has two associated tables, help_txt and help_id, which will have strings of data concatenated into one sales contact record. There are multiple lines of text per comment and multiple lines of resolution text at 40 characters per line. The key to the help_text table (id, date,seqno) is the main key to the help_txt table and help_id t table with a sequence added to each table

The formatted string will contain some text and variables with the comment lines (1-10 or more) concatenated first, followed by the resolution lines (1-10 or more). There will be multiple comment and multiple resolution lines. The Cust_Cmnt_Txt lines and the Resolved_Desc lines should be concatenated and formatted in the following string (% marks the variable string) :

'help taken ' %help.Taken_Dte 'received from the following source: ' %help.id. 'Remark Text: ' %help_text (where help_txt_Seq = 1) %help_text (where help_text_seq = 2-10 or more) 'Resolution: ' %help_id_Res_Txt.Resolved_Desc (where help_ID_Txt_Seq = 1) %help_ID_Res_Txt.Resolved_Desc (where help_id_Txt_Seq = 2-10 or more)

View 8 Replies View Related

PL/SQL :: Tables Of Hr Account

Jun 1, 2013

here is my current Oracle version:

select * from v$version where banner like 'Oracle%'

BANNER                                                                         
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production   
1 row selected.

My need is to pass test cases based on Oracle XE tables (hr account). tell me where to get the structure of mentioned tables and its data (without downloading and installing Oracle XE if possible).

View 1 Replies View Related

Read Only Access Account For OEM?

Jun 3, 2013

What privilege needs to give the user for ready only access for OEM for limited instances not all instances.

Purpose: our application dba team just want monitor the specific databases that why they asked to create read only access account for OEM for limited databases.

View 2 Replies View Related

SQL & PL/SQL :: Display All Account Code

Dec 8, 2012

I want to display all account Code but i required this account PFKHR01010101010001 to be fixed to have Credit_Amount.

My Structure is

Finance_TRansactions
------------------------------

D_No Char(12);
Account_Code Char(19);
D_Date Date;
DEbit_Amount Number;
Credit_Amount Number;
[code]...

ORA-01427: single-row subquery returns more than one row

View 5 Replies View Related

Get AccountItems That Has Max Revenue For Each Account

Aug 22, 2010

I been working on this for days but I just cannot get it working...I have 3 tables:

1- Account
2- AccountItems
3- AccountInfo

Account has many AccountItems and has only 1 AccountInfo.So the point is to get the Account tems that has the max revenue for each Account. The field for revenue is AccountItems.Revenue..So here's what I did

Select Account.Name, Account.Telno, AccountItems.Item, AccountInfo.FirstName, AccountInfo.LastName
where Account.ID = AccountItems.ID
AND AccountItems.ID = AccountInfo.ID
AND ????
From Account, AccountInfo, AccountItems;

This is where I'm stucked on...I don't know what to do in order to grab the AccountItems.Item that has the MAX AccountItems.Revenue.

View 2 Replies View Related

Oracle Linux Account

Oct 22, 2012

I have installed oracle enterprise linux 6.2 on my laptop, and I installed the database 11gR2 on it, know the user account I used to log in with (os level) is not accessible any more :

[URL].........

if I remove the account and recreate it does it will cause problems to the database?

View 5 Replies View Related

SQL & PL/SQL :: Hierarchical Query For Chart Of Account

Aug 19, 2013

I want Hierarchical Query..I have Table of chart of account

CREATE TABLE COA
(
ACCOUNT_CODE CHAR(19),
ACCOUNT_TITLE VARCHAR2(70),
ACC_TYPE Char(1),
PARENT_CODE CHAR(19)
)
[code]....

View 2 Replies View Related

Server Administration :: DBMS_JOB Using Sys Account

Jun 17, 2010

I have to change the execution of a job, I have the sys access.The job is in another user, say scott.how to use dbms_change using sys account to change the execution of a job in Scott user..

View 9 Replies View Related

Security :: Oracle Account Limitation

Oct 25, 2011

there is urge to limit account usability in oracle.

let's say i have request to create user HR1, and additional information is that this account should be available for using till 31-dec-2011. is there possibility to set this validity during creation?

View 1 Replies View Related

How User Xyz Account Expired Within A Month

Aug 22, 2013

Created user xyz on July 20,2013 with defualt profile (oracle version 11.2.0) and PASSWORD_LIFE_TIME is 180 for default profile. Immediate my friend have assigned new profile APSC to user xyz where profile APSC has PASSWORD_LIFE_TIME = UNLIMITED.

we surprised, user account has expired within a month. How user xyz account can expired within a month????

Note: User account status was open when account created and assigned to profile APSC.

View 4 Replies View Related

Temporarily Lock Account After So Many Bad Logins?

Jan 19, 2009

I'm not a DBA, nor do i play one on TV.

Is there a way to only temporarily lock an account after so many bad logins? I'm being told by my DBA that there is not, and I'm just shocked that Oracle wouldn't build in that functionality.

View 4 Replies View Related

SQL & PL/SQL :: Create Trigger On (account) Table?

Nov 23, 2008

I gave this a shot on my own, and failed, so I am putting the question to you:

I am looking to create a trigger on the "Account" table

CREATE TABLE Account(Acct_no number, BillAmt number, OpenDate Date, SSN number,
Primary Key (Acct_no),
Foreign Key(SSN) references ResponsibleParty(SSN));

which will update the BillAmt field whenever one of the account's respective records is inserted/updated/deleted from the following tables:

CREATE TABLE Plan(Plan_id number, Cost number, Minutes number,
primary key(Plan_id));
CREATE TABLE Feature(Feature_id number, Description varchar(20), Cost number,
primary key(Feature_id));

These tables are linked through the following table:

CREATE TABLE Phone_Line(MTN number, cStart Date, cEnd Date,
rDate Date, Status char, ESN number, Acct_no number, Plan_id number,
primary key(MTN),
foreign key(ESN) references Equiptment(ESN), foreign key( Acct_no) references Account(Acct_no),
foreign key(Plan_id) references Plan(Plan_id));

View 26 Replies View Related

User Account Will Be Locked In A Period Of One Day After

Sep 16, 2013

"ALTER PROFILE profile_name LIMITPASSWORD_LOCK_TIME 1"means the user account will be locked in a period of one day after FAILED_LOGIN_ATTEMPTS has gone over limit.How to set PASSWORD_LOCK_TIME less or more than one day (like not full days)?

View 2 Replies View Related

Expired Account Need To Open Without Password Reset?

Aug 14, 2013

Account XYZ has expired and we don't know the password of account xyz and don't want reset the password also. How can open account XYZ without change the password?

View 1 Replies View Related

Know User Account Locked Time In HH:MM:SS Format?

May 30, 2011

How we know a user account locked time in HH:MM:SS format ?

View 1 Replies View Related

Security :: User Account Locked Error

Oct 3, 2012

we have a prod application which use oracle database 11g as backend and .NET technology as front end . There is a user TESTUSER in database.

Issue is that we can login in to the application, but when we try to login in database through toad or Db visualizer then it gives an error of 'user account locked'.

View 5 Replies View Related

Security :: See Who Or When Password Was Changed For SYS Or SYSTEM Account?

Nov 10, 2010

Is there a way to see who or when password was changed for SYS or SYSTEM account?

View 4 Replies View Related

SQL & PL/SQL :: Hierarchical Query To Display Chart Of Account?

Apr 25, 2013

I want Hierarical query to display my Chart_Of_Account. I want to make a tree Form in 6i error i am getting is connect by nocycle prior account_code=parent_code
*
ERROR at line 4:
ORA-00920: invalid relational operator

Table

Create Table Chart_Of_Account (Account_Code Char(19), Account_Title varchar2(70), Parent_Code Char(19))
insert into Chart_Of_Account ('DGHOA01010101000001','TEST','DGHOA01010100000000')
insert into Chart_Of_Account ('DGHOA01010101000002','TEST1','DGHOA01010100000000')
insert into Chart_Of_Account ('DGHOA01010101000003','TEST2','DGHOA01010100000000')

select -1,level,account_code||' - '||ACCOUNT_Title,'NULL',to_char(ACCOUNT_CODE)
connect_by_iscycle from chart_of_account
start with Substr(account_code,13,7)='0000000'
connect by nocycle prior account_code=parent_code

View 3 Replies View Related

Database User Account Lock And Expire

Jun 28, 2012

I have altered an user account and set the account status as expired.When I tried to connect with that user, oracle prompted for changing password.

But, after I changed the password, I got an error message as ora-01017 invalid username/password logon denied password unchangedWhat is the cause and solution for it? I am using 11g database and 10g client.

View 15 Replies View Related

XE :: Oracle 10G Express Edition Account Locked

Aug 16, 2012

My Oracle 10G Expression Edition Account locked gets locked, where to raise the request to unlocking my account.as my user name:system

View 4 Replies View Related







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