Server Administration :: SQL Advisor Job Failed?

Nov 22, 2006

Trying to execute the following pl/sql block as user SYS in a Oracle10g v.2 database...

DECLARE taskname varchar2(30);task_desc varchar2(256);task_or_template varchar2(30);task_id number;wkld_name varchar2(30);saved_rows number;failed_rows number;num_found number;BEGINtask_id := 0;saved_rows := 0;failed_rows := 0;taskname := 'SQLACCESS6026890';task_desc := 'SQL Access Advisor';task_or_template := 'null';wkld_name := 'SQLACCESS6026890_wkld';/* Create Task

[code]...

What can I get rid of these errors??

View 5 Replies


ADVERTISEMENT

Server Administration :: Login Getting Failed?

Aug 31, 2010

When I am trying to login to the oracle server I am getting an error message:

Enter user-name: / as sysdba
ERROR:
ORA-12638: Credential retrieval failed

View 4 Replies View Related

Server Administration :: Database Shutdown Failed

Dec 16, 2012

I issued a SHUTDOWN IMMEDIATE command on my database and for over 2 hours and got no response. I did this because I wanted to restart the database due to many hanging sessions which had led to high CPU usage on the server by oracle process.

Oracle Service<dbname> instance using the Windows Services screen which failed with an error 1053 message. At the same time I got an ORA-01013 message saying user requested cancel of operation. See below:

SQL> SHUTDOWN IMMEDIATE
ORA-01013: user requested cancel of current operation
SQL> SHUTDOWN IMMEDIATE
ORA-01089: immediate shutdown in progress - no operations are permitted
SQL> SHUTDOWN ABORT
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist

What I want to know is how do I proceed? Also how do I check to see the status of the Shutdown operation?

View 1 Replies View Related

Server Administration :: Login Failed In Oracle 11g

Jul 24, 2011

I have installed executable only (database option only) when i have installed oracle11 that time it is not asking any option for password. So is there any option to login in this type of condition?

I am using this on windows server 2003.

View 15 Replies View Related

Server Administration :: ORA-27070 / Async Read / Write Failed

Jan 6, 2013

i have tried to create the index in diff tbs also but same error is there

SQL> create index inx_tbl_voicechat_unsub_ani on tbl_voicechat_unsub (ani) tablespace ideadb_index;
create index inx_tbl_voicechat_unsub_ani on tbl_voicechat_unsub (ani) tablespace ideadb_index
*
ERROR at line 1:
ORA-01115: IO error reading block from file 201 (block # 144265)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 23) Data error (cyclic redundancy check).
ORA-01115: IO error reading block from file 201 (block # 144265)
ORA-27070: async read/write failed
OSD-04016: Error queuing an asynchronous I/O request.
O/S-Error: (OS 23) Data error (cyclic redundancy check).

View 10 Replies View Related

Server Administration :: PMON (failed To Acquire Latch) During Shutdown

Aug 29, 2010

I found in alert log that PMON "failed to acquire latch" during shutdown.What it means and how to rectify the same.

View 2 Replies View Related

Server Administration :: Finding Failed Login Attempts In Database?

Aug 24, 2010

how can I find out the number of login attempts made by a user in the database and the timings of the attempt

View 1 Replies View Related

Server Administration :: ORA-00554 Initialization Of Internal Recovery Manager Package Failed

Apr 18, 2013

When I am issuing below command from auxiliary database, getting ORA-00554.My tnsping is okay from both the side, remote login is exclusion. Password file is also okay.I ran UTLRP.sql twice to compile invalid packages.

From Auxiliary Database
[ashish@localhost dbs]$ rman target sys/oracle@suman auxiliary /
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Apr 11 19:04:03 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

View 8 Replies View Related

Server Administration :: Heartbeat Failed To Connect To Standby / ORA-12160 - TNS Internal Error?

Sep 3, 2010

From alert log,
<msg time='2010-09-03T11:37:46.548+06:00' org_id='oracle' comp_id='rdbms'
client_id='' type='UNKNOWN' level='16'
host_id='DC-DB-01' host_addr='192.168.100.101' module=''
pid='24310'>
<txt>Error 12160 received logging on to the standby

[code]...

From trace file,

[oracle@DC-DB-01 ~]$ less /u01/app/oracle/diag/rdbms/bddipdc/bddipdc1/trace/bddipdc1_arcq_24310.trc
Redo shipping client performing standby login
OCIServerAttach failed -1
.. Detailed OCI error val is 12160 and errmsg is 'ORA-12160: TNS:internal error:
\
[code]...

View 2 Replies View Related

Forms :: Failed To Connect To Server

Oct 15, 2010

I have a pb went i can access on my forms server:

FRM-92050: Failed to connect to the Server: ://127.0.0.1/servlet/oracle.form...enerServlet:-1

java.net.ConnectException: Connection refused

View 1 Replies View Related

Server Utilities :: Exp / Imp Failed On Nested Table

Jun 18, 2013

I am trying to exp/imp database schema from one environmet to other in oracle 11g. I have a couple nested tables (tables with types datatype). Here are the errors I am getting:

ORA-31693: Table data object "IPAM"."BACKEND_POLICY_TYPES" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00600: internal error code, arguments: [kpudpxcs_getCol_ref_4], [Imgver=1 InputStrmVer=9 Name=POLICY], [], [], [], [], [], [], [], [], [], []

ORA-31693: Table data object "IPAM"."LB_POLICIES" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00600: internal error code, arguments: [kpudpxcs_getCol_ref_4], [Imgver=1 InputStrmVer=9 Name=POLICY], [], [], [], [], [], [], [], [], [], []

View 4 Replies View Related

Rep-51002 Bind To Reports Server Ags-pension Failed

Oct 3, 2011

I have installed Application server in windows 2003 server. I use oracle 10g with forms and reports 9i. The same application was being tested in a standalone system with database in one system and application in another and it was working fine. When i installed the application in windows 2003 server and database in linux, the forms are being accessed from my client system through windows 2003, but when i generate the reports it gives me this error. "rep-51002 bind to reports server ags-pension failed".

ags-pension is the domain name of my windows 2003 server..I configured the following

01) default.env
02) forms.conf
03) formsweb.cfg
04) registry.dat
05) gave the path of the forms and reports in REGEDIT

Now I have hard coded the reports path to my stand alone pc and its working fine. I want it to be accessed from windows 2003 server.Is there any configuration that i have missed out. I don't remember having any changes made for reports.In all the above mentioned files i only gave the path of my forms and reports.

View 2 Replies View Related

Forms :: REP-51002 - Bind To Reports Server Failed

Jul 30, 2013

After I moved my servers (application and db) into a VPN network I am facing this error "REP-51002: Bind to Reports Server failed".

Product-Oracle Forms and Reports 11g
Servers(app and db)- Windows 2008

View 5 Replies View Related

RAC & Failsafe :: Oracle Server Reboot - IP Ping Failed

Jun 20, 2011

Every time interconnect IP ping failed between RAC servers,CRS causing reboot to the server. As documented,it is of 3 sec. Can we alter this setting to increase the ping failed (private IP) by more than 3secs.

View 4 Replies View Related

Enterprise Manager :: Error / Server Connection Failed

Sep 14, 2013

I have configured OEM and is up and running but, I am getting below error message when open the OEM URL.

Error Message:

Secure Connection Failed / an error occurred during a connection to rhel6:1158.

The page you are trying to view can not be shown because the authenticity of the received data could not be verified.

View 2 Replies View Related

RMAN :: Duplicate Command Failed In Without Catalog On Different Server

Jun 29, 2012

i am creating duplicate DB from rman backup it failed as all steps is as below:

$ vi pfile.ora
$
$
$ export ORACLE_SID=tim
$
$
$ sqlplus

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 8 10:35:10 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> !pwd
/oracle1/oraerp/tech_st/dbhome_1/dbs
[code]....

View 10 Replies View Related

ORA-12500 / TNS - Listener Failed To Start A Dedicated Server Process

Dec 12, 2011

We are getting the below error in between from database. The database throws the below error some times only not continuous.

ORA-12500, TNS:listener failed to start a dedicated server process.

View 6 Replies View Related

Server Utilities :: Not A Valid Export File Header Failed Verification

Nov 22, 2012

Sometimes during recovery I encountered the following message "

This error occurs when Backup And Restore Occur between different versions

View 4 Replies View Related

Server Utilities :: ORA-01187 / Cannot Read From File 203 Because It Failed Verification Tests

Apr 26, 2011

I want to export all db using data pump. I got this error when using it:

Export: Release 10.2.0.4.0 - Production on Thu Nov 25 11:46:48 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export the entire database ...

. exporting tablespace definitions
EXP-00068: tablespace TISDATA is offline
EXP-00008: ORACLE error 1187 encountered
ORA-01187: cannot read from file 203 because it failed verification tests
ORA-01110: data file 203: '/u03/app/oracle/product/10.2.0/oradata/unidev/TISTEMP01.dbf'
EXP-00000: Export terminated unsuccessful

View 2 Replies View Related

Server Utilities :: IMP-00017 / Statement Failed With ORACLE Error 1950

Apr 28, 2011

While importing, I got the following error. How to resolve it?

IMP-00017: following statement failed with ORACLE error 1950: CREATE TABLE "table_name".....

View 2 Replies View Related

ORA-28547 / Connection To Server Failed - Probable Oracle Net Admin Error

Jul 7, 2012

DB 10.2.0.4

After running shut abort it is giving below error while trying to connect sqlplus.

ORA-28547: connection to server failed, probable Oracle Net admin error

View 2 Replies View Related

Server Utilities :: ORA-31694 / Master Table (SYS) Failed To Load / Unload

Sep 24, 2010

ORA-31694: master table "SYS"."SYS_IMPORT_FULL_02" failed to load/unload
ORA-31640: unable to open dump file "D:oradataPSPRODDBdata_pump_dirpowerschool-fri.dmp" for read
ORA-19505: failed to identify file "D:oradataPSPRODDBdata_pump_dirpowerschool-fri.dmp"
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 2192117862)

View 10 Replies View Related

TimesTen In-Memory :: Cannot Connect To Server With Ttisqlcs / Failed To Retrieve IP Address Of The System

Nov 16, 2013

I installed timesten server and client on different machines in LAN, but with the same user and group - ttadmin:ttgroup When I tried to connect to server with ttisqlcs -connStr "DSN=sampleCS"The output gave me error messages as below connect "DSN=sampleCS";S1000: Failed to retrieve IP address of the system. System error: -2The command failed.Done. The related part in sys.ttconnect.ini is set as below 

[192.168.0.206]Description=TimesTen ServerNetwork_Address=192.168.0.206TCP_PORT=53397 

And the

sys.odbc.ini [ODBC Data Sources]sampleCS=TimesTen 11.2.2 Client Driver [sampleCS]TTC_SERVER=192.168.0.206TTC_SERVER_DSN=nredb_ds 

What does it mean by "retrieve IP" ?Does it try to resolve IP by the hostname even when I already gave it the ip address?By the way I can ping 192.168.0.206 and telnet at port 53397 with no problem.

View 4 Replies View Related

Reports & Discoverer :: Bind To Reports Server Rep_wwubh01ap45 Failed

Jun 9, 2006

While accessing the reports i am getting the following error

Rep - 51002 : Bind to Reports Server rep_wwubh01ap45 failed.

I have checked the file $ORACLE_HOME/reports/conf rwservelet.properties. The parameter SERVER=rep_wwubh01ap45 was present in that file.

View 1 Replies View Related

Server Administration :: Create Tablespace For Administration

Nov 29, 2010

i'm a student currently learning database administration security.

I need to create a tablespace for administration of database but i don't know what datafile settings are best suited for admin usage.

I have attached the schema that was given to me for this assignment.

View 12 Replies View Related

Server Administration :: Monitoring Script Required For Oracle 9.2.0.7.0 On Windows 2000 Server

Apr 8, 2010

My manager is asking to create a SQL scrip, which will provide following information.

Our database is 9.2.0.7.0 on Windows 2000 Server

-How many records Insert / Update or Delete daily in my Oracle database?

- Check Archive log / Redo Log switching information?

-Check database growth ?

View 10 Replies View Related

Server Administration :: Installing Oracle Database 10.1.0.2.0 On Windows 2003 Server 64bit?

Jan 11, 2011

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."

View 1 Replies View Related

Server Administration :: Restoring The Oracle Services In Windows 2008 Server

Jun 27, 2012

I was trying to delete the database in the test server. When i was deleting listener was already stopped, i continued deleting using dbca, it shown me some alert that datafiles cant be deleted because system could't find database, since listner was stopped so only service was deleted(the one showing in the windows administrator toolsservicesOracleServiceTEST).

All the datafile parameter files are still there. How can i delete the datafiles and parameter files belongs to that database or how to create the deleted service, so that i will start the listener and do the complete deleting of the database.

View 3 Replies View Related

Server Administration :: How To Migrate Database From Windows 2003 To 2008 Server

Oct 31, 2012

I have to migrate production database version 10gR2 on windows 2003 server to oracle 11gR2 on windows 2008 server . So far i have just installed the oracle software on 64bit windows 2008 server. How to move the data or migrate from old server to new server .

View 22 Replies View Related

Server Administration :: Server Installation Gets Abruptly Ended For Client Get TNS Errors

Jan 11, 2011

after a long time,(i never remember when was the last time i installed 9i)i was asked to install 9i.So, whether i install server or cilent i get this error <attachment>

after i ignore it and finished the installation,The server installation gets abruptly ended for the client i get TNS errors.

View 2 Replies View Related







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