Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[ORACLE 10g]You are no longer connected to ORACLE[windows xp]

2636406Mar 26 2014 — edited Mar 27 2014

Why i am getting this error after running 2 or 3 queries ?


SQL> connect system

Enter password:

Connected.

SQL> connect / as sysdba

ERROR:

ORA-01031: insufficient privileges


Warning: You are no longer connected to ORACLE.

SQL>





Alert_XE.log file

Wed Mar 26 10:02:20 2014

Shutting down instance: further logons disabled

Wed Mar 26 10:02:21 2014

Stopping background process QMNC

Wed Mar 26 10:02:22 2014

Stopping background process CJQ0

Wed Mar 26 10:02:23 2014

Stopping background process MMNL

Wed Mar 26 10:02:24 2014

Stopping background process MMON

Wed Mar 26 10:02:25 2014

Shutting down instance (immediate)

License high water mark = 1

Wed Mar 26 10:02:25 2014

Stopping Job queue slave processes

Wed Mar 26 10:02:25 2014

Job queue slave processes stopped

Waiting for dispatcher 'D000' to shutdown

All dispatchers and shared servers shutdown

Wed Mar 26 10:02:32 2014

alter database close normal

Wed Mar 26 10:02:33 2014

SMON: disabling tx recovery

SMON: disabling cache recovery

Wed Mar 26 10:02:34 2014

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Thread 1 closed at log sequence 20

Successful close of redo thread 1

Wed Mar 26 10:02:34 2014

Completed: alter database close normal

Wed Mar 26 10:02:34 2014

alter database dismount

Completed: alter database dismount

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

ARCH: Archival disabled due to shutdown: 1089

Shutting down archive processes

Archiving is disabled

Archive process shutdown avoided: 0 active

Dump file c:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log

Wed Mar 26 10:03:00 2014

ORACLE V10.2.0.1.0 - Production vsnsta=0

vsnsql=14 vsnxtr=3

Windows XP Version V5.1 Service Pack 3

CPU                 : 4 - type 586, 2 Physical Cores

Process Affinity    : 0x00000000

Memory (Avail/Total): Ph:1391M/2713M, Ph+PgF:2921M/4603M, VA:1945M/2047M

Wed Mar 26 10:03:00 2014

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Picked latch-free SCN scheme 2

Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST

Autotune of undo retention is turned on. 

IMODE=BR

ILAT =10

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.1.0.

System parameters with non-default values:

  sessions                 = 49

  __shared_pool_size       = 201326592

  __large_pool_size        = 12582912

  __java_pool_size         = 4194304

  __streams_pool_size      = 0

  spfile                   = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA

  sga_target               = 805306368

  control_files            = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF

  __db_cache_size          = 583008256

  compatible               = 10.2.0.1.0

  db_recovery_file_dest    = C:\oraclexe\app\oracle\flash_recovery_area

  db_recovery_file_dest_size= 10737418240

  undo_management          = AUTO

  undo_tablespace          = UNDO

  remote_login_passwordfile= EXCLUSIVE

  dispatchers              = (PROTOCOL=TCP) (SERVICE=XEXDB)

  shared_servers           = 4

  job_queue_processes      = 4

  audit_file_dest          = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP

  background_dump_dest     = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP

  user_dump_dest           = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP

  core_dump_dest           = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP

  db_name                  = XE

  open_cursors             = 300

  os_authent_prefix        = 

  pga_aggregate_target     = 268435456

PMON started with pid=2, OS id=196

PSP0 started with pid=3, OS id=5472

MMAN started with pid=4, OS id=2004

DBW0 started with pid=5, OS id=5972

LGWR started with pid=6, OS id=5624

CKPT started with pid=7, OS id=2728

SMON started with pid=8, OS id=4252

RECO started with pid=9, OS id=5496

CJQ0 started with pid=10, OS id=3952

MMON started with pid=11, OS id=5068

Wed Mar 26 10:03:00 2014

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

MMNL started with pid=12, OS id=3760

Wed Mar 26 10:03:00 2014

starting up 4 shared server(s) ...

Oracle Data Guard is not available in this edition of Oracle.

Wed Mar 26 10:03:00 2014

alter database mount exclusive

Wed Mar 26 10:03:04 2014

Setting recovery target incarnation to 2

Wed Mar 26 10:03:04 2014

Successful mount of redo thread 1, with mount id 2724348820

Wed Mar 26 10:03:04 2014

Database mounted in Exclusive Mode

Completed: alter database mount exclusive

Wed Mar 26 10:03:04 2014

alter database open

Wed Mar 26 10:03:05 2014

Thread 1 opened at log sequence 20

  Current log# 1 seq# 20 mem# 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_1_9M24W0BQ_.LOG

Successful open of redo thread 1

Wed Mar 26 10:03:05 2014

SMON: enabling cache recovery

Wed Mar 26 10:03:08 2014

Successfully onlined Undo Tablespace 1.

Wed Mar 26 10:03:08 2014

SMON: enabling tx recovery

Wed Mar 26 10:03:08 2014

Database Characterset is AL32UTF8

replication_dependency_tracking turned off (no async multimaster replication found)

Starting background process QMNC

QMNC started with pid=19, OS id=5504

Wed Mar 26 10:03:11 2014

Completed: alter database open

Wed Mar 26 10:03:12 2014

db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Wed Mar 26 10:03:19 2014

Memory Notification: Library Cache Object loaded into SGA

Heap size 2208K exceeds notification threshold (2048K)

KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw== 


Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 24 2014
Added on Mar 26 2014
15 comments
9,463 views