I've been working to create (via script) this database for the last 2 days.. everytime I startup in nomount mode (as sysdba), it displays this error:
$ echo $ORACLE_SID
elams
$
$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Mar 7 09:41:26 2011
[code]....
I have install Oracle 10g Database software in Red Hat 5.9 64bit. When I want to create a database manually (not using DBCA) I am getting errors like follow:
[oracle@t24app2 ~]$ export ORACLE_SID=dbend08
[oracle@t24app2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jun 19 16:19:37 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR: ORA-12154: TNS:could not resolve the connect identifier specified
Enter user-name: I am trying to connect as host not using Tns file info.
how to create database manually(without dbca).
View 2 Replies View RelatedI am trying to make database manually and i am successfully created it,but when i am trying to run catalog.sql and catproc.sql my database get dismount automatically. i also tried to upgrade it via search results on problem but i found this below error when i am typing startup.
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
i got an error while creating database manually
View 26 Replies View RelatedI am still getting the erros.
C:>set oracle_sid = sidname C:>set oracle_sid oracle_sid = sidname
C:>sqlplus SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 21 01:49:06 2011 Copyright (c)
[code]....
I got this error after i patch to 10.2.0.4.0. Before patch, database running smooth.
I shutdown as usual using shutdown only.
how to create a new database in oracle??
View 2 Replies View RelatedI have created a database in Oracle10g which is working fine. Now when I try to create another the system gives the following error.
ORA-12560: TNS protocol adapter error.
I installed Oracle 11gR2 withouth creating a database in my laptop. Later when I tried to crete the database using DBCA it shows error ORA-01078:failure in processing system parameters.I clicked on ignore error, then shows the error ORA-01034: Oracle not available.
View 4 Replies View RelatedI am getting a ORA-03114 (not connected to Oracle) error when I am creating a DB using DBCA. Here are the steps that I do:
1) Log onto the server remotely, using Exceed Query
2) Connect as the oracle user (Oracle)
3) set ORACLE_HOME, PATH
4) Run DBCA, give parameters
At around 12% and again at 19%, I get the error (see screenshot). I also tried to generate the scripts and run them remotely, and the steps run successfully upto & including the step " startup nomount pfile="/oracle/admin/<dbname>/scripts/init.ora"; ". After that, when I try to run the script specified in rmanRestoreDatafiles.sql from SQL> prompt, the error appears, and connection to ORACLE is lost.
Googling the error shows that it is a connectivilty issue, and Oracle says that it is usually caused by user scripts. But I am not running any user-created scripts as part of the DBCA process. Somehow, the instance is timing out immediately after doing the "startup nomount".
This is on a vmware virtual server on Windows 2008R2 using ORACLE 11g R2 with patch set 6
I installed ORACLE (software only) and applied patch set 6 and tried to create a new database.
during the database creation I got an error as the system was adding the JVM that read:-
ORA-01927:cannot REVOKE privileges you did not grant.
I was given the options to ignore or abort
I chose to ignore the error and continue.
After the database creation completed I looked in the jserver log copied below and found two errors
I did not get the same error before installing patch set 6
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
No errors.
alter system flush shared_pool
drop role javauserpriv
[Code].....
SQL> ALTER DATABASE MOUNT;
数据库已更改。
SQL> COL ERROR FOR A10
SQL> SELECT *FROM V$RECOVER_FILE
[code]...
i can't open the db.
While creating the index we are getting the error "ORA-00603: ORACLE server session terminated by fatal error".
We have the space in tablespaces and also in the file systesm.
I am currently running my production database server on win 2003 with oracle9i, I want to create a physical standby server, so I had created new server with same configuration. Need command to apply these datafiles and archives which are generating everyday in my primary database server.
View 1 Replies View RelatedI have a fresh server with no databases. The processes is to create database using a custom script cr_db, this invokes dbca saliently.
While creating a new database i faced the below error: -
Cleaning up failed steps
DBCA_PROGRESS : 4%
Creating and starting Oracle instance
DBCA_PROGRESS : 6%
DBCA_PROGRESS : 7%
DBCA_PROGRESS : 8%
ORA-01501: CREATE DATABASE failed
ORA-01101: database being created currently mounted by some other instance
ORA-01501: CREATE DATABASE failed
ORA-01101: database being created currently mounted by some other instance
DBCA_PROGRESS : 100%
There are no databases in the server : -
[oracle@lxx0019:/prd/dvp/ora/app/oracle/admin/LDD/diag/rdbms/ldd/LDD/trace]# ps -ef | grep pmon oracle 27784 10729 0 10:52 pts/3 00:00:00 grep pmon
i want to create tablespace in raw partion on windows.I have added a hard disk and added extended partition to it. Then created 4 logical partitions of 256 MB with diskpart.exe.I have assigned a drive letter to one of them as X:
However, I am having trouble in creating tablespace on it. I referred to [URL]... I get following error,
C:UsersAdministrator>sqlplus
SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 17 15:32:17 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: SYSTEM
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing opti
SQL> create tablespace exampletb datafile '\.X:accounting_1' size 100;
create tablespace exampletb datafile '\.X:accounting_1' size 100
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required
SQL> create tablespace exampletb datafile '\.X:accounting_1' size 502;
create tablespace exampletb datafile '\.X:accounting_1' size 502
[code]...
I'm new at administrating a database (10gR2 on RHEL5).
1)What are the things need to be considered while creating tablespace?
2)What factors need to be considered when adding space to a tablespace?
whenever i tried to create spfile from pfile i got this error...oracle not available and shared memory realme does not exist.
View 10 Replies View Relatedcreate an ASM (Automatic Storage Management) instance using dbca. At first try I mistakenly skipped the part where I click on ASM Parameters to add /dev/raw/raw* as my asm_diskstring so it created an ASM instance. When I get to the next page ASM Disk Groups, I selected Create New and I did not have the desired display, because of the step I missed.
I went back to do some cleaning up as follows:
1) Edit the oratab file to remove the ASM entry
2) backed up these files by renaming to old-<filename>
old-ab_+ASM.dat
old-hc_+ASM.dat
old-lk+ASM
old-orapw+ASM
old-spfile2+ASM.ora
3) killed the following processes (kill -9):
oracle 1590 1 0 22:52 ? 00:00:00 asm_pmon_+ASM
oracle 1592 1 0 22:52 ? 00:00:00 asm_psp0_+ASM
oracle 1594 1 0 22:52 ? 00:00:00 asm_mman_+ASM
oracle 1596 1 0 22:52 ? 00:00:00 asm_dbw0_+ASM
oracle 1598 1 0 22:52 ? 00:00:00 asm_lgwr_+ASM
[code]....
4) Run the following as root:
/u01/app/oracle/product/10.2.0/db_1/bin/localconfig delete
5) Restarted the database
Now when I try to go through the steps to create an ASM instance, at the point after I enter my ASM Parameters, I get the following prompt:
"DBCA will now create and start the ASM instance. After the ASM instance is started you can create the diskgroups to be used as storage for your database."
I click OK. Then I get the error message:
ORA-01012 not logged on
How to
1) to define a job in oracle9i for solaris
2) to schedule this job
Remember i have prior experience deploying jobs at windows platform but when i try it on (9i for ) solaris, the script does not work as it does not accept a submit job request.
what is the Minimum datafile size required for creating a non-system tablespace?
I am trying to create a tablespace by giving the syntax like,
SQL> create tablespace t1
2 datafile '/home/data/t1.dbf' size 72k;
create tablespace t1
*
ERROR at line 1:
ORA-03214: File Size specified is smaller than minimum required
SQL> create tablespace t1
2 datafile '/home/data/t1.dbf' size 73k;
Tablespace created.
The blocksize for my database is 4096, as i have heard that the minimum size of the datafile is decided by blocksize, but i want to know that how it is calculated as by giving the above syntax the other values will be default. I am trying the syntax in oracle 9.2.0.1.0 version.
i have win 2008 server and oracle 10g when im try to install oracle it terminate successfully but when insall domain controller in windows , oracle dont terminate the installation and break in creating data base (2%) and return the error message : ora-12560 tns adaptator protocol error
View 1 Replies View Relatedwhen i connected with oracle user i got error message like "
ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_APPLICATION_INFO.SET_MODULE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
"
using pl/sql code i am creating text file on specific path of database server. i need to compress this file .how to compress the text file using pl/sql?
View 1 Replies View RelatedI am trying to create the Physical StandBy Database in the same server. Till last 2 Final steps, everything went on well. In the final steps, when I try to open the StandBy Database, it throws the following Error:
*******************************************************
SQL...> alter database open;
alter database open
*
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
I tried creating the Physical Standby with the following Steps.into that & tell me whether I have done any mistake.Also tell me any step I have missed from the following list of steps:
Environment: Oracle Release 10.2.0.1.0 / Windows 2003 Server Enterprise Edition SP2
Primary DB = 'PrimDB'
StandBy DB to be created = 'StBy1DB'
In the same Server, location for
PrimDB datafiles = 'F:\oracle\product\10.2.0\oradata\PrimDB\Data\',
StandBy Datafiles = 'E:\StandBy_DB\Data\'
[code]...
ERROR at line 1:
ORA-01154: database busy. Open, close, mount, and dismount not allowed now
I am having trouble changing a non-displayed field when a displayed field is changed.
When a user wants to un-assign a territory they want to just null the ID field (non-database item). I then need to null the PIDM field(not visible, database item) for that one record.
I tried this, but I end up putting null on all the records instead of just the one record, which ends up un-assigning all the territories not just the one.
Is there a way to assign the null to the PIDM field associated to the ID field of that particular record.
i have a tablespace which contains 121 datafile(max limit reached) as a dba what we have to do?
creating a new tablespace with a datafile and assign the users to the current tablespace which i created now.iif the above process is correct,after some time the tablespace which was filled up got freed up.now can i give the access to the users previous (i.e. freed up tablespace) and current tablespaces
I have a strange problem when creating a view in user from another user
I have a user called "Cash_tst"
its syntax creation is
-- Create the user
create user CASH_TST
identified by ""
default tablespace CASH
temporary tablespace TEMP
profile DEFAULT
quota unlimited on cash;
-- Grant/Revoke object privileges
grant connect to CASH_TST;
grant dba to CASH_TST;
grant resource to CASH_TST;
-- Grant/Revoke system privileges
grant create any view to CASH_TST;
grant unlimited tablespace to CASH_TST;
I want to create a view
CREATE VIEW TAMER
AS SELECT *
FROM [b]AROFL[/b].RA_CUSTOMER_TRX_LINES_ALL_BEFO
"AROFL" is another user on the same database
when try to create the view "tamer" i got message of
"insufficent privilege"
although i granted "create any view" to the user "cash_tst"
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