ORA-01658

select a.file_id,b.file_name,b.autoextensible,b.bytes/1024/1024,sum(a.bytes)/1024/1024
from dba_extents a , dba_data_files b
where a.file_id=b.file_id
group by a.file_id,b.file_name,autoextensible,b.bytes/1024/1024;


select file_name,tablespace_name,bytes/1024/1024/1024 "Size GB",status,autoextensible,maxbytes/1024/1024/1024 "MaxSize GB",increment_by from dba_data_files;

select tablespace_name,bigfile from dba_tablespaces;



alter database default tablespace SYSTEM;


ALTER DATABASE DATAFILE 'E:\MCS0809\USERs01.ORA' AUTOEXTEND ON MAXSIZE UNLIMITED;


Hard disk space is not equal to the database space
tablespace is full, and then hang it a few more data files
Reply:
Hard disk space is sufficient enough table space does not mean

ora-16038 ora-19502 ora-00312

ora-16038 ora-19502 ora-00312

ORA-16038: log 4 sequence# 10840 cannot be archived,ORA-19502: write error on file "", blockno (blocksize=,ORA-00312: online log 4 thread 1: '/ora01/oradata/pbm1/redo/redo04a',ORA-16014: log 4 seque

Just check the space in your archive log destination.

Make sure that it is not full.


shut immediate
startup mount
recover database until cancel;
alter database open resetlogs;


1. Increase the ARCHIVE DESTINATION size
2. Take backup of the archivelogs to different location.
3. Change archivelogs destination to some other mountpoint.
4. Delete archivelogs to make more space. ( should be the last option) and in case of standby database make sure those logs are already applied to standby.

ORA-00600 internal error code, arguments FILE jsks.c LINE 2388ID OCIKCallPush

SQL> exec DBMS_SCHEDULER.run_job ('ANALYZE_FULL');
BEGIN DBMS_SCHEDULER.run_job ('ANALYZE_FULL'); END;

*
ERROR at line 1:
ORA-00600: internal error code, arguments: [FILE:jsks.c LINE:2388ID:OCIKCallPush], [], [], [], [], [], [], [], [], [], [], []
ORA-28031: maximum of 148 enabled roles exceeded
ORA-28031: maximum of 148 enabled roles exceeded
ORA-28031: maximum of 148 enabled roles exceeded
ORA-06512: at "SYS.DBMS_ISCHED", line 185
ORA-06512: at "SYS.DBMS_SCHEDULER", line 486
ORA-06512: at line 1


spool c:\revokeldbo.sql

select 'REVOKE ' || GRANTED_ROLE  || ' from sys;'  from dba_role_privs where grantee='SYS' and granted_role not in ('CONNECT','DBA');
spool off

@c:\revokeldbo.sql

utl_http.request ORA-12541 TNSno listener

select utl_http.request('http://172.168.1.7') from dual;


ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1722
ORA-12541: TNS:no listener
ORA-06512: at line 1
29273. 00000 -  "HTTP request failed"
*Cause:    The UTL_HTTP package failed to execute the HTTP request.
*Action:   Use get_detailed_sqlerrm to check the detailed error message.
           Fix the error and retry the HTTP request.



select utl_http.request('http://172.168.1.7:91') from dual;

ORA-00600 [13011], [104], [4216981]

drop procedure ldbo.sp_mvmfrm;

drop materialized view ldbo.mv_rkmfrm;


Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\trace\rakshak_ora_25880.trc  (incident=2513464):
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [13011], [104], [4216981], [185], [4216981], [17], [], [], [], [], [], []
Incident details in: D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\incident\incdir_2513464\rakshak_ora_25880_i2513464.trc
Tue Jun 16 13:07:24 2015
Dumping diagnostic data in directory=[cdmp_20150616130724], requested by (instance=1, osid=25880), summary=[incident=2513464].
opiodr aborting process unknown ospid (25880) as a result of ORA-603
Tue Jun 16 13:07:27 2015
Sweep [inc][2513464]: completed
Sweep [inc2][2513464]: completed
Tue Jun 16 13:07:28 2015
SMON: Parallel transaction recovery tried
Tue Jun 16 13:07:30 2015




ORA-00600 [13011], [104], [4216981], [239], [4216981], [17], [], [], [], [], [], []


Tue Jun 16 11:24:47 2015
Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\rakshak\rakshak\trace\rakshak_j002_27844.trc:
ORA-00600: internal error code, arguments: [13011], [104], [4216981], [239], [4216981], [17], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745
ORA-06512: at "LDBO.SP_MVCLIENTFOLLOWUP", line 4
ORA-06512: at line 1


select object_name,object_type,owner from dba_objects where data_object_id=104;


analyze table DEPENDENCY$ validate structure cascade;




SELECT
ss.program "SOFTWARE",last_call_et,
       substr(sqa.sql_text, 1, 50) "SQL"
,'alter system disconnect session ''' || ss.sid || ',' || ss.serial# || ''' immediate;'
  fROM v$process pr, v$session ss, v$sqlarea sqa
 WHERE pr.addr = ss.paddr
   AND ss.username is not null
   AND ss.sql_address = sqa.address(+)
   AND ss.sql_hash_value = sqa.hash_value(+)
AND ss.status = 'ACTIVE'
ORDER BY last_call_et desc;


ANALYZE INDEX I_DEPENDENCY1 VALIDATE STRUCTURE;
ANALYZE INDEX I_DEPENDENCY2 VALIDATE STRUCTURE;


alter INDEX I_DEPENDENCY1 rebuild;
alter INDEX I_DEPENDENCY2 rebuild;


DROP INDEX "SYS"."I_DEPENDENCY1";
DROP INDEX "SYS"."I_DEPENDENCY2";

  CREATE UNIQUE INDEX "SYS"."I_DEPENDENCY1" ON "SYS"."DEPENDENCY$" ("D_OBJ#", "D_TIMESTAMP", "ORDER#")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 32768 NEXT 114688 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" ;



  CREATE INDEX "SYS"."I_DEPENDENCY2" ON "SYS"."DEPENDENCY$" ("P_OBJ#", "P_TIMESTAMP")
  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 32768 NEXT 114688 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" ;






SQL> DROP INDEX "SYS"."I_DEPENDENCY1";
DROP INDEX "SYS"."I_DEPENDENCY1"
                 *
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkdlGetCkyName1], [106], [], [],
[], [], [], [], [], [], [], []



SQL>
SQL> analyze table DEPENDENCY$ validate structure cascade;
analyze table DEPENDENCY$ validate structure cascade
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


SQL>

ORA-00064 object is too large to allocate on this OS (1,10085160)

process should be less 500



create pfile from spfile;

rename spfile

open pfile and change processes to 200

and restart services

Oracle Installation Issue Please ensure that this directory is writable and has at least 45MB of disk space

Virus
AntiVirus
Rights
Space in temp

Cross verify the registry using 'regedit' and check it doesn't have any unclean services of previos oracle installation (if any).

a) Insufficient free space in the temporary directory.
b) Insufficient access rights on the temporary directory.
c) Not using a local console.
d) Corrupted software set.
e) Wrong Unzip utility is used.



For Database: %Oracle_extracted_media%\database\install\oraparam.ini


Edit value: BOOTSTRAP=TRUE
New value: BOOTSTRAP=FALSE << this allows OUI creates less files /tmp and avoids creation of autorun.inf file @ %tmp%


2) Then run the setup.exe -debug from the media (where the file praparam.ini edited ).

Example: run setup.exe -debug from required media location

cd %Oracle_extracted_media%\database\setup.exe




create autorun.inf file in temp folder, try to save this

unload officescan

PLS-00920 parameter plsql_native_library_dir is not set

sho parameter plsql



plsql_code_type                      string      INTERPRETED
plsql_compiler_flags                 string      INTERPRETED, NON_DEBUG


10g

alter system set plsql_code_type  ='INTERPRETED';

The specified DSN contains an architecture mismatch between the Driver and Application

64 bit m/c

Reason
odbc at both location

c:\windows\system32\odbcad32.exe


c:\windows\sysWOW64\odbcad32.exe

remove odbc connection from c:\windows\system32\odbcad32.exe





You will get this error if you attempt to do the following on a 64-bit Windows machine:

Connect a 64-bit application to a data source for a 32-bit ODBC driver.
Connect a 32-bit application to a data source for a 64-bit ODBC driver.
If you are using a 64-bit application, it will be linked against the 64-bit version of the Microsoft ODBC Driver Manager, which can only load a 64-bit ODBC driver. You can only connect to data sources for ODBC drivers that are listed in the 64-bit ODBC Data Source Administrator (accessible from Administrative tools in Control Panel).

Similarly, if you are using a 32-bit application, it will be linked against the 32-bit version of the Microsoft ODBC Driver Manager, which can only load a 32-bit ODBC driver. You can only connect to data sources for ODBC drivers that are listed in the 32-bit ODBC Data Source Administrator (accessible by running %windir%\syswow64\odbcad32.exe in the Windows Run dialog box).

If an ODBC driver is listed in both versions of the ODBC Data Source Administrator, both a 32-bit and a 64-bit version of that driver are installed.

ORA-00344 unable to re-create online log ORA-27040 file create error unable to create file

http://blog.dbvisit.com/activating-standby-database-failover/


ORA-00344 unable to re-create online log ORA-27040 file create error unable to create file


SQL>  alter database rename file '/oracle/oradata/dbvisitp/redo01.log'
 to '/oracleX/oradata/dbvisitp/redo01.log';
Database altered.

SQL> alter database activate standby database;
alter database activate standby database
*
ERROR at line 1:
ORA-00344: unable to re-create online log
'/oracleX/oradata/dbvisitp/redo01.log'
ORA-27040: file create error, unable to create file
Linux Error: 2: No such file or directory



The database is still a standby database as the activation failed.
We cannot manually create the redo logs, as this is an Oracle internal operation.
The only thing we can do is to give the correct location for the redo log files.
Rename the redo log to the correct location:



SQL>  alter database rename file '/oracleX/oradata/dbvisitp/redo01.log' to
'/oracle/oradata/dbvisitp/redo01.log';

Database altered.
SQL> alter database activate standby database;

Database altered.

SQL>


Note: all previous backups of this database are now invalid and cannot be used to restore this database. This is because of the RESETLOGS command which resets the archive sequence number (SEQUENCE#) and invalidates all previous archive logs. The SCN number of the database is not reset.

Could not load file or assembly 'ChilkatDotNet4' or one of its dependencies. An attempt was made to load a program with an incorrect format.

Common Error #1

The Chilkat .NET assembly is a mixed-mode assembly. It provides a managed API, but the inner core contains native code. A process must load the correct assembly at runtime. A 32-bit process must load the 32-bit ChilkatDotNet4.dll, and a 64-bit process must load the 64-bit ChilkatDotNet4.dll. When a process tries to load the incorrect format, the following error will occur:

Could not load file or assembly 'ChilkatDotNet4' or one of its dependencies. An attempt was made to load a program with an incorrect format.
See Incorrect Format for more information.



check application pool (32 bit enable or not)

check ChilkatDotNet4 version 9.3.1


Microsoft Visual C++ 2010 SP1 Redistributable 32 bit / 64 bit
Microsoft Visual C++ 2012 SP1 Redistributable 32 bit/ 64 bit

Could not load file or assembly 'ChilkatDotNet4.dll' or one of its dependencies. The specified module could not be found.

install
vcredist_x64
vcredist_x86

vcredist_x64_2010
vcredist_x86_2010
vcredist_x64_2012
vcredist_x86_2012


Common Error #2

The Chilkat .NET assembly requires the VC++ runtime to be installed on any computer where your application runs. Most computers will already have it installed. Your development computer will have it because Visual Studio has been installed. However, if deploying to a computer where the VC++ runtime is not available, the following error will occur:

Could not load file or assembly 'ChilkatDotNet4.dll' or one of its dependencies. The specified module could not be found.




http://www.microsoft.com/en-us/download/details.aspx?id=5555






Common Error #1

The Chilkat .NET assembly is a mixed-mode assembly. It provides a managed API, but the inner core contains native code. A process must load the correct assembly at runtime. A 32-bit process must load the 32-bit ChilkatDotNet4.dll, and a 64-bit process must load the 64-bit ChilkatDotNet4.dll. When a process tries to load the incorrect format, the following error will occur:

Could not load file or assembly 'ChilkatDotNet4' or one of its dependencies. An attempt was made to load a program with an incorrect format.
See Incorrect Format for more information.

PLS-00123 program too large (Diana nodes)

in 10g, plsql is not taking such size.

better way to use large procedures and functions should always be defined within packages

microsoft excel cannot open or save any more documents because there is not enough available memory

at Control Panel \ All Control Panel Items \ Default Programs \ Set Default Programs \ Set Program Associations



In Excel, go to File/Options/Trust Center/Trust Center Settings/Protected View. Untick the "Enable Protected View for Outlook Attachments" - and all will be well.

no mapping between account name and security ids was done server 2008 service installation

 grant rights of folder

If you do choose the SYSPREP route though here is what you need to do:
From the Start Menu select Run
Enter C:\Windows\System32\sysprep\sysprep.exe in the box and click OK
Be sure that Enter System Out-of-Box Experience (OOBE) is selected
Check the box next to Generalize (If this is not select the SID won’t get changed)
Click OK and follow the prompts when the system reboots.


C:\Windows\System32\sysprep\sysprep.exe

Silverlight out of browser export to excel download issue require Administrator to create the file

at time of package build, in properties there is a tick for out of browser

LD Ledger Client Code not search

Insert into tblsaudatable select distinct Firmnumber,Oowncode,'C','N' from sauda minus
Select distinct cFirmnumber,cclientcode,'C','N' from tblsaudatable Where cSegment='C' ;

Insert into Tblsaudascriptable select distinct Firmnumber,Oowncode,Compcode,'C' from sauda minus
Select distinct cFirmnumber,Cclientcode,cscripcode,'C' from Tblsaudascriptable Where cSegment='C' ;

Insert into tblsaudatable select distinct Firmnumber,Oowncode,'D','N' from fosauda minus
Select distinct cFirmnumber,CClientcode,'D','N' from tblsaudatable Where cSegment='D' ;

Insert into Tblsaudascriptable select distinct Firmnumber,Oowncode,Compcode,'D' from fosauda minus
Select distinct cFirmnumber,Cclientcode,Cscripcode,'D' from Tblsaudascriptable Where cSegment='D' ;

Insert into Tblfintable select distinct firmnumber,oowncode,branchcode,'N' from ledger minus
select distinct cfirmnumber,Cclientcode,Cbranchcode,'N' from Tblfintable ;

ORA-29861 domain index is marked LOADINGFAILEDUNUSABLE

Exec dbms_network_acl_admin.create_acl ('utl_http_access.xml','Normal Access','DPCDSL',TRUE,'connect',NULL,NULL);
Exec dbms_network_acl_admin.add_privilege (acl => 'utl_http_access.xml', principal =>  'DPCDSL',is_grant => TRUE, privilege => 'resolve');
Exec dbms_network_acl_admin.assign_acl ('utl_http_access.xml', '*',NULL,NULL);
Commit ;


ERROR at line 1:
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE
ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 252
ORA-06512: at line 1




select owner,index_name from all_indexes where domidx_status != 'VALID' or domidx_opstatus !='VALID';

alter index xdb.XDB$ACL_XIDX rebuild;

"ORA-28547: Connection to Server Failed, Probable Oracle Net Admin Error"

Edit the SQLNET.ora file in a text editor such as Notepad.


Change this line to what is shown below:
#SQLNET.AUTHENTICATION_SERVICES = (NTS)
SQLNET.AUTHENTICATION_SERVICES = (NONE)


Check Path at Env Var


Listener rights issue

Restart Listener

Standby Database not automatically startup issue

What is the value of REMOTE_LOGIN_PASSWORDFILE parameter?

Please change the owner of the Oracle process
Start->Settings->Control Panel->Services
Locate and highlight the "OracleServiceSID"
Click on the "Startup" button
In the "Log On As", choose "This Account"
Use the "..." button to browse to the "OracleAdmin" or Administrator user
Choose in "List Names From" your host
Provide the password of this user and confirm it
Repeat for the "OracleStartSID", "OracleTNSListener" and any
other Oracleservice you are using.
Be sure that the service startup is "Automatic"


ORA_<SID>_AUTOSTART =
ORA_<SID>_PFILE =
ORA_<SID>_SHUTDOWN =
ORA_<SID>_SHUTDOWNTYPE =
ORA_<SID>_SHUTDOWN_TIMEOUT =



Research:
=========
WIN: Automatic Startup of the Database when Using O/S Authentication ( Note 116979.1 )
How to configure Database Control to Start Automatically on Server Reboot / Shutdown Note 1282530.1
Windows Service Not Starting Automatically At Server reboot ( Doc ID 1264404.1 )