Windows :: Oracle 8i On XP System

May 12, 2002

i have installed oracle 8i on my windows xp system. it has not given me any problems during installation. i could log on to oracle and work on it without any problems. but when i restarted my system, my system has failed to start the oracle service, and i could no longer logon to sql * plus.

I've got messages 'oracle not available'. i've even tried to start the service from administrative tools-services, but of no use. then i created a new database and log on to sql* plus. but when i rebooted my system, the problem continued.

View 33 Replies


ADVERTISEMENT

Oracle 11g R2 On Windows 2008 R2 - Cannot Login As SYSTEM

May 31, 2013

I created an empty database using the DB Configuration Assistant, then imported a dump file provided by a client. I believe what happened is that all of the user passwords (for SYSTEM, SYSDBA, etc.) which I had created in the DB Config Assistant were overwritten during the import process as I can no longer log into the DB.

I have attempted logging into sqlplus using the /as sysdba swith while logged in to the server as a user in the ORA_DBA role, but I still get the ORA-01031: insufficient privileges message.

I am running Oracle 11g R2 on Windows 2008 R2.

View 4 Replies View Related

Clusterware :: Oracle Installation On Windows Operating System?

Jun 14, 2012

install oracle clusterware on Windows Operating system

View 4 Replies View Related

Windows :: Install Oracle 10g Release2 In 32bit Server System?

Aug 2, 2010

I need to install oracle 10g release2 in 32bit windows server system.

I also need to replicate whole database at more than 10 locations...i m just confused which windows server system should i install the database?

View 2 Replies View Related

Windows :: System Admin Log In Error

Feb 6, 2013

i want to log-in my local machine database as a system administrator , but it is giving an error:

C:Windowssystem32>sqlplus /@myprodb as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:18:15 2013

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

ERROR: ORA-01031: insufficient privileges

Enter user-name:

C:Windowssystem32>sqlplus /@myprodb as sysoper

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:19:28 2013

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

ERROR: ORA-01031: insufficient privileges

Enter user-name:

but

C:Windowssystem32>sqlplus sys@myprodb as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed Feb 6 19:20:45 2013

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

Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

and i have run cmd as administrator

View 20 Replies View Related

Windows :: System Integration CONSULTANT?

Jul 27, 2011

I need information to recommend something to the Client:Existing Application Environment is:

OS: Windows XP Server as well as Client
Database: Oracle 9i Server on XP
Oracle Client : Oracle 9i

They want to move to Windows 7 in ClientWhat all they need to upgrade if required...?Does Oracle 9i Client can be installed on windows 7 clientDoes Oracle 10g Client is required in the above mentioned case.

View 1 Replies View Related

Windows :: Installation Process Trying To Create Database On System

Dec 7, 2010

I'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 Related

PL/SQL :: ORA-29283 Invalid File Operation On Windows System

Jul 31, 2012

Windows 2003, DB 10.2.0.3...I have to read some files from remote folder, so on remote Windows machine I shared folder c:est (grant Everyone first, and Administrator then) and on DB Server I mapped the remote folder with letter T..All these operations were made with administrator privileges.

In Oracle I create a directory object with this command:
CREATE OR REPLACE directory T_DIR AS 'T:';

Then I granted read and write privileges to my user
GRANT READ, WRITE ON DIRECTORY T_DIR TO <user>; (I tried also to set PUBLIC and SYSTEM)

But when I try to open a file with UTL_FILE with this command

file_handler := UTL_FILE.fopen( 'T_DIR', 'Dati.ini', 'r' ) ;

the error is
Exception: ORA-29283: operazione file non valida
ORA-06512: a "SYS.UTL_FILE", line 475
ORA-29283: operazione file non valida

If I change my directory object in 'C: est' (local folder) it works correctly.I tried also restart DB while shared folders were connected but with the same result.I tried, from sqlplus, the command host (dir t:) and it works (folder is accessible)

Is it an Oracle bug? Is it a Windows bug?

View 5 Replies View Related

Forms :: Replica Of Windows Explorer - Read UNIX File System

Jun 14, 2011

I would like to develop a form which will be replica of windows explorer.It should be able to read all files or files from a specific folder from an unix platform.

if yes can i have a template. I do not want to start from the scratch since I do not have much time.

View 5 Replies View Related

Windows :: Unable To Install Oracle 10g Client On 64bit Windows 2008

Jul 16, 2008

We have a .NET application on windows server 2008 32bit using the stored procedures on an Oracle 10g environment. We are trying to deploy the .NET application onto a 64bit x86 Windows server 2008.

We face an error trying to install the x64 version of the Oracle 10g client on windows 2008. The error we get is Problem signature:

Problem Event Name: APPCRASH
Application Name: javaw.exe

Is the x64 version of the Oracle 10g client certified for Windows 2008? Has anyone successfully installed the 64bit version of the oracle client on win2008?

We have a workaround in place with 32 bit version of the client running with the 32 bit version of the .NET application on x64 win2008. However to maximize the infrastructure we need to use the 64 bit version or we would have to turn to MSSQL Server .

View 4 Replies View Related

Windows :: Installation Process Of Oracle 10g At Windows 7 Ultimate 32 Bit?

Feb 27, 2012

can i install oracle 10g at windows 7 ultimate 32 bit

View 1 Replies View Related

Windows :: Does Oracle Database 10.1.0.2 (64-bit) Compatible With Windows 2003 R2

Jan 9, 2011

Does Oracle Database 10.1.0.2 (64-bit) compatible with windows 2003 R2 standard X64 edition with Service pack 2.

View 1 Replies View Related

Forms :: Difference Between System.current_item And System.cursor_item?

Apr 1, 2012

We 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?

View 2 Replies View Related

CPU System Time (percentage) For Multi Core System?

Aug 21, 2012

couple 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 (%)

View 1 Replies View Related

Windows ODBC :: Connect To Oracle 9i From Windows 7?

Dec 20, 2012

Database: oracle 9i sitting on a 32 bit machine.
Client: windows7 64 bit computer
installed oracle 11gr2 client

Is there a way to connect to oracle 9i database from C:WindowsSysWow64odbcad32.exe on windows 7 machine? or what is the possible way to connect to Oracle 9i database?What we need is to run crystal reports from windows 7.

View 4 Replies View Related

Server Administration :: OFA And Raid System For Oracle

May 5, 2011

Can I use OFA and Raid system together for Oracle 11g in Windows 2008 Server? I am installing the OS in C drive. Where to install the oracle, location for Oracle_Base, number of logical and physical drive required, size of each etc.

I am planning to use
Raid 1 - Controlfile, redolog file and archive log file
Raid 1+0 - Datafiles

Also I want to multiplex virtual memory page also.

View 6 Replies View Related

Reports & Discoverer :: Customized System On Oracle 10g

Jun 30, 2011

I have customized system on oracle 10g ( English interface and reports ) , the company want to make the system in both (Arabic and English) , i make every thing is okay , but the problem when i change the PDF subset in the file uifont.ali to include Arabic fonts , the report server every 2 hours stopped and give me the message ( server is in progress ) ,

View 1 Replies View Related

SQL & PL/SQL :: Remote System Oracle 10g - Login Credentials Details

Apr 11, 2011

in My remote system oracle 10g installed and i don't know the login Credential details. i.e username, password,database name.

View 12 Replies View Related

SQL & PL/SQL :: Interfacing Data From Oracle Database To External System

Feb 24, 2012

I have an issue with the text area column(Column name-Text) while interfacing the data from oracle database to external system.The data in database is saved as:

This is test entry for commentfield.
testing the script
Pre-production
23-FEB-2012

We want all the line breaks to replaced with a space or a comma. to implement this i have used to simple select as :

Select Replace(text,chr(10),'')
From paymemo
where referencepkey = (select pkey from paymain where ID = 'DED-520074 505354DN6 2012-02-04 00:06:48');

This is not working because of type conversion issues.

View 6 Replies View Related

Oracle 11g Installation - SYSTEM Admin Password Does Not Work

Aug 13, 2012

I have installed oracle several times in the past. This time I installed 11gr2 first time. I created default database during install and provided an admin password. Only thing I forgot to do was did not unlock the accounts using Password management button.

When I tried to login as SYS the admin password works fine but as SYSTEM admin password does not work. Used to be able to login as SYS, SYTEM with same admin password.

Now in SQLPLUS I unlocked the account but still can not change the password.

View 4 Replies View Related

Oracle 10g - Creating Library Management System Using Struts 2

May 18, 2011

i am creating a library management system using struts 2.i have a form that display a table having column(bookname, author, publisher,..etc) and it contains an operation "edit book" with each row. now i m stuck with an update query(or any other query) by which i can edit an entire row (or any column) onclicking the edit button.i'm using oracle 10g database.

View 2 Replies View Related

Oracle 10g On Linux System - ORA 12560 Error On Client Side?

Jan 2, 2011

i have installed oracle 10g on linux system. and i am using xp as a client when i use this

cmd>conn scott/tiger@database at client side i receive ora-12560 error

while my database is up and listener and tnsping also working at server side.

View 3 Replies View Related

Application Express :: Connect To External System Using Oracle APEX?

Jun 21, 2012

While browsing through the APEX, just wondering if there is any way to connect external database.

Like i have database connection string/user/password and service.

Is there any way to define these information in APEX to connect with external database?

View 5 Replies View Related

Installation :: Oracle 11g - After Select System Class - Installer Just Closes Out?

Apr 16, 2013

Having trouble installing Oracle 11g. After I select system class, the installer just closes out. I have re-download the software from the Oracle and made sure both files were unzipped into the same folder correctly. Searching around this forum found same problems, none of the solutions have worked so far. Tried setup -jreLoc (Location of Java), tried using it with different versions of java. If it tries to start the installer it gives an error about not being able to locate java runtime.

Specs: Windows 7 Ultimate x64
8GB Memory
930GB Free (on drive i want to install oracle on)

Files Download:
win64_11gR2_database_1of2.zip
win64_11gR2_database_2of2.zip

View 11 Replies View Related

Forms :: Write Trigger To Insert System Clock Time In Oracle?

Jan 4, 2013

how can i write a trigger to insert the system clock time in the oracle form?

View 15 Replies View Related

Performance Tuning :: How To Determine System Memory Usage By Oracle Processes

Jun 20, 2012

we have 96GB Memory on the UNIX server and 85% of its usage shows oracle processes I want to determine which Oracle processes are taking most of the memory

SGA is around 36G
SGA_TARGET is 40G
PGA is around 4G

the total of around 40-45 GB of usage is understandable but what other oracle process are chewing up the remaining 30-40 GB on the server is not known

load averages: 7.35, 6.46, 6.15; up 248+11:33:21 12:25:03
2202 processes: 2196 sleeping, 1 zombie, 5 on cpu
CPU states: 83.8% idle, 10.5% user, 5.8% kernel, 0.0% iowait, 0.0% swap
Memory: 96G phys mem, 15G free mem, 128G total swap, 128G free swap

PID USERNAME LWP PRI NICE SIZE RES STATE TIME CPU COMMAND
21720 oracle 258 0 0 40G 40G cpu/48 215:28 2.04% oracle
10709 oracle 1 0 2 1816K 1448K cpu/9 0:02 0.90% res_conf_email_
[code]......

View 6 Replies View Related

Express Edition (XE) :: Oracle 11g On Linux Mint - MEMORY_TARGET Not Supported On This System

Feb 5, 2013

I decided to use Oracle 11g XE on Linux Mint. I read this tutorial Oracle 11gR2 Express Edition on Linux Ubuntu 11.10 howto included the seventh part. However, I did a minor change in the script given. Indeed, since Ubuntu 12.04, a bug appeared. So I use the following script :

cat > /etc/init.d/oracle-shm <<-EOF
#! /bin/sh
# /etc/init.d/oracle-shm
#
#
case "$1" in
start)

[code]...

I already uninstalled and reinstalled Oracle 3-4 times, but nothing else happened. When I want to configure oracle-xe, I have a such message :

Starting Oracle Net Listener...Done
Configuring database...
Database Configuration failed.  Look into /u01/app/oracle/product/11.2.0/xe/config/log for detailsAnd this is the content of the file postDBCreation.log :
begin
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0

[code]...

View 3 Replies View Related

Installation :: 11g R2 In Fedora 17 (32 Bits) System - Oracle Patch To Enable DB Console?

Apr 23, 2013

I have been working in the installation of oracle 11g r2 in my fedora 17 (32 bits) system for a few days and still have not gotten.Now I found that I need the OPtatch for enable the db console and even being a member of My Oracle Support I can not request the patch for a technical question.

1) Note to the Approver: I am that one because I am an end user (freelance)

2) Support Identifier: How can I get it?

View 6 Replies View Related

Performance Tuning :: Tune Data Coming From Legacy System Into Oracle Database

May 22, 2012

Customer is sending data from legacy system (Source) with the web service which in turn calls a package lying on Oracle server (Target). Now this package is simply inserting data passed by legacy system into master staging table in Oracle database. When they started this process in Sept 2011 then 4 lack records were inserted into staging table. In Oct 11 it was 0 records Nov 11 it was 2 lack records, Dec 11 it was 1 lack records, in Jan 12 it was 1 lac records, Feb 12 73k records, Mar 12 0 records, Apr 12 52k records.

As we see that number of records inserted in the table got reduced with time.. what should be the starting point here since web service is calling that package on the fly, how can i enable trace for that package? I cannot replicate this is Dev as this process is only working in PROD.

View 6 Replies View Related

Forms :: How To Know Operating System Current Path In Oracle 10g Forms

Apr 19, 2011

How to Know Operating System Current Path in oracle 10g forms ?

View 4 Replies View Related







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