Oracle Database Commands and Practical Examples

Tuesday, 8 January 2019

Oracle 12c ADCRI commands and examples

Using sqlplus prompt check the location diagnostic file location.

set lines 200

col NAME for a50

col VALUE for a50

SELECT name, value FROM v$diag_info;

oracle@sgdcplm02:~> adrci

oracle@sgdcplm01:~> adrci -help

adrci> show incident

ADR Home = /u02/app/oracle/diag/rdbms/smrprodb/SMRPRODB:

*************************************************************************

INCIDENT_ID PROBLEM_KEY CREATE_TIME

-------------------- ----------------------------------------------------------- ----------------------------------------

57201 ORA 4031 2018-03-22 15:27:57.652000 +01:00

57202 ORA 4031 2018-03-22 15:28:01.143000 +01:00

57185 ORA 4031 2018-03-22 15:28:33.741000 +01:00

57186 ORA 4031 2018-03-22 15:28:35.431000 +01:00

57065 ORA 4031 2018-03-22 15:32:11.646000 +01:00

56998 ORA 4031 2018-04-19 21:35:53.990000 +02:00

56999 ORA 4031 2018-04-19 21:35:57.807000 +02:00

57000 ORA 4031 2018-04-19 21:35:59.521000 +02:00

59207 ORA 4031 2018-04-19 21:36:01.251000 +02:00

59208 ORA 4031 2018-04-19 21:36:02.932000 +02:00

56841 ORA 4031 2018-04-30 13:44:40.166000 +02:00

56842 ORA 4031 2018-04-30 13:44:44.128000 +02:00

56945 ORA 4031 2018-05-01 13:29:45.663000 +02:00

56946 ORA 4031 2018-05-01 13:29:49.617000 +02:00

56969 ORA 4031 2018-05-02 08:56:38.026000 +02:00

56970 ORA 4031 2018-05-02 08:56:50.693000 +02:00

56971 ORA 4031 2018-05-02 08:56:52.178000 +02:00

56972 ORA 4031 2018-05-02 08:56:55.567000 +02:00

56973 ORA 4031 2018-05-02 08:56:57.119000 +02:00

56889 ORA 4031 2018-05-02 14:25:25.394000 +02:00

57097 ORA 4031 2018-05-02 16:35:22.001000 +02:00

57098 ORA 4031 2018-05-02 16:35:26.076000 +02:00

57169 ORA 4031 2018-05-02 16:38:08.116000 +02:00

57209 ORA 4031 2018-05-02 18:09:05.799000 +02:00

57210 ORA 4031 2018-05-02 18:09:09.130000 +02:00

56985 ORA 4031 2018-05-04 11:12:07.000000 +02:00

56986 ORA 4031 2018-05-04 11:12:11.576000 +02:00

56905 ORA 4031 2018-05-04 11:57:12.841000 +02:00

56906 ORA 4031 2018-05-04 11:57:14.210000 +02:00

56907 ORA 4031 2018-05-04 11:57:16.004000 +02:00

55609 ORA 4031 2018-05-04 12:13:50.193000 +02:00

55610 ORA 4031 2018-05-04 12:13:54.372000 +02:00

55611 ORA 4031 2018-05-04 12:13:55.907000 +02:00

55612 ORA 4031 2018-05-04 12:13:57.455000 +02:00

55613 ORA 4031 2018-05-04 12:14:39.442000 +02:00

56865 ORA 4031 2018-05-04 13:18:53.301000 +02:00

56866 ORA 4031 2018-05-04 13:18:54.845000 +02:00

56867 ORA 4031 2018-05-04 13:18:55.972000 +02:00

56937 ORA 4031 2018-05-04 13:33:44.904000 +02:00

56938 ORA 4031 2018-05-04 13:33:46.180000 +02:00

56962 ORA 4031 2018-05-05 11:12:41.345000 +02:00

56963 ORA 4031 2018-05-05 11:12:43.702000 +02:00

56964 ORA 4031 2018-05-05 11:12:45.192000 +02:00

56965 ORA 4031 2018-05-05 11:12:47.690000 +02:00

56966 ORA 4031 2018-05-05 11:12:49.226000 +02:00

55615 ORA 4031 2018-05-05 13:06:14.143000 +02:00

55616 ORA 4031 2018-05-05 13:06:21.174000 +02:00

59254 ORA 4031 2018-05-05 13:06:22.670000 +02:00

59255 ORA 4031 2018-05-05 13:06:26.469000 +02:00

59256 ORA 4031 2018-05-05 13:06:29.736000 +02:00

ADR Home = /u02/app/oracle/diag/clients/user_oracle/host_1505528871_82:

*************************************************************************

0 rows fetched

ADR Home = /u02/app/oracle/diag/tnslsnr/sgdcplm02/smrpro_listener:

*************************************************************************

0 rows fetched

ADR Home = /u02/app/oracle/diag/tnslsnr/sgdcplm02/listener:

*************************************************************************

First 0 rows fetched (*** more available ***)

adrci> show problem

adrci> show control

DIA-48448: This command does not support multiple ADR homes

adrci> show incident -mode detail -p "incident_id=59256"

ADR Home = /u02/app/oracle/diag/rdbms/smrprodb/SMRPRODB:

*************************************************************************

**********************************************************

INCIDENT INFO RECORD 1

**********************************************************

INCIDENT_ID 59256

STATUS ready

CREATE_TIME 2018-05-05 13:06:29.736000 +02:00

PROBLEM_ID 1

CLOSE_TIME <NULL>

FLOOD_CONTROLLED none

ERROR_FACILITY ORA

ERROR_NUMBER 4031

ERROR_ARG1 52520

ERROR_ARG2 shared pool

ERROR_ARG3 SELECT /*+ LEADING( tt ) DYN...

ERROR_ARG4 KGLH0^46c0ec77

ERROR_ARG5 kkslcr:unsafepos

ERROR_ARG6 <NULL>

ERROR_ARG7 <NULL>

ERROR_ARG8 <NULL>

ERROR_ARG9 <NULL>

ERROR_ARG10 <NULL>

ERROR_ARG11 <NULL>

ERROR_ARG12 <NULL>

SIGNALLING_COMPONENT KGH

SIGNALLING_SUBCOMPONENT <NULL>

SUSPECT_COMPONENT <NULL>

SUSPECT_SUBCOMPONENT <NULL>

ECID <NULL>

IMPACTS 0

PROBLEM_KEY ORA 4031

FIRST_INCIDENT 57201

FIRSTINC_TIME 2018-03-22 15:27:57.652000 +01:00

LAST_INCIDENT 74413

LASTINC_TIME 2018-09-15 08:40:23.636000 +02:00

IMPACT1 34668547

IMPACT2 34668546

IMPACT3 0

IMPACT4 0

KEY_NAME SID

KEY_VALUE 481.39600

KEY_NAME ProcId

KEY_VALUE 51.103

KEY_NAME PQ

KEY_VALUE (0, 1525518389)

KEY_NAME Service

KEY_VALUE SMRPRODB

KEY_NAME Module

KEY_VALUE tcserver@sgdcpl03 (TNS V1-V3)

KEY_NAME Client ProcId

KEY_VALUE oracle@sgdcplm02 (TNS V1-V3).76855_140555836445280

OWNER_ID 1

INCIDENT_FILE /u02/app/oracle/diag/rdbms/smrprodb/SMRPRODB/incident/incdir_59256/SMRPRODB_ora_76855_i59256.trc

OWNER_ID 1

INCIDENT_FILE /u02/app/oracle/diag/rdbms/smrprodb/SMRPRODB/trace/SMRPRODB_ora_76855.trc

ADR Home = /u02/app/oracle/diag/clients/user_oracle/host_1505528871_82:

*************************************************************************

0 rows fetched

</ADR_HOME>

<ADR_HOME name="/u02/app/oracle/diag/clients/user_oracle/host_1505528871_82">

ADR Home = /u02/app/oracle/diag/tnslsnr/sgdcplm02/smrpro_listener:

*************************************************************************

0 rows fetched

</ADR_HOME>

<ADR_HOME name="/u02/app/oracle/diag/tnslsnr/sgdcplm02/smrpro_listener">

ADR Home = /u02/app/oracle/diag/tnslsnr/sgdcplm02/listener:

*************************************************************************

0 rows fetched

adrci> show trace /u02/app/oracle/diag/rdbms/smrprodb/SMRPRODB/trace/SMRPRODB_ora_76855.trc

DIA-48908: No trace files are found

adrci> show trace /u02/app/oracle/diag/rdbms/smrprodb/SMRPRODB/incident/incdir_59256/SMRPRODB_ora_76855_i59256.trc

Output the results to file: /tmp/utsout_101863_1397_4.ado

adrci>

£££££££££££££££££££££££££££££££££££££££££££££

ADCRI Example

[oracle@srv6 ~]$ adrci

ADRCI: Release 12.1.0.2.0 - Production on Wed Sep 15 16:41:10 2021

ADR base = "/u01/app/oracle"

adrci> show problem;

DIA-48318: ADR Relation [PROBLEM] of version=3 cannot be supported

ADR Home = /u01/app/oracle/diag/rdbms/test19c/TEST19C:

*************************************************************************

0 rows fetched

ADR Home = /u01/app/oracle/diag/rdbms/orcl12c/orcl12c:

*************************************************************************

PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME

-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------

3 ORA 600 [kewrose_1] 73025 2021-09-15 16:20:05.145000 +05:30

4 ORA 603 78481 2021-09-15 16:30:05.901000 +05:30

6 ORA 600 [ORA-00600: internal error code, arguments: [4193], 78643 2021-09-15 16:31:37.232000 +05:30

2 ORA 600 [600] 78818 2021-09-15 16:35:07.316000 +05:30

1 ORA 600 [4193] 78644 2021-09-15 16:36:00.519000 +05:30

5 ORA 600 [ORA-00600: internal error code, arguments: [4193], 78645 2021-09-15 16:36:09.369000 +05:30

ADR Home = /u01/app/oracle/diag/clients/user_oracle/host_1213252236_82:

*************************************************************************

0 rows fetched

ADR Home = /u01/app/oracle/diag/clients/user_oracle/host_1213252236_110:

*************************************************************************

0 rows fetched

ADR Home = /u01/app/oracle/diag/tnslsnr/srv6/listener:

*************************************************************************

0 rows fetched

ADR Home = /u01/app/oracle/diag/tnslsnr/srv6/listener12c:

*************************************************************************

0 rows fetched

adrci> show incident

DIA-48458: "show incident" failed due to the following errors

DIA-48318: ADR Relation [INCIDENT] of version=5 cannot be supported

ADR Home = /u01/app/oracle/diag/rdbms/test19c/TEST19C:

*************************************************************************

0 rows fetched

ADR Home = /u01/app/oracle/diag/rdbms/orcl12c/orcl12c:

*************************************************************************

INCIDENT_ID PROBLEM_KEY CREATE_TIME

-------------------- ----------------------------------------------------------- ----------------------------------------

61785 ORA 600 [4193] 2021-09-15 12:08:23.344000 +05:30

61753 ORA 600 [4193] 2021-09-15 12:08:34.605000 +05:30

61754 ORA 600 [kewrose_1] 2021-09-15 12:08:42.202000 +05:30

61873 ORA 600 [4193] 2021-09-15 12:08:49.612000 +05:30

61874 ORA 600 [600] 2021-09-15 12:08:57.767000 +05:30

61977 ORA 600 [4193] 2021-09-15 12:09:04.404000 +05:30

61985 ORA 600 [4193] 2021-09-15 12:09:12.321000 +05:30

61994 ORA 600 [ORA-00600: internal error code, arguments: [4193], 2021-09-15 12:09:29.156000 +05:30

67204 ORA 603 2021-09-15 12:09:34.996000 +05:30

67268 ORA 600 [4193] 2021-09-15 13:21:49.255000 +05:30

67364 ORA 600 [4193] 2021-09-15 13:21:56.384000 +05:30

67365 ORA 600 [kewrose_1] 2021-09-15 13:22:02.472000 +05:30

67636 ORA 600 [4193] 2021-09-15 13:22:07.732000 +05:30

67637 ORA 600 [600] 2021-09-15 13:22:17.857000 +05:30

67684 ORA 600 [4193] 2021-09-15 13:22:19.020000 +05:30

67685 ORA 600 [600] 2021-09-15 13:22:32.617000 +05:30

67620 ORA 600 [4193] 2021-09-15 13:25:03.933000 +05:30

67621 ORA 600 [600] 2021-09-15 13:25:09.363000 +05:30

67541 ORA 600 [600] 2021-09-15 13:30:04.647000 +05:30

67542 ORA 603 2021-09-15 13:30:10.228000 +05:30

67544 ORA 600 [kewrose_1] 2021-09-15 13:32:52.639000 +05:30

67558 ORA 600 [600] 2021-09-15 13:45:01.578000 +05:30

67573 ORA 600 [kewrose_1] 2021-09-15 13:51:49.295000 +05:30

67575 ORA 600 [kewrose_1] 2021-09-15 13:51:53.110000 +05:30

67577 ORA 600 [kewrose_1] 2021-09-15 13:51:55.935000 +05:30

72826 ORA 600 [4193] 2021-09-15 14:24:39.977000 +05:30

72827 ORA 600 [600] 2021-09-15 14:24:45.460000 +05:30

67579 ORA 600 [4193] 2021-09-15 14:30:02.207000 +05:30

72828 ORA 600 [600] 2021-09-15 14:30:08.348000 +05:30

67596 ORA 600 [4193] 2021-09-15 14:30:16.874000 +05:30

67597 ORA 600 [kewrose_1] 2021-09-15 14:30:24.285000 +05:30

72834 ORA 600 [4193] 2021-09-15 14:35:02.161000 +05:30

72835 ORA 600 [600] 2021-09-15 14:35:07.577000 +05:30

72829 ORA 600 [4193] 2021-09-15 14:36:49.925000 +05:30

67645 ORA 600 [600] 2021-09-15 15:39:56.800000 +05:30

67653 ORA 600 [600] 2021-09-15 15:40:00.270000 +05:30

67647 ORA 600 [kewrose_1] 2021-09-15 15:40:34.146000 +05:30

72864 ORA 603 2021-09-15 16:15:05.119000 +05:30

72920 ORA 600 [4193] 2021-09-15 16:19:50.912000 +05:30

73024 ORA 600 [4193] 2021-09-15 16:19:58.426000 +05:30

73025 ORA 600 [kewrose_1] 2021-09-15 16:20:05.145000 +05:30

73320 ORA 600 [4193] 2021-09-15 16:20:13.965000 +05:30

73321 ORA 600 [ORA-00600: internal error code, arguments: [4193], 2021-09-15 16:20:24.693000 +05:30

72921 ORA 600 [4193] 2021-09-15 16:20:31.496000 +05:30

72922 ORA 600 [ORA-00600: internal error code, arguments: [4193], 2021-09-15 16:20:40.305000 +05:30

72923 ORA 600 [4193] 2021-09-15 16:20:56.744000 +05:30

72924 ORA 600 [ORA-00600: internal error code, arguments: [4193], 2021-09-15 16:21:04.091000 +05:30

73217 ORA 600 [600] 2021-09-15 16:24:40.940000 +05:30

78481 ORA 603 2021-09-15 16:30:05.901000 +05:30

78537 ORA 600 [4193] 2021-09-15 16:31:16.588000 +05:30

ADR Home = /u01/app/oracle/diag/clients/user_oracle/host_1213252236_82:

*************************************************************************

0 rows fetched

ADR Home = /u01/app/oracle/diag/clients/user_oracle/host_1213252236_110:

*************************************************************************

0 rows fetched

ADR Home = /u01/app/oracle/diag/tnslsnr/srv6/listener:

*************************************************************************

0 rows fetched

ADR Home = /u01/app/oracle/diag/tnslsnr/srv6/listener12c:

*************************************************************************

First 0 rows fetched (*** more available ***)

adrci> show incident -mode detail -p "incident_id= 78537"

DIA-48458: "show incident" failed due to the following errors

DIA-48318: ADR Relation [INCIDENT] of version=5 cannot be supported

ADR Home = /u01/app/oracle/diag/rdbms/test19c/TEST19C:

*************************************************************************

0 rows fetched

<INCIDENT_INFO mode="detail">

<ADR_HOME name="/u01/app/oracle/diag/rdbms/test19c/TEST19C">

ADR Home = /u01/app/oracle/diag/rdbms/orcl12c/orcl12c:

*************************************************************************

**********************************************************

INCIDENT INFO RECORD 1

**********************************************************

INCIDENT_ID 78537

STATUS ready

CREATE_TIME 2021-09-15 16:31:16.588000 +05:30

PROBLEM_ID 1

CLOSE_TIME <NULL>

FLOOD_CONTROLLED none

ERROR_FACILITY ORA

ERROR_NUMBER 600

ERROR_ARG1 4193

ERROR_ARG2 376

ERROR_ARG3 380

ERROR_ARG4 <NULL>

ERROR_ARG5 <NULL>

ERROR_ARG6 <NULL>

ERROR_ARG7 <NULL>

ERROR_ARG8 <NULL>

ERROR_ARG9 <NULL>

ERROR_ARG10 <NULL>

ERROR_ARG11 <NULL>

ERROR_ARG12 <NULL>

SIGNALLING_COMPONENT <NULL>

SIGNALLING_SUBCOMPONENT <NULL>

SUSPECT_COMPONENT <NULL>

SUSPECT_SUBCOMPONENT <NULL>

ECID <NULL>

IMPACTS 0

PROBLEM_KEY ORA 600 [4193]

FIRST_INCIDENT 61785

FIRSTINC_TIME 2021-09-15 12:08:23.344000 +05:30

LAST_INCIDENT 78646

LASTINC_TIME 2021-09-15 16:41:59.817000 +05:30

IMPACT1 34668555

IMPACT2 34668546

IMPACT3 0

IMPACT4 0

KEY_NAME Service

KEY_VALUE SYS$USERS

KEY_NAME PdbName

KEY_VALUE CDB$ROOT

KEY_NAME Client ProcId

KEY_VALUE oracle@srv6.example.com (TNS V1-V3).15950_140061077414528

KEY_NAME Module

KEY_VALUE sqlplus@srv6.example.com (TNS V1-V3)

KEY_NAME ProcId

KEY_VALUE 6.3

KEY_NAME PQ

KEY_VALUE (16777217, 1631703675)

KEY_NAME SID

KEY_VALUE 1.39345

OWNER_ID 1

INCIDENT_FILE /u01/app/oracle/diag/rdbms/orcl12c/orcl12c/incident/incdir_78537/orcl12c_ora_15950_i78537.trc

OWNER_ID 1

INCIDENT_FILE /u01/app/oracle/diag/rdbms/orcl12c/orcl12c/trace/orcl12c_ora_15950.trc

ADR Home = /u01/app/oracle/diag/clients/user_oracle/host_1213252236_82:

*************************************************************************

0 rows fetched

</ADR_HOME>

<ADR_HOME name="/u01/app/oracle/diag/clients/user_oracle/host_1213252236_82">

ADR Home = /u01/app/oracle/diag/clients/user_oracle/host_1213252236_110:

*************************************************************************

0 rows fetched

</ADR_HOME>

<ADR_HOME name="/u01/app/oracle/diag/clients/user_oracle/host_1213252236_110">

ADR Home = /u01/app/oracle/diag/tnslsnr/srv6/listener:

*************************************************************************

0 rows fetched

</ADR_HOME>

<ADR_HOME name="/u01/app/oracle/diag/tnslsnr/srv6/listener">

ADR Home = /u01/app/oracle/diag/tnslsnr/srv6/listener12c:

*************************************************************************

0 rows fetched

adrci> exit

[oracle@srv6 ~]$

Purge example

oracle@PLM01:~> adrci

ADRCI: Release 12.1.0.2.0 - Production on Mon Oct 11 07:38:30 2021

ADR base = "/u01/app/oracle"

adrci> show homes

ADR Homes:

diag/rdbms/smrprodb_dr/SMRPRODB_DR

diag/rdbms/smrtestenv/SMRTESTENV

diag/rdbms/smrpatch7/SMRPATCH7

diag/rdbms/smrminddev/SMRMINDDEV

diag/rdbms/smrrac/smrrac2

diag/rdbms/smrprod/SMRPROD2

diag/clients/user_oracle/host_1450352090_82

diag/clients/user_grid/host_1450352090_82

diag/clients/user_root/host_1450352090_82

diag/tnslsnr/PLM01/listener

diag/tnslsnr/PLM01/listener_standalone

adrci> set homes diag/rdbms/smrprod/SMRPROD2

minutes =7200 = 5 days

adrci> purge -age 7200 -type TRACE

adrci> purge -age 7200 -type ALERT

###########################

oracle@srv1:~> adrci

ADRCI: Release 12.1.0.2.0 - Production on Fri Oct 8 13:13:08 2021

ADR base = "/u01/app/oracle"

adrci> show homes

ADR Homes:

diag/rdbms/rac/rac1

diag/clients/user_oracle/host_775046424_82

adrci> set homes diag/rdbms/rac/rac1

adrci> purge -age 30240 -type TRACE

adrci> purge -age 7200 -type TRACE

adrci> purge -age 3600 -type TRACE

adrci> show incident

ADR Home = /u01/app/oracle/diag/rdbms/rac/rac1:

*************************************************************************

INCIDENT_ID PROBLEM_KEY CREATE_TIME

-------------------- ----------------------------------------------------------- ----------------------------------------

29297 ORA 7445 [kghfre] 2021-07-23 19:38:24.079000 +05:30

67698 ORA 7445 [kghfre] 2021-09-06 12:29:34.844000 +05:30

67699 ORA 7445 [kspgip] 2021-09-06 12:29:35.390000 +05:30

129604 ORA 603 2021-10-07 16:38:05.466000 +05:30

129605 ORA 603 2021-10-07 16:38:16.733000 +05:30

129606 ORA 603 2021-10-07 16:38:27.237000 +05:30

6 rows fetched

adrci> purge -i 29297

adrci> purge -i 67698

adrci> show alert -p "message_text like '%ORA-%'"

ADR Home = /u01/app/oracle/diag/rdbms/rac/rac1:

*************************************************************************

Output the results to file: /tmp/alert_19058_1400_rac1_1.ado

Additional information: 256

Additional information: 2

adrci>

Alert log in linux

adrci> show alert -p "message_text like '%ORA-%'"

ADR Home = /u01/app/oracle/diag/rdbms/rac/rac1:

*************************************************************************

Output the results to file: /tmp/alert_19058_1400_rac1_1.ado

2021-09-27 18:21:41.381000 +05:30

Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_psp0_4298.trc:

ORA-27300: OS system dependent operation:fork failed with status: 11

ORA-27301: OS failure message: Resource temporarily unavailable

ORA-27302: failure occurred at: skgpspawn5

Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_ora_4415.trc:

ORA-00443: background process "CJQ0" did not start

ORA-450 signalled during: ALTER DATABASE OPEN /* db agent *//* {1:59059:2} */...

2021-10-07 16:35:58.207000 +05:30

Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_psp0_4856.trc:

ORA-27300: OS system dependent operation:fork failed with status: 11

ORA-27301: OS failure message: Resource temporarily unavailable

ORA-27302: failure occurred at: skgpspawn5

2021-10-07 16:35:59.208000 +05:30

Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_ora_5067.trc:

ORA-00443: background process "GTX0" did not start

Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_ora_5067.trc:

ORA-00450: background process 'GTX0' did not start

ORA-00443: background process "GTX0" did not start

Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_ora_5067.trc:

ORA-00450: background process 'GTX0' did not start

ORA-00443: background process "GTX0" did not start

2021-10-07 16:36:00.424000 +05:30

ORA-1092 signalled during: ALTER DATABASE OPEN /* db agent *//* {1:63819:2} */...

opiodr aborting process unknown ospid (5067) as a result of ORA-1092

ORA-1092 : opitsk aborting process

2021-10-07 16:36:22.942000 +05:30

Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_psp0_5952.trc:

ORA-27300: OS system dependent operation:fork failed with status: 11

ORA-27301: OS failure message: Resource temporarily unavailable

ORA-27302: failure occurred at: skgpspawn3

2021-10-07 16:36:27.142000 +05:30

Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_psp0_5952.trc:

ORA-27300: OS system dependent operation:fork failed with status: 11

ORA-27301: OS failure message: Resource temporarily unavailable

ORA-27302: failure occurred at: skgpspawn5

Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_psp0_5952.trc:

ORA-27300: OS system dependent operation:fork failed with status: 11

ORA-27301: OS failure message: Resource temporarily unavailable

ORA-27302: failure occurred at: skgpspawn5

Errors in file /u01/app/oracle/diag/rdbms/rac/rac1/trace/rac1_psp0_5952.trc:

ORA-27300: OS system dependent operation:fork failed with status: 11

ORA-27301: OS failure message: Resource temporarily unavailable

"/tmp/alert_19058_1400_rac1_1.ado" 97L, 5774C

window ADRCI Alert :

ADR base = "C:\app\varunyadav"

adrci>

adrci> show alert

Choose the home from which to view the alert log:

1: diag\rdbms\orcl\orcl

2: diag\tnslsnr\2762VARUNY0000L\listener

Q: to quit

Please select option: 1

Output the results to file: C:\Users\VARUNY~1\AppData\Local\Temp\alert_16440_20588_orcl_1.ado

Please select option: 2

Output the results to file: C:\Users\VARUNY~1\AppData\Local\Temp\alert_16440_20588_listener_2.ado

Please select option: q

adrci>

File upload

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<form action="18decres.php" method="post" enctype="multipart/form-data" target="_blank">
<table>
<tr><td>
<h1 align="center"><u><b>LETTER HEAD</b></u></h1><br />
<hr>
<h6 align="right">Photo<input type="hidden" name="MAX_FILE_SIZE" value="10000000" />
<input name="image" type="file" />
</h6><p align="right"><em><small><text align="right">
To be attested by head of office</small></em></p><BR>
<h5><b>Subject: </b>Verification of employement for <input type="text" name="a" size="10"/> [employee name] to NIC Certifying Authority.</h5>

<p>This letter is to confirm that <input type="text" name="b" size="10"/>[<i>DSC Applicant Name</i>] is working in <input type="text" name="c" size="10"/>[<i>Organisation name</i>] as <input type="text" name="d" size="10"/>[<i>Designation</i>]. He/She has been working in this organisation since<input type="text" name="e" size="10"/> [<i>Date of joining</i>].His/Her tenure is till <input type="text" name="f" size="10"/>[<i>date of superannuation/end of contract</i>]
<br />
<br />
<br />
<b><u>Additional declaration for contactual employees:</u></b><br />
<input type="text" name="g" size="10"/>[<i>DSC Applicant Name</i>] is working in<input type="text" name="h" size="10"/> [<i>Organisation name</i>]. His/Her contract is valid from <input type="text" name="i" size="10"/>to <input type="text" name="j" size="10"/>.
<table>
<tr><td align="right">Yours Sincerely,<br />
[<i>Head of Office/Office-In-Charge (for contract employee)</i>]<br />
<input type="text" name="k" size="10"/> [<i>Name of Officer,Designation,Office Stamp</i>]
</td>
</tr></table>
<em><small>
<input type="submit" name="submit" value="Save Changes" />
</small></em></td></tr></table>
</form>
</body>
</html>

Wednesday, 19 December 2012

Storing image in database using php/ mysql

First in this tutorial, creating web form and posting data on next page ,as image and data stored on table. I have mention 3 details below.
1. Creating Web form
2. Storing Image on database using Page 2
3. Table created where value is stored.
===================================================================

Page 1-----
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<form action="18decres.php" method="post" enctype="multipart/form-data" target="_blank">
<table>
<tr><td>
<h1 align="center"><u><b>LETTER HEAD</b></u></h1><br />
<hr>
<h6 align="right">Photo<input type="hidden" name="MAX_FILE_SIZE" value="10000000" />
<input name="image" type="file" />
</h6><p align="right"><em><small><text align="right">
To be attested by head of office</small></em></p><BR>
<h5><b>Subject: </b>Verification of employement for <input type="text" name="a" size="10"/> [employee name] to NIC Certifying Authority.</h5>

<p>This letter is to confirm that <input type="text" name="b" size="10"/>[<i>Applicant Name</i>] is working in <input type="text" name="c" size="10"/>[<i>Organisation name</i>] as <input type="text" name="d" size="10"/>[<i>Designation</i>]. He/She has been working in this organisation since<input type="text" name="e" size="10"/> [<i>Date of joining</i>].His/Her tenure is till <input type="text" name="f" size="10"/>[<i>dact</i>]
<br />
<br />
<br />
<b><u>Additional declaration forxxxxxxxxxxxs:</u></b><br />
<input type="text" name="g" size="10"/>[<i>DSC Applicant Name</i>] is working in<input type="text" name="h" size="10"/> [<i>Organisation xxxx</i>]. His/Her contract is valid from <input type="text" name="i" size="10"/>to <input type="text" name="j" size="10"/>.
<table>
<tr><td align="right">Yours Sincerely,<br />
[<i>xxxxxxxxe (xxxxxxxx)</i>]<br />
<input type="text" name="k" size="10"/> [<i>xxxxxzzzzzzzxxxxxmp</i>]
</td>
</tr></table>
<em><small>
<input type="submit" name="submit" value="Save Changes" />
</small></em></td></tr></table>
</form>
</body>
</html>

===================================================================

Page 2..

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<?php
$a = $_POST['a'];
$b = $_POST['b'];
$c = $_POST['c'];
$d = $_POST['d'];
$e = $_POST['e'];
$f = $_POST['f'];
$g = $_POST['g'];
$h = $_POST['h'];
$i = $_POST['i'];
$j = $_POST['j'];
$k = $_POST['k'];
?>
<form action="" method="post">
<table>
<tr><td>
<h1 align="center"><u><b>LETTER HEAD</b></u></h1><br />
<hr>
<h6 align="right">Photo<?php error_reporting (E_ALL ^ E_NOTICE); ?>

</h6><p align="right"><em><small><text align="right">
To be attested by head of office</small></em></p><BR>
<h5><b>Subject: </b>Verification of employement for <b><?php echo $a;?> to NIC Certifying Authority.</h5>

<p>This letter is to confirm that <b><?php echo $b;?></b> is working in <b> <?php echo $c;?></b> as <b><?php echo $d;?></b>.He/She has been working in this organisation since <b><?php echo $e;?></b>. His/Her tenure is till <b><?php echo $f;?></b>
<br />
<br />
<br />
<b><u>Additional declaration for contactual employees:</u></b><br />
<b><?php echo $g;?></b> is working in <b><?php echo $h;?></b>. His/Her contract is valid from <b><?php echo $i;?></b> to <b><?php echo $j;?></b>.
<table>
<tr><td align="right">Yours Sincerely,<br />
[<i>Head of Office/Office-In-Charge (for contract employee)</i>]<br />
<b><?php echo $k;?></b>
</td>
</td></tr>
</td></tr></table>
</form>
<?php
if (isset($_POST['submit']) && $_FILES['image']['size'] > 0) {
$fileName = $_FILES['image']['name'];
$tmpName = $_FILES['image']['tmp_name'];
$fileSize = $_FILES['image']['size'];
$fileType = $_FILES['image']['type'];

$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if (!get_magic_quotes_gpc()) {
$fileName = addslashes($fileName);
}
$objConnect = mysql_connect("localhost", "root", "") or die(mysql_error());
$objDB = mysql_select_db("database name");

//$query = "INSERT INTO upload (name, size, type, content ) ".
//"VALUES ('$fileName', '$fileSize', '$fileType', '$content')";
//mysql_query($query) or die('Error, query failed');

//echo "<br>File $fileName uploaded<br>";
//$certi = serialize($_POST['cbcretificate']);
// $objConnect = mysql_connect("localhost","root","123456") or die(mysql_error());
//$objDB = mysql_select_db("phpmyadmin");
//$cbcretificate = $_POST['cbcretificate'];
//$cbcretificate=$_POST["cbcretificate"];
//while (list ($key,$val) = @each ($cbcretificate))
//{echo "$val,";
//}
//$selected_colors = "";
//foreach ($cbcretificate as $cbcretificate) {
//$selected_cert .= $cbcretificate . ", ";
//}
//$selected_cert = substr($selected_cert, 0, -2);
//implode(',', $_POST['cbcretificate']);
//$cbcretificate=serialize($_POST['cbcretificate']); //takes the data from a post operation...
//$media_array = $_POST['cbcretificate'];
//foreach ($media_array as $one_media) {
//$source .= $one_media.", ";
//}
//$media = substr($source, 0, -2);$q1 = "select * from firstpagetable4 where ApplicantID IN (select max(ApplicantID) from firstpagetable4) ";
$q2 = "select * from sc_scr_print_new1 where ApplicantID IN (select max(ApplicantID) from sc_scr_print_new1) ";

$res1 = mysql_query($q2);
$output_str2 = ' ';
while ($row = mysql_fetch_assoc($res1)) {

$output_str2 .= ($row['ApplicantID'] + 1); //the site link is for example
// $output_str .= '<a href="pdf.php' . $row["max(ApplicantID)+1"] . '"> Click here to generate PDF</a>' . $tab;
//echo" <h1>'<a href="pdf.php?postid=' . $row["max(ApplicantID)+1"] . '">Click here to generate PDF</a>'.$tab;
}

$strSQL = "INSERT INTO letter ";

$strSQL .="(ApplicantID,name,size,type,content,a,b,c,d,e,f,g,h,i,j,k) ";
$strSQL .="VALUES ";
$strSQL .="('','" . $fileName . "','" . $fileSize . "','" . $fileType . "','" . $content . "','" . $_POST["a"] . "','" . $_POST["b"] . "' ";
$strSQL .=",'" . $_POST["c"] . "','" . $_POST["d"] . "','" . $_POST["e"] . "' ";
$strSQL .=",'" . $_POST["f"] . "'";
$strSQL .=",'" . $_POST["g"] . "','" . $_POST["h"] . "','" . $_POST["i"] . "','" . $_POST["j"] . "','" . $_POST["k"] . "')";
$objQuery = mysql_query($strSQL);

printf(" Your Applicant ID is %d\n", mysql_insert_id());

//$lastid=mysql_insert_id();
if ($objQuery) {
echo ".";
} else {
echo "Error Save [" . $strSQL . "]";
}
$inserted_id = mysql_insert_id();
//$strsql1="Select Image from Applicantform22";
//$result_last_id=mysql_query($strsql1);

mysql_close($objConnect);
}
?>

</body>
</html>

=============================================================

Table

CREATE TABLE IF NOT EXISTS `letter` (

`ApplicantID` mediumint(9) NOT NULL AUTO_INCREMENT,

`name` varchar(30) NOT NULL,

`size` int(11) DEFAULT NULL,

`type` varchar(20) DEFAULT NULL,

`content` mediumblob,

`a` varchar(30) NOT NULL,

`b` varchar(30) NOT NULL,

`c` varchar(30) NOT NULL,

`d` varchar(30) NOT NULL,

`e` varchar(30) NOT NULL,

`f` varchar(30) NOT NULL,

`g` varchar(30) NOT NULL,

`h` varchar(30) NOT NULL,

`i` varchar(30) NOT NULL,

`j` varchar(30) NOT NULL,

`k` varchar(30) NOT NULL,

PRIMARY KEY (`ApplicantID`)

) ;