Server Administration :: Invalid Component On 10.2 Database?
Jan 10, 2012
we are doing database upgradation to 11.2 from 10.2,i have found two invalid components but i couldn't find any invalid objects for those related components. find the output ...
SQL> set pagesize 500
SQL> set linesize 100
SQL> select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from
dba_registry order by comp_name; 2
COMP_NAME STATUS VERSION
---------------------------------------- ----------- ----------
JServer JAVA Virtual Machine VALID 10.2.0.3.0
[code]...
17 rows selected.
SQL> select substr(object_name,1,40) object_name,substr(owner,1,15) owner,object_type from
dba_objects where status='INVALID' order by owner,object_type; 2
no rows selected
SQL> select owner,object_type,count(*) from dba_objects where status='INVALID' group by
owner,object_type order by owner,object_type ; 2
no rows selected
View 3 Replies
ADVERTISEMENT
Oct 19, 2010
i prepare database server and when i import my dump file from old database it import normal but before it end it give me these errors and these errors it seems that it in loop
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN SYS.DBMS_EXPORT_EXTENSION.SET_IMP_SKIP_INDEXES_OFF; END;"
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 1, column 12:
PLS-00302: component 'DBMS_EXPORT_EXTENSION' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
View 8 Replies
View Related
May 11, 2012
I have a doubt on invalid objects.What would be the impact to database and application if there are many invalid objects in database?
View 3 Replies
View Related
Mar 22, 2011
I am getting below error while connecting to sqlplus.
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Mar 22 12:47:48 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.DISABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
[code]....
Executed the below scripts but it didnt resolve the issue, whereas some of the SYS objects and catproc got invalid...
dbmsotpt.sql
dbmsapin.sql
Now even after reexecuting the catproc.sql and utlrp...Sys objects and the catproc status is still INvalid.
I tried to manually compile the sys objects, but it didnt work.
OWNER SUBSTR(OBJECT_NAME,1,40) OBJECT_TYPE
-------------------- ---------------------------------------- --------------------
SYS DBMS_XPLAN PACKAGE BODY
SYS AQ$AQ_SRVNTFN_TABLE VIEW
SYS DBMS_LOGREP_DEF_PROC PACKAGE
SYS DBMS_LOGREP_DEF_PROC PACKAGE BODY
[code]....
how to go about making the SYS objects and catproc VALID and resolve the error which i mentioned above.
View 36 Replies
View Related
Jul 14, 2011
i have manualy create a database using this
1)ORACLE_SID=ORA10G... (set into Env variable )
2)Go to F:oracleproduct10.2.0adminORA10G create new folder (ORA10G)
3) In ORA10G create new all folders adump,bdump,cdump,dpdump,pfile,udump
4) In pfile take a copy of existing init.ora from my orcl databse
5) Change this init.ora
6) Change parameters
7) db_name , instance_name ,control_files ,background_dump
dest,user_dump_dest,
save this file as "init.ora"
9) Create new folder in Oradata --- "ORA10G"
10) create service
Oradim NEW SID ORA10G SYSPWD ORACLE STARTMODE AUTO SPFILE
11) then i have check service is started or not in Control panel- administrative tools - sevices--OracleserviceORA10g---started
12) i have Shut down previously started database
13) Connect to SQL promp
F:oracleproduct10.2.0db_1in> set oracle_sid=ora10g
F:oracleproduct10.2.0db_1in>SQLPLUS
SQL*Plus: Release 10.2.0.5.0 - Production on Thu Jul 14 16:46:59 2011
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Enter user-name: SYS AS SYSDBA
Enter password:
Connected to an idle instance.
14)than create spfile
SQL> CREATE SPFILE FROM PFILE = 'F:ORACLEPRODUCT10.2.0ADMINORA10GPFILEINIT.ORA';
File created.
15) than i have run this command
SQL> startup nomount
ORA-02778: Name given for the log directory is invalid
==
i have attached my orcl init.ora file and my new init.ora file also here
======
my orcl init.ora file here that i have used here for this database
====
initorcl.ora
===========
orcl.__db_cache_size=385875968
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
[Code].....
View 19 Replies
View Related
Nov 5, 2008
I am querying dba_objects view to see invalid objects in my database.It's showing status for some of the materialized views as invalid even though these materialized views are being refreshed on daily basis and being used in application.
I know that to make their status valid I can complile them but I don't understand if they are invalid, how come refresh never failed. Also, their status is valid in dba_snapshots.
View 1 Replies
View Related
Jan 31, 2012
here are so much invalid dba_objects. Do I need to care/repair?
SELECT owner, COUNT (*)
FROM dba_objects
WHERE status != 'VALID'
GROUP BY ROLLUP (OWNER)
output
ZIM4_RO71
ZIM473
PUBLIC16
SYS35
195
View 11 Replies
View Related
Jun 27, 2012
One of my friends is facing a peculiar problem where objects are getting "Invalid" during execution I suspect it is happening as they are changing system date during their testing (time travel) which can create conflicted last_ddl_time on objects having dependencies
Consider a scenario
[1] system date is 10-06-2012 there are total 10 objects which has status as 'valid'
[2] the system date is changed to 10-07-2012 Now out of 10 Only 5 objects are compiled During execution ORA-04065,ORA-06508, ORA-06512 are observed
[3] the system date is brought back to 10-06-2012 Again during execution ORA-04065,ORA-06508, ORA-06512 are observed
suppose in step 2 objects are compiled whereas there synonyms are compiled in step 1, only thus last_ddl_time for objects will be later to that of its' synonym...
Does database validate last_ddl_time for objects having dependency during execution and then auto-compiles or invalidates the objects?
View 3 Replies
View Related
Oct 9, 2011
I created a role,and it can not login,why?
session1:
SQL> Create Role con_role Identified By hxl;
Role created.
SQL> Grant Connect To con_role;
Grant succeeded.
SQL> Grant Create Session To con_role;
Grant succeeded.
session2:
sql>connect con_role/hxl@myserver ORA-01017: Invalid username/password.
View 12 Replies
View Related
Nov 5, 2012
dbca -silent -deleteDatabase -sourceDB TEST
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_TEST'
also tried to start the same instance and i get these messages - i did not created these oracle instance just trying to remove it and recreating it
SQL*Plus: Release 11.2.0.3.0 Production on Mon Nov 5 15:34:41 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER_TEST'
SQL> exit
Disconnected
View 6 Replies
View Related
Jan 26, 2012
ORA-00600: internal error code, arguments: [kcbchg1_11], [], [], [], [], [], [], []
ORA-01017: invalid username/password; logon denied
Current SQL statement for this session:
insert into sys.aud$( sessionid,entryid,statement,timestamp#, userid,userhost,terminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, new$owner,
new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,comment$text,spare1,spare2, priv$used,clientid, sessioncpu) values(:1,:2,:3,SYSDATE,:4,:5,:6,:7,:8
,:9, :10,:11,:12,:13,:14,:15,:16,:17, :18,:19,:20,:21,:22,:23,:24, :25)
View 6 Replies
View Related
Mar 26, 2011
i am installing oracle database 8.1.7 on dell server power edge 2650 first time database successfully installed but when i want to crate new database by Database Configuration Assistant it is not working for new database creation.
View 1 Replies
View Related
May 10, 2011
I'm getting above error when I run following code
BEGIN
OPEN c_report_data;
FOR rec in c_report_data
LOOP
IF
rec.ESR_SALESMAN <> lv_rep_num THEN
ln_ttl_rep_cnt := ln_ttl_rep_count + 1 ;
ELSE
ln_ttl_rep_cnt := ln_ttl_rep_cnt;
END IF;
View 9 Replies
View Related
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
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
Feb 13, 2013
I am trying to find the unix process for one of my application in the database but I am unable to view the same. To simulate, I did the following.
1. My database runs on different server.
2. I invoked "sqlplus" from another unix box to login to the database.
3. I found that the process id (ps -ef |grep sqlplus).
4. When I execute the below mentioned query it does not display the process id that I am looking for. But the osuser, username, program and machine details are correct. How can I know the process details from the database?
SELECT SYS.GV_$SESSION.OSUSER, SYS.GV_$SESSION.USERNAME, SYS.GV_$PROCESS.SPID,
SYS.GV_$SESSION.MACHINE, SYS.GV_$SESSION.PROGRAM,
SYS.GV_$PROCESS.PROGRAM ,SYS.GV_$SESSION.SQL_ID
FROM
SYS.GV_$PROCESS, SYS.GV_$SESSION
WHERE
SYS.GV_$PROCESS.ADDR=SYS.GV_$SESSION.PADDR and SYS.GV_$SESSION.USERNAME='TEST'
and SYS.GV_$SESSION.MACHINE like '%hostname%'
View 3 Replies
View Related
Apr 18, 2011
I have database in single server. I already have ORACLE_SID=stagedb. So i want to create new sid and named as proddb.Is it possible have multiple db in single server? This server not running as RAC. It run as single only.
View 1 Replies
View Related
Apr 30, 2012
database administration , we are planning to use amazon cloud database , this database does not allow us to login to server machine , unfortunately amazon don't provide ssh to this machine , in general for doing any of adminstration task on the database will there be need to log into the machine ? we can always log in through toad or any other sql client but we cannot do ssh to server..general can this limitation effect administration ?
View 9 Replies
View Related
Jun 29, 2011
I recently installed Oracle 10g on my windows Xp laptop. It has become considerably slow since then. I want to start the database server only when I need it, and not every time I start my laptop. I looked around in OEM and did found a way.
View 5 Replies
View Related
Jul 19, 2011
I am connected as System. It was the only user I set-up a password when installed the database on personal computer.
SQL> alter user sys identified by mypass007
2 /
User altered.
SQL> connect sys/mypass007
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
[code]...
SQL> conn sysoper/mypass007
ERROR:
ORA-01017: invalid username/password; logon denied
View 1 Replies
View Related
May 19, 2011
Get following output using user_source(or other) view?
Package_nameProcedure_nameline_startline_end
ABCXYZ1022
In procedure_name column it could be any procedure, function name or any object name exist in package body.
View 6 Replies
View Related
Jun 19, 2012
I am trying to create a report and seem to be struggling when trying to declare the columns 'DISK_READS' and 'CPU_TIME' within the statement.
Statement:
set serveroutput on
declare
cursor sqltext_cur is
select sql_id,child_number,sql_text, elapsed_time
from (select sql_id,child_number,sql_text,elapsed_time, cpu_time,
disk_reads,
RANK () OVER (ORDER BY elapsed_time DESC) AS elapsed_rank
[code]....
Error:
ERROR at line 18:
ORA-06550: line 18, column 51:
PLS-00302: component 'CPU_TIME' must be declared
ORA-06550: line 18, column 3:
PL/SQL: Statement ignored
ORA-06550: line 19, column 53:
PLS-00302: component 'DISK_READS' must be declared
ORA-06550: line 19, column 3:
PL/SQL: Statement ignored
View 3 Replies
View Related
Oct 22, 2011
I want to know if I can access a procedure created on Database server A from database server B.
View 2 Replies
View Related
Jun 22, 2011
We have an Oracle Server database of Size 50 GB having 10 GB Data. And Planning to have a new Database Server of 200GB . So my question is after moving all the 10 GB data to 200 GB Database Server, will the performance of the system come down? Will it reduce the speed?
View 9 Replies
View Related
Apr 17, 2011
Can I extract data from our Oracle server regarding the no. of sessions per day? But the problem is that our Boss wants a previous dates from April 11-17, 2011.
View 4 Replies
View Related
Aug 17, 2010
I have some requirement wherein I need to install Oracle 9i database server (9.2.0.7). I am not getting it on Oracle website. where can I get the download.
View 1 Replies
View Related
Sep 3, 2013
Getting error when using record type as in parameter.
PLS-00306: wrong number or types of arguments in call to 'SAL_UPDATE_PROC'
PLS-00302: component 'ENAME' must be declared
PLS-00302: component 'SAL' must be declared
CREATE OR REPLACE PACKAGE emp_details_proc
[code]....
I am not getting any error.
View 16 Replies
View Related
Mar 25, 2013
How can I determine version of oracle database from APEX. Is there any built in table or view is available in APEX? Is it possible from Shared Component?
View 5 Replies
View Related
Jun 10, 2010
see as i said keep on my database down in the night time around 9 pm. the OS redhat linux 5 restarting morning around 6.45 am.when i check alert_log there is no indication.when i check OS log , OS restarting around 6.45 amchecked in the log file in OS level
location: /var/log
i found this
Jun 7 06:45:33 Alraya syslogd 1.4.1: restart.
Jun 8 06:42:22 Alraya syslogd 1.4.1: restart.
Jun 9 06:47:12 Alraya syslogd 1.4.1: restart.
what is this mean, system restarting around 6:45 daily i think now i m posting listener.log for reference
<b>06-JUN-2010 21:04:52 *</b> (CONNECT_DATA=(CID=(PROGRAM=)(HOST=Alraya)(USER=alrayaora))(COMMAND=status)(ARGUMENTS=64)(SERVICE=(ADD
RESS=(PROTOCOL=TCP)(HOST=Alraya)(PORT=1521)))(VERSION=169869568)) * status * 0
06-JUN-2010 21:05:05 * (CONNECT_DATA=(SID=alraya)(CID=(PROGRAM=perl@Alraya)(HOST=Alraya)
[code]...
OS is restarting around 6.45 in the morning, but database getting down night around 9 pm itself why then in the morning if i bounce the database it starting with no problem
View 9 Replies
View Related
Jun 4, 2012
i m facing a problem in my databse when going to startup. sql> startup ora:00824- can not set sga_target due to existing inernal setting see alert log for more information . when i checked the alert log file i found
cannot set sga_target with statistics_level=basic. acutally last time i change the parameter statistics_level=basic scope=spfile (typical to basic).now my database is not open.what can i do to startup the database.I have no any type of backup.
View 5 Replies
View Related
