Server Administration :: Database Can't Be Started
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
ADVERTISEMENT
Sep 3, 2010
I have oracle 8i installed on a Windows XP with SP2 PC. Everytime i start the pc the database is not getting started automatically however i need to start it manually using the svrmgrl command. How to autostart the database.
View 1 Replies
View Related
May 23, 2012
we encounter a problem with a 2-nodes RAC with 11gR2 SE : Database RAC is correctly running but we encounter problems using RAC TNS entry, obtaining the message ORA-01033.We can access to the DB using a TNS entry using each one of IP addresses but when we use the SCAN address, it fails. 2 weeks ago RAC2 node could connect perfectly with the SCAN address but RAC1 (used as a client) obtained error message almost 30% of tries.
We made a reboot of RAC1 node and now SCAN address works correctly from RAC1 and RAC2 (used as a client) fails systematically with SCAN address but works perfectly with direct access to the database.On both nodes, SCAN address is perfectly resolved by DNS server, cluster seems correct, listeners seems correct...We have opened an SR on Metalink 4 weeks ago but we don't progress.
View 4 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
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
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 5, 2010
I'm connecting from SQL Server to ORACLE (ORACLE is linkedserver) and I'm trying to find out when ORACLE started and how long it has been running. Is there query or command in ORACLE that I can use to check this? Is there more than one option to find this out and is it same for all ORACLE versions or diffferent from version to version?
View 1 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
Sep 13, 2012
I've changed the ip address of the enterprise manager grid control server. But oms could not be started. I got the error below:
[oracle@YDFULGRID bin]$ ./emctl start oms
Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright © 1996, 2010 Oracle Corporation. All rights reserved.
Starting WebTier...
WebTier Successfully Started
Starting Oracle Management Server...
Oracle Management Server Could Not Be Started
Oracle Management Server is not functioning because of the following reason:
Connection to the repository failed. Verify that the repository connection information provided is correct.
Please check /oracle/gc_inst/em/EMGC_OMS1/sysman/log/emctl.log for error details
When i checked the log:
I am getting this error:
2012-09-13 16:23:56,602 [main] DEBUG oms.StatusOMSCmd processStatusOMS.155 - Using http port.
2012-09-13 16:23:56,602 [main] DEBUG oms.StatusOMSCmd processStatusOMS.195 - Attempting to connect to servername
2012-09-13 16:24:17,638 [main] DEBUG oms.StatusOMSCmd processStatusOMS.200 - page status code is 503
2012-09-13 16:24:17,638 [main] DEBUG oms.StatusOMSCmd processStatusOMS.202 - header is 3
2012-09-13 16:24:17,639 [main] INFO wls.OMSController statusOMS.950 - statusOMS finished with result: 3
View 2 Replies
View Related
Jan 11, 2011
i am configuring asm on clusterware when i create instance on node1 and node 2 a message screen appear " Cant start asm instance on node 2)When i start asm instance manually on node 2 i found the below error in alert log file.
ORA-27508 IPC error sending a message
ORA-27300 OS system dependent operation:send msg failed with status: 101
ORA-27301 OS failure message: Network is unreachable
ORA-27302 failure occurred at: sskgxpsnd1
View 3 Replies
View Related
Dec 15, 2012
I tried updating the oracle database from version 11.2.0.1 to 11.2.0.3 but I have no clear procedure. I chose the option of the installer "upgrade database" and install the software on a new home. To migrate, must be all oracle services stopped? In the migration phase, it is normal to ask me listener data, etc .... or installer now detects the same database?
View 1 Replies
View Related
Mar 8, 2013
I am using oracle 10gXE just for basic practice but its showing following Errors
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 8 11:46:34 2
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys as sysdba
Enter password:
Connected to an idle instance.
SQL>
SQL>
SQL>
SQL> startup;
ORA-01081: cannot start already-running ORACLE - shut it down fir
SQL>
SQL>
SQL>
SQL> select * from dept;
select * from dept
[code]....
View 3 Replies
View Related
Jun 26, 2012
I want to migrate our production database from 9.2.0.8.0 to 10.2.0.4.0 through startup migrate ,so request you to kindly provide me a step by step doc or some reference link pertaining with same.
View 2 Replies
View Related
Apr 27, 2010
MY oracle database is not starting ,at startup its giving me following error message .
ORA-00600: internal error code, arguments: [kccext_info_4], [], [], [], [], [],[], []
Alert Log file showing following message ,
Tue Apr 27 14:22:26 2010
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Tue Apr 27 14:22:26 2010
ARC1: Becoming the heartbeat ARCH
Tue Apr 27 14:22:26 2010
db_recovery_file_dest_size of 2048 MB is 36.88% used.
This is auser-specified limit on the amount of space that will be used by thisdatabase for recovery-related files, and does not reflect the amount ofspace available in the underlying filesystem or ASM diskgroup.Tue Apr 27 14:22:27 2010Errors in file h:oracleproduct10.2.0adminorcl4udumporcl4_ora_3704.trc:ORA-00600: internal error code, arguments: [kccext_info_4], [], [],
[code]...
If i connect with scott user ,following message occurs ,
ORA-01033: ORACLE initialization or shutdown in progress
View 2 Replies
View Related
Feb 2, 2012
how can i copy to a RAC database which managered by ASM to another new host? just as clone.
View 6 Replies
View Related
Feb 16, 2011
If have several databases running on a 10.2.0.4 Oracle Home. I want to upgrade one of them to 10.2.0.5. My thinking is that I install 10.2 to another location e.g. /u01/app/oracle/product/10.2.0.5 and patch this OH to 10.2.0.5. Regarding the steps to upgrade a particular database. Oracle documentation as I'm unable to locate?
View 11 Replies
View Related
Feb 5, 2012
How can i delete a database? i using the dbca,but the Delate a Database can not use,why?
View 3 Replies
View Related
Aug 18, 2010
Is there any script to run or a way in oracle database to get the whole database structure such as (Tablespaces, schemas, datafiles, redo-log files, tables(structure), views....etc) plus the number of daily transactions and operations happens such as (insert, delete, update,...etc)
Generally, a fully detailed report of my database structure, changes in structure and daily DML operations.
View 4 Replies
View Related
Jan 20, 2013
currently holding 9i database on win2000 and front end is dev4.5 so the thing is want to upgrade by win2008 pn 32bit with 10gdatabase want to keep the front end application as it is 4.5...
will it be compiatble 10g database on 32bit 2008 and front end 4.5developer forms and reports?
can i migrate 9i database to 10g database, what are the steps for full import??
View 1 Replies
View Related
Mar 31, 2011
my colleague added a new node to RAC yesterday, i found that can not access via IE, but dispaly em has started in background.
g841o-db134-> emctl start dbconsole
TZ set to PRC
Oracle Enterprise Manager 10g Database Control Release 10.2.0.4.0
Copyright (c) 1996, 2007 Oracle Corporation. All rights reserved.
"***/em/console/aboutApplication"
Starting Oracle Enterprise Manager 10g Database Control ............................ started.
[code]....
View 1 Replies
View Related
Jul 30, 2002
ERROR : ORA-01034 ORACLE not avaiable.....
All Services are running (Start)....but Local Database is not opening ?
How i can got my data in Local DATABASE ?
View 39 Replies
View Related
