Mandatory To Create A Local System Administrator Account?
May 25, 2012Is it possible to install Oracle SOA 11 in a Windows2008R2 as a power user or it is mandatory to create a Local system administrator account?
View 2 Replies
ADVERTISEMENT
Sys Account Locked And System Account Is Already Deleted
Jun 5, 2013In 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 RelatedSQL & PL/SQL :: Create Table With Author Column Default Value As Administrator
May 25, 2013I am trying to write a script to create a table with the author column default value as "Administrator" I use this execute immediate statement1;
Why does it create the table successfully with ',AUTHOR VARCHAR2(30) DEFAULT 1' and NOT with ',AUTHOR VARCHAR2(30) DEFAULT Administrator' ?
I want to set the COLUMN DEFAULT have to "Administrator" when I create the table.
When I try character I get this error "ORA-00984: column not allowed here"
statement1:='CREATE table TEST_ID2'
||'(TEST_ID NUMBER(6)'
||',test_name VARCHAR2(40)'
||notnull||
',date_created DATE DEFAULT SYSDATE '
[code]....
Security :: See Who Or When Password Was Changed For SYS Or SYSTEM Account?
Nov 10, 2010Is there a way to see who or when password was changed for SYS or SYSTEM account?
View 4 Replies View RelatedSQL & PL/SQL :: Create Trigger On (account) Table?
Nov 23, 2008I 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));
SQL & PL/SQL :: Create Primary Key Using Local On Partitioned Table?
Mar 2, 2012I have to create primary key using local on a partitioned table.
Since the table is huge it has to be done parallel. Following stmt is giving error
alter table XYZ add CONSTRAINT PKN_XYZ PRIMARY KEY (ID,LogDtTm)
USING INDEX LOCAL parallel 25 INITRANS 5 TABLESPACE OLTP_IDX_TS ;
Real Application Clusters :: Listener Status Showing Local Virtual IP / But Not Local IP
Jan 19, 2013SNRCTL> stat LISTENER
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.1.0 - Production
Start Date 19-JAN-2013 00:50:10
Uptime 0 days 0 hr. 29 min. 51 sec
Trace Level off
Security ON: Local OS Authentication
[code]....
In every oracle documentation for e.g:11.2 Scan and Node TNS Listener Setup Examples [ID 1070607.1] we found the local listener status showing both local-ip and vip. Why is not showing in our case?
Create System Generated Values?
May 14, 2007Lets say you're making upa school database and you awnted to give the students each a unique student number generated by thesystem.
View 2 Replies View RelatedWindows :: Installation Process Trying To Create Database On System
Dec 7, 2010I'm trying to install Oracle10g in win7 Home premium. It is installing but problem is when installation process trying to create database on the system, a message is appearing which telling that ORA-12546:TNS:permission denied.
View 1 Replies View RelatedRAC & Failsafe :: Create Shared File System Between Two Desktop PC?
May 14, 2013We are setting RAC between two machines(Desktop PC connected wirth LAN ....have storage Local to them and no Shared storage..Only NFS).We have shared the mount point by NFS.We do not have any shared storage but we need to share the RAW files to setup the OCR and VOTING DISKS.
The problem is:
1. We need to keep the RAW devices for OCR and voting disk common to the machines (Desktop PC..both Linux OELU5). I am able to create the raw file systems but that is local to one machine. I am not able to understand how to share the raw devices between two machines.
2. Tried to use ISCSI utility but that did not work. (How_to_use_iSCSI_Targets_on_Linux)
Scenario : One Machine has 500 GB Storage. Second machine has 80 GB Storage. Made private and public networks(Used two Network cards in LAN). All are communicating.
Problem : Need to make the storage 300GB (Out of 500 GB) of Machine 1 as shared storage. How can we do that? (Do we need any virtual software...ex .. vmware for that?)
SQL & PL/SQL :: How To Check System Views When Create Table Privilege
Jan 4, 2013I'm new to oracle DB,i've been given access to Oracle as a user. when i try to create a table under my default schema i get the insufficient privileges error.
How do i check from the system views if i have create table privilege under my own schema?
Server Administration :: Create SPFILE - Failure In Processing System Parameters?
Oct 11, 2004I have a small problem with creating the SPFILE,
These are the commands i had issued :-
1. startup nomount
2. create SPFILE from PFILE ;
Then i got an error :-
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:ORACLEORA92DATABASEINITORCL.ORA'
Ever since this happened i am unable to connect to ORACLE under any schema !
I get the following error : -
SQL> conn scott/tiger
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Warning: You are no longer connected to ORACLE.
WHY DOES THIS HAPPEN AND HOW CAN I OVERCOME IT ?
Windows / .NET :: ODBC Administrator Has Stopped Working
Dec 8, 2012I installed the Oracle instant client version 10.2.0.3 and the corresponding ODBC driver. When I try to add a DSN in ODBC Manager using the Oracle driver, it crashes and I get this message:
"ODBC Administrator has stopped working"
"Windows is checking for a solution to the problem..."
Trying to isolate this problem, I ran odbcad32.exe under DependencyWalker and it worked correctly without crashing. According to the Dependency Walker FAQ, this can be due to a "buffer overrun, stray/bad/freed pointer, etc.". They have a switch to set SET NODEBUG_HEAP=1 to check for this. When I did this, it crashes insider DependencyWalker also.
Replication :: Sending Email To Administrator When Refresh Fails?
Apr 22, 2009I have a refresh group that will refresh several materialized views at 4:00am. Sometimes the job failed. We need to enter to the enterprise manager to check the status of the refresh group.
Our target is that notification email is sent to our email once the refresh job failed. I have found some software that can do that. However, we need to handle ourselves. I would like to ask whether we can do that using enterprise manager.
RAC/ASM Clusterware Installation :: Administrator Permission / Cannot Stop Services By Using Command
Aug 23, 2012We are having 10g 2Node RAC on Windows 2003. I cannot stop services by using command ""crsctl stop crs/ srvctl stop database "" without administrator permission through my OS user. Is it possible to stop the services without Administrator permission on OS level.? What kind of OS level permission need to access the ""crsctl/srvctl etc"".
View 6 Replies View RelatedForms :: Mandatory / LOV Prohibited Values
Apr 7, 2012I created a list of values for the purpose of showing what unit_codes are selectable for a student's course. Each selected value gets dumped into the text field on my form.
But i was wondering, is there a way to show what unit_codes(values) are mandatory? And is there a way to show which ones are prohibited depending on data inside the database?
Forms :: Enter Data In Mandatory Fields
Mar 29, 2011I developed a custom Form using Form Builder 6i. This Form has selection criteria (data to be entered in a couple of fields) and a "Find" Button, which queries the data (based on the selection criteria) and populates all fields on the Form.
This Form has a couple of "Required" fields in its search criteria section. When data is not populated in any of the Required fields and "Find" button is clicked upon, Form raises an exception and pops up a message indicating the user 'to enter data in mandatory fields'. However, this message keeps popping up and would not stop.
So, I'm not able to proceed with querying data on my custom Form. I had to kill the session and reconnect to front end to overcome this issue.
PL/SQL :: N.b-suppose Dname Is Not A Mandatory Column For Selection
Jun 20, 2012in one query i am selecting 3 columns from emp table
1)select ename,empno,dname from emp where ename='ABC'
in other query i am selecting 2 columns
2)select ename,empno from emp where ename='ABC'
my question is - if i added dname with the above two columns will it effect any performance of the query.
n.b-suppose dname is not a mandatory column for selection
Forms :: ORA-01009 / Missing Mandatory Parameter
Jun 5, 2011We have installed Quote:Forms Version 9.0.4.0.19 [32 Bit]in windows server 2008 64 bit.
Our sources are in this versionQuote:(Forms Version 9.0.4.0.19 [32 Bit]), and we cannot do a sudden change to latest version.
The database we installed is
Quote:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production
We installed it in compatibility mode. Now the database is connecting properly. When we try to connect forms, it is showing the following message
Quote:
ORA-00604:error occurred at recursive SQL level 1
ORA-01009:missing mandatory parameter
Which one I have to update..? Forms or Database..?
Windows :: Which User Is MANDATORY To Use When Installing Oracle Patches
Nov 22, 2010We have almost 400 production two-node RAC clusters in the environment I manage - all these sites have databases where the database name is exactly the same, so using Grid Control right now isn't in the cards (and yes - I am working on assigning them all a unique name ). We want to use IBM's BIGFIX to deploy patch 32 on top of 10.2.0.3 for Windows Itanium. BigFix runs as a user different from that used to install the Oracle software originally. There is nothing in the patch notes to suggest that you must use a certain Windows user to install the patch - so the question is, does it matter what Windows User I use as long as they are an 'Administrator' equivalent?
how do you perform mass updates/patches in your Windows server environments? I am looking for examples outside of Grid Control - which I know would work if only my predecessor didn't name these databases the same .
Application Express :: How To make Item Mandatory Dynamically
Oct 24, 2013How to make an item as a mandatory field dynamically with the change of another item in different regions
View 10 Replies View RelatedForms :: Make A Field As Mandatory At Current Record Level
May 27, 2010I have one requirement i.e i want to make a particular item as mandatory for the current record in the tabular form.
so i have written code as below:
DECLARE
lv_item item;
BEGIN
lv_item := FIND_ITEM ('XXMZ_DETAIL.QTY_ACT');
SET_ITEM_INSTANCE_PROPERTY (lv_item,
current_record,
required,
property_true);
END;
This code is not effecting qty field. If i write set_item_property built-in that item becomes mandatory.But it's not effecting at current record level.It's effecting block level.
So how can i make a field as mandatory at current record level?
Forms :: Difference Between System.current_item And System.cursor_item?
Apr 1, 2012We have system.current_item and system.cursor_item.....
both represent the same....
like this we have few other system variables also .....
what is the main difference between current_item and cursor_item?
CPU System Time (percentage) For Multi Core System?
Aug 21, 2012couple of questions about below parameters, do they measure single processor or avg usage across all processorss and cpus for example will i recieve alert if CPU system time goes above 95% for single processors? or not
CPU Idle Time (%)
CPU System Time (%)
CPU User Time (%)
Reports & Discoverer :: Privileges In Discoverer Administrator?
Nov 29, 2011We are using Discoverer 10g, apps mode EUL. I have assigned administrator privileges to System Administrator responsibility using EUL_US as well as SYSADMIN (re-did with SYSADMIN, just in case). I have 2 Business Areas in EUL and gave access to both of them to System Administrator responsibility and the userid TESTER (this user already has System Administrator responsibility assigned to it). But when I login to Administrator using TESTER and System Administrator, I don't see any business Areas available to select.
View 3 Replies View RelatedPL/SQL :: Tables Of Hr Account
Jun 1, 2013here 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).
Read Only Access Account For OEM?
Jun 3, 2013What 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.
SQL & PL/SQL :: First Created Contact To Account?
Jun 3, 2011I'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.
SQL & PL/SQL :: Display All Account Code
Dec 8, 2012I 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
Get AccountItems That Has Max Revenue For Each Account
Aug 22, 2010I 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.