Running Script Utlpwdmg Sql In Oracle 10g

May 7, 2012

I am trying to enable password complexity in Oracle 10g by using the utlpwdmg.sql file. When I manually run this using SQL plus, I get the following result

Function created

Alter Profile Default Limit

Error at line 1
ORA-07442: function VERIFY_FUNCTION notnfound

View 2 Replies


ADVERTISEMENT

Running Sql Plus Without Oracle DB

Jun 6, 2012

I have installed an Express edition of Oracle 11 database on one host (Windows 7) and want to access to from another host (Backtrack Linux based on Debian) from SQL*PLUS Instant client.

While I managed to resolve multiple issues with shared libraries, I am still not able to run the sqlplus command as Oracle. I get the following errors:

oracle@evil:~/instantclient$ sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

I followed the installation manual by Oracle and also created Oracle user with 2 env. variables set to:

LD_LIBRARY_PATH=/opt/Oracle/instantclient/lib
ORACLE_HOME=/opt/Oracle

Note that I only installed SQPLUS client on Linux and there is no DB running. The version of sqlplus is 11.2.0.3.0

On different forums people advised to set other variables according to the DB installed but I have none. All I want is to run sqlplus with the IP address, SID, port and username. Is it feasible to have only SQL*PLUS client installed .

View 1 Replies View Related

Oracle EM Not Running Instance?

Nov 1, 2010

I have Oracle 11g R2 (11.2.0.1) with Oracle EM running on Solaris 10 with ZFS.When I start OEM it comes up and tells me that the listener is running but that the DB instance is down and agents are down.I know that the instance is up because I can start it manually.

Each time I start emctl, lsnrctl and DB manually everything starts running but OEM returns a failure for the DB. long as the display shows the DB not running OEM won't allow me to work in it.Instead of getting the login page I get the Database Control Page stating that "Enterprise Manager is not able to connect to the Database instance."I have tried the various emca -config dbcontrol db -repos drop and recreate but no luck.

Is there a way to uninstall/reinstall without dropping the DB?Are there control/configuration files I may hack to tell OEM the correct information?

View 3 Replies View Related

Running STATSPACK In Oracle 10g?

Feb 18, 2013

I am using oralce 10g database,because of performance hit in my database in want to generate AWR and STATSPACK reports.

I have already generated AWR report by running awrrpt.sql script.

I just wanted to know the steps to run STATSPACK reports.Will it create the same file as AWR does. Will i get much advantage after running STATSPACK reports than AWR.

View 8 Replies View Related

Oracle Performance Running On Sun Niagara Processors

Aug 25, 2008

I am looking for information on oracle performance on Niagara processors (T1000/T2000).

Does oracle benefits from the Niagara architecture(Multi threaded)? Do we see any improvements or delays in DMLs?

View 2 Replies View Related

ORA-12154 Running 32 Bit Oracle Software 0n 64 Bit Windows?

Oct 7, 2011

There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.

Since all the 32 applications will have the path C:\Program Files (x86) on 64 bit windows, The PATH variable doesnt recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client.

Oracle Client: 10.2.0.3 32 bit

Windows OS: Windows server 2008 R2 64 bit

I have referred the below document from the metalink(which states that the bug is fixed in 10.2.0.3 client).

ORA-12154 or ORA-6413 Running 32-bit Oracle Software on 64-bit Windows OS [ID 334528.1]

View 1 Replies View Related

Forms :: Running Oracle Database 10g On Windows 7

Nov 12, 2009

I was install windows 7 on my computer,oracle database10g and forms 10g installed successfully. I Cannot run forms on the browsers , how i can run my programs

View 9 Replies View Related

Server Administration :: Why Oracle Scheduler Is Not Running

May 14, 2013

Why Oracle shceduler is not running.What could be the cause.

CREATE TABLE dept1 AS SELECT * FROM dept;
CREATE OR REPLACE
procedure update_record(p_deptno number)is
BEGIN
insert into dept1 values(p_deptno,'xxx','xxx');
end;

[code]....

View 15 Replies View Related

Oracle 11.2.0.2.0 Running On Microsoft 2008 Cluster

Apr 8, 2013

Is Oracle certified Oracle 11.2.0.2.0 to run under a Microsoft 2008 Cluster ?

View 6 Replies View Related

Forms :: Running Oracle Report Through 6i And Validating Between Two Dates

Feb 16, 2010

I want to call a report through forms 6i and i want to send a parameter from forms6i to report 6i. in which i want to take records between two dates.

View 26 Replies View Related

SQL & PL/SQL :: Version Of Oracle And JDBC Running On A Remote Database?

Jul 28, 2013

How to know the version of Oracle and JDBC of remote databases that is accessing my database through DBLInk.

For example I have a database A , B database is using my database Through a dblink.Now I want to know the version of oracle and jdbc which working on B.

View 4 Replies View Related

Forms :: Running Form On Oracle Developer Suite 10g

Jul 2, 2011

i am new and developing my first oracle form.but when i am running this form.it's not running,i have installed already jinit.exe setup.Is this necessary internet connection for running forms.port no. is 8890.

View 20 Replies View Related

Installation :: Linux OS Suited For Running Oracle 11g Smoothly

Sep 19, 2013

What are the free linux OS's that are suited for running Oracle 11g smoothly? 

View 17 Replies View Related

Efficient Way To Connect SQL Server From Oracle Which Is Running On HP-UNIX

Mar 8, 2011

I am trying to Push the data from Oracle which is running in HP-UNIX to SQL Server. But don't know the efficient way to connect the SQL server from oracle which is running on HP-UNIX.I have heard about oracle Heterogeneous Connectivity but don't know exactly how to implement it in Unix environment.

View 1 Replies View Related

Cannot Connect To Oracle Running Under A Virtual-PC XP Mode Guest

Oct 27, 2012

Host: Win7

Guest: Using Virtual PC on Win7, created a VM using XP-Mode. Installed Oracle and everything on it. I can connect to the Oracle from within the guest env using sqlplus. Listener is also running, checked with 'lsnrctl status"

Guest and Host can ping (network) each other. I installed the guest using the Microsoft Loopback Adapter. Disabled the firewall on the guest OS before the host ping could work.

So ping works both ways from guest to host and host to guest. tnsping from host fails says "no listener". When I did a "telnet 192.168.x.x 1521" from host it said could not open connection on port 1521.

How do you open port 1521 on the guest OS to traffic from the host OS?

View 2 Replies View Related

Windows :: ORA-12154 - Running 32 Bit Oracle Software On Server 2008 64 Bit

Oct 6, 2011

There is an issue with the 32 bit Oracle client on 64 bit windows where it cannot connect to the database throwing the error ORA-12154: TNS:could not resolve the connect identifier specified.

Since all the 32 applications will have the path C:Program Files (x86) on 64 bit windows, The PATH variable doesn't recognise (). This issue was there in the previous versions of Oracle Client. But the bug has been fixed in Oracle 10.2.0.3 32 bit client. Still the user is facing the same issue.

Oracle Client: 10.2.0.3 32 bit
Windows OS: Windows server 2008 R2 64 bit

I have referred document [ID 334528.1] from the metalink(which states that the bug is fixed in 10.2.0.3 client).

View 4 Replies View Related

Server Administration :: Creating / Running Jobs In Oracle 9i For Solaris

Sep 5, 2005

How to

1) to define a job in oracle9i for solaris
2) to schedule this job

Remember i have prior experience deploying jobs at windows platform but when i try it on (9i for ) solaris, the script does not work as it does not accept a submit job request.

View 4 Replies View Related

Instance Of Oracle Enterprise Manager 10g Database Control Already Running

Jun 4, 2012

I'm have in Oracle version Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production:

while enter in a command

$emctl status dbconsole

output comes:

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Oracle Enterprise Manager 10g is running.
----------------------------------------------------------------------------------
$emctl stop dbconsole

output comes:

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
Stopping Oracle Enterprise Manager 10g Database Control ...
-----------------------------------------------------------------------------------
$emctl start dbconsole

output comes:

Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0
Copyright © 1996, 2005 Oracle Corporation. All rights reserved.
http://localhost.localdomain:1158/em/conso...boutApplication
- An instance of Oracle Enterprise Manager 10g Database Control is already running.
-----------------------------------------------------------------------------------

View 1 Replies View Related

Forms :: Error While Running Oracle Look And Feel Template Form

Jan 5, 2012

I am trying to setup oracle look and feel project on my local machine. For that i upgraded forms to 10.1.2.3 then i also applied path no 9593176 (But not yet performed steps related to jacob and webutil).

Problem : When i run Oracle look and feel template form it comes up with following error.

Forms Applet version is : 10.1.2.3
Exception in thread "thread applet-oracle.forms.engine.Main-1" java.lang.NoSuchMethodError: oracle.forms.handler.IHandler.getApplet()Ljava/applet/Applet;
at oracle.forms.fd.DrawLAF.init(DrawLAF.java:285)
at oracle.forms.handler.UICommon.instantiate(Unknown Source)
at oracle.forms.handler.UICommon.onCreate(Unknown Source)
at oracle.forms.handler.JavaContainer.onCreate(Unknown Source)
[code]..........

View 1 Replies View Related

How To Create Central Inventory For Oracle 11g Running On Windows Server

Dec 26, 2012

--- Current Oracle Inventory pointing to the location of C:program FilesOracleInventory.

We are plannig to creat a central inventory for all Oralcle installations into to C:oraagentorainventory.

View 3 Replies View Related

Networking And Gateways :: Running DML Statement On Oracle Transparent Gateway For SQL Server?

Dec 5, 2011

how can i run dml statement on the oracle transparent gateway for sql server ,such as insert ,update,delete.

View 4 Replies View Related

Security :: Active Directory Authentication For Oracle 10g Database Running On Solaris?

Jul 25, 2011

I have oracle 10g up and running on Solaris 10, from windows I would like to connect to sql plus through windows authentication, for that I have already made sure that remote_auth = true and have created user in oracle with OPS$. But still I cannot connect.

I have the same setup but with oracle on windows server, the os authentication from windows clients works just fine.

does oracle 10g on solaris 10 supports windows os authentication?

View 4 Replies View Related

Running Root.sh More Than Once

Aug 10, 2007

I am trying to correct NMO NOT SETUID-ROOT (UNIX-ONLY) error. On production database (9..7). Googlng this error - it says to run root.sh as root. should this be run in /usr/local/bin. which is the default location.

I don't believe that there would be any problems - but would like some confirmation -to be safe.

View 5 Replies View Related

SQL & PL/SQL :: Running Total SUM (Amt) Over?

Apr 21, 2012

My example: I'm given an Allowance throughout the week. It happens to be 10 dollars but it can vary from day to day.I can create a running total with SUM(Amt) Over etc...This is the CUMUL column in the example below.

On certain days I've spent different percentages of the allowance. (The SPENT Column which is a field in the database)I can't manage to create the AMTLEFT column in the example below.The AmtLeft column seems to be a kind of running total that 'refers to itself' so this is where I'm stumped.

Week,Day,Amt,Cumul,Spent,AmtLeft
1,Mon,10,10,0%,10
1,Tue,10,20,50%,10
1,Wed,10,30,0%,20
1,Thu,10,40,0%,30

[code]...

My imaginary SQL would look something like at this point (if I have it right):

SELECT Week, Day, Amt, Sum(Amt) Over (Partition By Week, Order By Day) AS Cumul, Spent FROM AllowancesTable

How to get the last column AmtLeft?

View 14 Replies View Related

SQL & PL/SQL :: Know If Procedure Is Running?

Jul 28, 2010

My problem is that i don't want to execute a procedure from my scheduler if the previous execute didn't finished. Is there a manage view or table that provide the procedure state?

View 15 Replies View Related

Find Out What SQL Statements Currently Running

Feb 26, 2009

From database server, I need to monitor the details about the sql statements which are being currenlt running in client machines.

I tried with V_$SQLTEXT view where I can only see the SQL statements, hash value,address,SQL_id. but I'm not able to get the user name,name the client machine .

find out these details?.Which Data Dictionary i need to use ?.

View 2 Replies View Related

Procedures Are Not Running Paralleled?

Mar 17, 2011

I have a job that runs two procedure parallely . The code is as follows:

DECLARE
jobno1 NUMBER;
jobno2 NUMBER;
flag NUMBER;
BEGIN
dbms_job.submit(jobno1,'pc;', next_date=>SYSDATE);
dbms_job.submit(jobno2, 'pc2;', next_date=>SYSDATE);

[code]....

And the stored procedure (in SQL File) is as follows:

procedure pc:

create or replace procedure pc
as
begin
for idx in 1..100 loop
dbms_output.put_line(idx);
end loop;
end;
/

procedure pc2:

create or replace procedure pc2
as
begin
for idx in 1..1000 loop
dbms_output.put_line(idx);
end loop;
end;
/

However, when I execute the job , I get the following output:

1
2
3
.
.
.
.
100

[code]....

Which indicates the job 1 got executed 1st and then job2. But this is not what I want.

View 4 Replies View Related

11.2.0.3 Database Running On AIX - Memory?

Nov 12, 2012

I have a 11.2.0.3 database runing on AIX. The instance hangs and crashes due to memory usage issues. I checked the alert log of the database and this is what i see:

WARNING: Heavy swapping observed on system in last 5 mins.pct of memory swapped in [11.85%] pct of memory swapped out [3.45%]. make sure there is no memory pressure and the SGA and PGA are configured correctly. Look at DBRM trace file for more details.i also see the following in the alert.log:

Errors in file
/opt/oracle/diag/rdbms/iut3px1/iut3px1/trace/iut3px1_cjq0_55312404.trc:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 3896 bytes of shared memory ("shared pool","select audit$,options from p...","sga heap(1,0)","kglsim object batch")

The file contents of iut3px1_cjq0_55312404.trc are:

====================
Process State Object
====================
----------------------------------------
SO: 0x70000007b97de70, type: 2, owner: 0x0, flag: INIT/-/-/0x00 if: 0x3 c: 0x3
proc=0x70000007b97de70, name=process, file=ksu.h LINE:12616 ID:, pg=0

[code]...

View 3 Replies View Related

SQL & PL/SQL :: How To Calculate Running Percentage

Mar 13, 2013

I want to calculate the running percentage. sample data is as below.

CREATE TABLE prod
(
code VARCHAR2(8),
name VARCHAR2(30),
stdate DATE,
itons NUMBER(7,3),
rtons NUMBER(7,3)

[code]....

Required Output is

CODE NAME STDATE ITONS RTONS %age
-------- ------------------------------ --------- ---------- ---------- -------
0-01-001 SEEDS 17-JUL-12 193.155 0
1-01-001 OIL 17-JUL-12 0 81.906 42.404
1-02-001 MEAL 17-JUL-12 0 104.304 54.000
1-03-001 DURT OIL 17-JUL-12 0 1.242 0.643
2-01-001 WASTE 17-JUL-12 0 5.703 2.953

[code]....

Percentage will be calculated as rtons of code not having first digit 0 devided by itons having having code 0 result multiply 100 for the same date code wise e.g. For dated 17-jul-13 meal percentage will be calculated as round((104.304/193.155)*100,3)=54.000

View 6 Replies View Related

ERP Is Running Slow After Cloning

Apr 22, 2012

We have done cloning of our ORACLE APPLICATION(11i),after that performance of ERP is getting slow (like fetching of data). What we can do to increase the performance.

View 1 Replies View Related







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