Server Administration :: How To Find Out List Of DB_LINKS That Uses User Account In Database
Jun 6, 2011How to find out list of DB_LINKS that uses user account in database ?
View 9 Replies
ADVERTISEMENT
How To Find Length Of User Account Password In A Database
Jun 13, 2013how to find length of the user account password in a database?
View 1 Replies View RelatedServer Administration :: How To Find And Close Open Cursor List Without Restarting
May 28, 2013In my environment found maximum open cursor exceeds error. So how can I found the open cursor list and how can I close that cursor without restarting. Any SQL commands to close the open cursor.
View 4 Replies View RelatedDatabase User Account Lock And Expire
Jun 28, 2012I 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.
Application Express :: How To Connect As A Real Database Account User For Auditing
May 15, 2013For auditing, I need to insert the user, among other data, into different tables. The thing is, I have an application with DB account authentication, so a real database user is connected, when auditing, the user field inserted is "ANONYMOUS".
Apex 4.2
EPG
Oracle Enterprise Linux 5.5
Database 11.2 EE
Server Administration :: DBMS_JOB Using Sys Account
Jun 17, 2010I 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 RelatedServer Administration :: Unable To Find Server Process In Oracle Database For Specific Application / Client
Feb 13, 2013I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.
1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?
SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'
Server Administration :: Find Whether Database Link Is Being Used?
Jul 26, 2011I am having database A and database B and I am inserting into database b by selecting some records from database a using db link.Is there any way to find whether database link is being used?
View 6 Replies View RelatedServer Administration :: Connect 9i To 10g With Same Database And User?
Oct 19, 2012last two years i am using oracle 9i in windows 2003 server but now i installed oracle 10g on another server (PC) , i want to connect 9i to 10g with same database and user .
View 3 Replies View RelatedServer Administration :: Find Database Is Corrupted Or Crashed
Mar 3, 2012how will you find your db is Corrupted or crashed. how will u recover it.
View 2 Replies View RelatedServer Administration :: Find Out Active Schemas In 9i Oracle Database?
Dec 9, 2010findout and to fill up the excel which lists down the Database schemas and states whether they have in active / or not.
Active state may be determined whether it has been used for the last 3 months or so. The last updated time may be a good indicator of the same.
Server Administration :: To Find Out The Database Is Using Cost Based Analyzer
May 23, 2012How to find out the database is using Cost based analyzer?
Currently database is set to ALL_ROWS.
SQL> show parameter optimizer_mode
NAME TYPE VALUE
------------------------------------ ----------- -----------
optimizer_mode string ALL_ROWS
SQL>
SQL>
Server Administration :: Generate Statspack Report Without Perfstat Account?
Feb 7, 2013I have only select_catalog_role in my database.
Is it possible to generate statspack report without having access to perfstat account?
Server Administration :: Unable To Drop User Without Database Shutdown
Apr 19, 2013We are unable to drop user due to below error, how to drop the below user without shutdown the database.
SQL> drop user mvm_2010 cascade;
drop user mvm_2010 cascade
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-14452: attempt to create, alter or drop an index on temporary table already in use
No session was available for particular user.
Server Administration :: How To Find Out Number Of CPUs Allocated To Specific Database
Aug 1, 2011when we ran SELECT statement against CUBE, we got below wait event: resmgr: cpu quantum.Further, we checked below 2 parameters :
NAME VALUE
------------------------- --------------------------------------------------
resource_limit TRUE
resource_manager_plan SCHEDULER[0x12B943C]:DEFAULT_MAINTENANCE_PLAN
[code]....
It has been found that these sessions did not get enough CPU to process the request. how to find out how many CPU has been allocated to this database ?
> uname -a
Linux dukedmts03db02.corp.cox.com 2.6.18-128.1.16.0.1.el5 #1 SMP Tue Jun 30 16:48:30 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
how to analyze how much % of CPU being utilized for a specific session ?
Server Administration :: How To Create Best Profile For Huge User In Oracle Database
Mar 5, 2013how to create best profile for huge user in oracle database user which take lagre uga memory.
View 5 Replies View RelatedServer Administration :: Create / Drop User / Schema In Another Oracle Database Through Apex
Jul 7, 2012Through an Oracle Apex application I need to create/drop a user/schema in another Oracle database. i.e., create/drop user remotely using an Oracle Apex application.
View 12 Replies View RelatedSecurity :: Find A List Of Roles And Privileges In Database?
Feb 24, 2011How can I list all the roles and privileges of roles in Oracle? Can I get the details of the activities they perform?
View 12 Replies View RelatedNetworking And Gateways :: Find List Of Database Links?
Jul 2, 2011There is a user account called 'BALA' in my database.I want to find out the database links that uses this 'BALA' account.
View 2 Replies View RelatedServer Administration :: Externally Authenticated User Login Syntax As Proxy User?
Nov 15, 2010I created an externally authenticated user in database. And can login without password with below syntax.
SQL> connect / @TESTDB
Connected.
SQL> show user;
USER is "SCOTT"
This scott user has a proxy permission to another DBuser PROXY_USER. Previously I used to login using below syntax.
connect scott[proxy_user]/password_for_scott@TESTDB
So now, what syntax should be used for this "ExternallY Authenticated" user to login as a proxy user?
Find Youngest User In Database?
Feb 6, 2007How do you find the youngest user in a certain table
select a.illness_desc
from uma.pc_illness a, uma.pc_patient b, uma.pc_diagnosis c
where b.patient_no = c.patient_no and c.illness_code = a.illness_code
and b.age = '21';
i currently have this (it also needs to display their illness which i have done) but i can do only if i cheat and see what the youngest user is, so instead of b.age = 21 i need something that will search the database and find that youngest age
we are using SQL+
How User Xyz Account Expired Within A Month
Aug 22, 2013Created 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.
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 RelatedSecurity :: How To Find Current User In Database
Sep 22, 2011query to find the current user accessing the database
View 5 Replies View RelatedSecurity :: Find Out The User Access The Database?
Nov 8, 2011Is there a way to find out the user access the database?
View 1 Replies View RelatedServer Administration :: Find When Database Role Created And Who Has Created?
Feb 14, 2013Is there a way to find when was a database role created and who has created?
View 5 Replies View RelatedServer Administration :: Creating A View In User From Another User?
Nov 9, 2011I have a strange problem when creating a view in user from another user
I have a user called "Cash_tst"
its syntax creation is
-- Create the user
create user CASH_TST
identified by ""
default tablespace CASH
temporary tablespace TEMP
profile DEFAULT
quota unlimited on cash;
-- Grant/Revoke object privileges
grant connect to CASH_TST;
grant dba to CASH_TST;
grant resource to CASH_TST;
-- Grant/Revoke system privileges
grant create any view to CASH_TST;
grant unlimited tablespace to CASH_TST;
I want to create a view
CREATE VIEW TAMER
AS SELECT *
FROM [b]AROFL[/b].RA_CUSTOMER_TRX_LINES_ALL_BEFO
"AROFL" is another user on the same database
when try to create the view "tamer" i got message of
"insufficent privilege"
although i granted "create any view" to the user "cash_tst"
Know User Account Locked Time In HH:MM:SS Format?
May 30, 2011How we know a user account locked time in HH:MM:SS format ?
View 1 Replies View RelatedSecurity :: User Account Locked Error
Oct 3, 2012we 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'.
Security :: How To Find User And IP Address From Oracle Database
Jun 19, 2013Last week we have realized that a user who connects through SQL Developer(as nothing wrong found in application server logs) has made a serious change in the database which created a real mess. The user has done some mischief in some calculations by making some inserts and updates in some important tables in our production database.
How can I find which user or from which IP the change is made.