While installing datavault on 11g database, getting error in between the process. Error is as below -
ORA-01031: insufficient privileges
ORA-06512: at "DVSYS.DBMS_MACADM" line 1740
ORA-06512: at line 1
how to rectify the problem.
I used the below link for configuring database vault on existing database.{URL]////
I installed oracle database 10g on my laptop, it installed successfully. I see sql plus in my program, how will i get login details for my database?
View 6 Replies View RelatedI am setting up a conversion server for upgrading an application database to a later version - the database is hosted on 11g but the vendor provided ETL tool only supports the Oracle 10g client. Is there a specific order so the install will work on the initial install. I'm installing Oracle 11g R1 (11.1 no patches) and 10g (10.1.0.4 after patching) 32Bit on a WIN2K3 SP2 Server. I've done this install before but have had to play with the path order to get it to work.
View 2 Replies View Relatedi installed oracle 10g dev suite do i still need to install the db 10g? i tried installing db10g first then the dev suite. On the db 10g i can connect via sqlplus. while i cannot connect on the dev suite, which has a 'sqlplus' too.
i am trying the hr:hr credentials, also tried sys as sysdba it gives me tns protocol adapter error (12560)
i tried to replace the tnsnames.ora of the devsuite with the tnsnames.ora of db10g still didn't work. i also set up the ORACLE_HOME to the db 10g's folder
D:ProgramsOracleproduct10.2.0db_1
why does the devsuite has its own tnsnames.ora. does it have some db server of its own? if it has do i still need to install db 10g?
I am installing RAC on my Laptop using VM ware workstation . I have created two linux machines on VM ware with 1 gb merory on each machine . I installed 10.2.0.1 clusterware successfully but when i am installing 10.2.0.1 database binaries my machine reboot every time .
View 3 Replies View RelatedMy VNC Hangs after completing all the steps in dbca while installing 11.2.0.3.0 after giving finish button to install database.
Completed All software installation.
Red Hat version: Red Hat Enterprise Linux Server release 6.2 (Santiago)
Linux xxxxxxx.xxxxx.net 2.6.32-220.el6.x86_64 #1 SMP Wed Dec 7 10:41:06 EST 2011 x86_64 x86_64 x86_64 GNU/Linux
Error occurred, While installing the agent in 11g database.
Error is listed below
[oracle@grid agent]$./agentDeploy.sh AGENT_BASE_DIR=/ebiz/oracle RESPONSE_FILE= agent.rsp
AGENT_BASE_DIR=/ebiz/oracle
Validating the OMS_HOST & EM_UPLOAD_PORT
Executing command : /ebiz/oracle/core/12.1.0.1.0/jdk/bin/java -classpath /ebiz/o
[code]./..
Executing agent install prereqs... Executing command: /ebiz/oracle/core/12.1.0.1.0/oui/bin/runInstaller -ignoreSys rereqs -prereqchecker -silent -ignoreSysPrereqs -waitForCompletion -prereqlogl c /ebiz/oracle/core/12.1.0.1.0/cfgtoollogs/agentDeploy -entryPoint oracle.sysma .top.agent_Complete -detailedExitCodes PREREQ_CONFIG_LOCATION=/ebiz/oracle/core 12.1.0.1.0/prereqs -J-DORACLE_HOSTNAME=grid.4iapps.com -J-D
[code]...
i am trying to install Oracle 10.10.2.0 on Windows Server 2003 standard x64 Edition Service Pack, but when i try to run the installer or open DVD it gives me below error.
"The image file D: is Valid, but is for a machine type other than the current machine."
I have xml data in one oracle table as records. I want to get the node name from each record (Next node of rowset and row). Total no.of records in oracle table is 15465. By using for loop i have try to get this but got the following error.
code is...
1 CREATE OR REPLACE PROCEDURE DDI_TEST.SCHEMA_IMPORT9
2 AUTHID CURRENT_USER
3 AS
4 V_Xml XMLTYPE;
5 V_Xml_Ind XMLTYPE;
6 V_Node VARCHAR2 (50);
7 V_Cnt NUMBER := 1;
[code]....
ERROR is..
ORA-31186: Document contains too many nodes
ORA-06512: at "SYS.XMLTYPE", line 111
ORA-06512: at "DDI_TEST.SCHEMA_IMPORT8", line 18
ORA-06512: at line 1
Even i used one more 'for loop' (at line 18 )to get additional nodes, same thing happens.
I've tried to install Oracle 10gR2 (10.2.0.4.0) on Windows server 2008 (64 bit). I just click on installer and a message appears:
Checking Operating system version: must be 5.0,5.1,5.2 or 6.0
Actual 6.1
FAILED <<<<
Exiting Oracle Universal Installer
Press any key to Exit.
But i do a lot of work-arounds to make sure the installation does not make corrupt my OracleAgent,OracleService and OracleDataGatherer. If i just let the installation do its thing i have problems with my libraries, and can't start anything.
The errors are : Procedure entry point 'BlaBla' could not be located in the Dynamic Link library 'AnyName'.
I notice that i have 2 versions of the libraries in OracleHomeBIN (one version 8, one version 11). The programs that start the OracleAgent,Service and DataGatherer call the old libraries but expect to find values that can be found only in new libraries.
I have written a trigger as below:
CREATE OR REPLACE TRIGGER LOGONTRIG
AFTER LOGON ON DATABASE
DECLARE
v_temp NUMBER;
V_bypass_trg_flag VARCHAR2(1);
[code],...
This trigger got successfully compiled. and when am trying to connect to the db with other user its giving me error "ora-06512 : at dbms_session".When i grant dba privillage to that user am successfully able to login to db.
On the weekend, I ran the repair chained rows in Toad and compile invalid objects in Toad.I don't know this problem is associated with that job, it has no problem first day and today some problem was detected from customer side. It shows Ora-12516 and Ora-96512, I will attach package sql and error screen shot, could you interpret what is wrong with the Oracle?
I can post up screen shot cause I don't have right.It was Korean and if I translate to English, kind of "Server can't proceed - Ora-12516 TNS: listener can't find appropriate handler with protocol stack.
Ora-06512: "CWMED.PKG_MEDI_AS_TOCALL" line 226
Ora-06512: "CWMED.PKG_PDA_MEDI_AS" line 1765
Ora-06512: "line 1".
I ran the following PL/SQL Code & I am getting the following Error:
Drop table MODIFIEDTABLE
/
Commit
/
create table MODIFIEDTABLE(TABNAMES varchar2(100))
/
DECLARE
[code].....
RESULT:
Table dropped.
Commit complete.
Table created.
DECLARE
*
ERROR at line 1:
ORA-01735: invalid ALTER TABLE option
ORA-06512: at line 12
I am importing data from excel to database table with column mapping.I have created package with a procedure. I am calling this procedure from oracle forms 6i. while executing the package procedure,I am getting following error ora-00928 missing select keyword ora-06512 at" abcd.pk_ excel_ to_ db" line 26 i.e befor forms_ddl.there is no problem in code and my form gets compiled but at run time i am getting this error.I also want to check, array is populating with anything or not.
PACKAGE PK_EXCEL_TO_DB IS
TYPE tKeyValue IS RECORD (
CROUTE VARCHAR2(255),
VROUTE VARCHAR2(1000),
CTRNDATE VARCHAR2(255),
VTRNDATE VARCHAR2(1000),
CTTIME VARCHAR2(255),
VTTIME VARCHAR2(1000),
CTID VARCHAR2(255),
VTID VARCHAR2(1000));
TYPE tDataList IS TABLE OF tKeyValue
index by binary_integer;
[code].....
I am developing a 3-tier based website having Oracle 10g DB at back end. Firstly, i created a pl/sql stored procedure as:
create or replace procedure CheckLogin(u_name in varchar2, u_pwd in varchar2,is_admin in number) is
uname varchar2(30);
upwd varchar2(30);
begin
[code]...
Actually I am getting the following error while running my script.
Error:(Error): ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 9
Seems to be getting eror in the following line but not sure why its coming."select adary.dilution_strategy_seq.NEXTVAL into :dil_strat_seq_new from dual;"
Code snippet:
---------------------------------------------------------------
declare
dil_strat_seq_new NUMBER :=0;
disc_conc_seq_new NUMBER :=0;
disc_fold_seq_new NUMBER :=0;
begin
[code]...
We are getting the following error when trying to access a RESTful web service coming from Apex workspace 4.2.1 and Apex listener 2.1:
ORA-29273: HTTP request failed ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-29024: Certificate validation failure
In the Debug report, besides the above I also see:
error_backtrace: ORA-06512: at "SYS.UTL_HTTP", line 1130 ORA-06512: at "APEX_040200.WWV_FLOW_WEB_SERVICES", line 543 ORA-06512: at "APEX_040200.WWV_FLOW_WEB_SERVICES", line 1164 ORA-06512: at "APEX_040200.WWV_FLOW_PROCESS", line 396
We get that error whether we use https or http in the URI pointing to the web service. When I test the Web Service in Workspace RESTful service GUI, I get the data back. When I go build an application with a report calling the RESTful Web Service I get that error. Both the Application and the Workspace RESTful services are on the same Apex environment and even the same workspace.
What is odd is that I can actually put the URL of the web service into a browser and I get the data: (using the demo hr data in sample RESTful services.)IN browser-- [URL]
yields:
7839,KING,PRESIDENT,,1981-11-17T05:00:00Z,5000,,10 7698,BLAKE,MANAGER,7839,1981-05-01T04:00:00Z,2850,,30 7782,CLARK,MANAGER,7839,1981-06-09T04:00:00Z,2450,,10 7566,JONES,MANAGER,7839,1981-04-02T05:00:00Z,2975,,20 7788,SCOTT,ANALYST,7566,1982-12-09T05:00:00Z,3000,,20 7902,FORD,ANALYST,7566,1981-12-03T05:00:00Z,3000,,20 7369,SMITH,CLERK,7902,1980-12-17T05:00:00Z,800,,20 7499,ALLEN,SALESMAN,7698,1981-02-20T05:00:00Z,1600,300,30 7521,WARD,SALESMAN,7698,1981-02-22T05:00:00Z,1250,500,30 7654,MARTIN,SALESMAN,7698,1981-09-28T04:00:00Z,1250,1400,30 7844,TURNER,SALESMAN,7698,1981-09-08T04:00:00Z,1500,0,30 7876,ADAMS,CLERK,7788,1983-01-12T05:00:00Z,1100,,20 7900,JAMES,CLERK,7698,1981-12-03T05:00:00Z,950,,30 7934,MILLER,CLERK,7782,1982-01-23T05:00:00Z,1300,,10
what would be causing the Error above in our application?
In reviewing the above error, I think we are realizing that we have to have the Weblogic layer SSL cert (actually the CERT from our BigIP load balancer which also does our SSL termination) imported into the Oracle server wallet where Apex is installed. Am I correct?
regarding Database Hardening, i am new to this concept
View 2 Replies View Relatedi have created a database on my pc and i have given a password at the time of installation , after the installation it is accessed successfully by the given password , but i observed that when i gave anything in password then it is also accessed by it and i don't have any other database of this same name.
And when i access it through another system then it is accessed only by its original password not by any other password.
how can i secure my database from hacking by any one of these:
1-sql injections
2- DON(Danial Of service)
3- buffer overflow
4- listner hack
We have Employee table, there is a field name Employee_no. field size is 6.can we restrict some one not to increase or decrease the field size of Employee_no. even User has admin role.
is there any way to restrict admin user that he should not allow to enter the value of field more or less than 6 characters through Toad or SQL Plus 8.0.
------------------------------------------------------
for example
field: employee_no
feild_size: 6
field_type: Varchar2
When we enter Employee no A000001(7 digit) then database not allowed to update because its field size is 6 characters we want to restrict admin user in Toad or SQL Plus 8.0 because he is Toad and SQL Plus user.
Is there any setting on oracle that allows to disconnect users automatically and display a message to users such: "Try a new connection to the db in 30 minutes"?
View 7 Replies View RelatedWe currently hardcode the password inside our Java application to make the connection with the Database,this makes the password to be visible to all users who can read the application code. How can we encrypt the database password so we don't have to hardcode it into the application?
View 1 Replies View Relatedwhat sort of queries IT auditors run against the database? assist me wit these so that I can run them before hand in order to sort out any security vulnerabilities which we might potentially have prior to this being picked up by external auditors?
View 2 Replies View RelatedI am having one table Where,different country names are stored. while viewing data, I have to make sure that if country name having "USA" can only view its data. How can i do at DB level without passing where clause. Is Virtual Database in this case?
View 25 Replies View Relatedhow to encrypt 9i database-link passwords? In 10g when we browse the link it show **** but in 9i it shows the actual password.
View 5 Replies View Relatedquery to find the current user accessing the database
View 5 Replies View RelatedHow can I export FGA / row level security policies from one database to another? I have created a new version of my schools ERP database, with upgraded application software, and now need to get the policies from our current production system to the new one.
View 5 Replies View RelatedI'm checking the possibility to use Active Directory to log on the our Oracle databases. But only for dba's and developers, not application users. We use Oracle 10.2.0.4 (and soon 11g) As OS on the databaseserver we use AIX5L 5.3
Is it possible to implement Active Directory on databases running on AIX ? If it is possible, what must be done to get it to work, software ... etc ?