Server Administration :: Manual Database Creation
Jan 21, 2011
manual DB creation.I gone through the below steps:
1) created appropriate folders.
2) Copied a PFILE from an existing DB and changed the contents like DB name etc...
3)Then I Created a text file called %ORACLE_HOME%DATABASEinitmuktha.ora with the following contents: ifile=c:pragpfileinitmuktha.ora
4) Then i set Oracle SID (Through Environment variable in MY COMPUTER --> PROPERTIES...)
5) Then I Created a Windows service for the DB.
6) startup nomount pfile= c:pragpfileinitmuktha.ora
7) Then I ran the database creation command.
The DB was created but when i log in again, it is looking for the pfile in the another DB's location rather than from "%ORACLE_HOME%DATABASE". Where i missed out to create new oracle_home folder?
View 6 Replies
ADVERTISEMENT
Sep 16, 2011
i am creating database manually in oracle 9i os version ibm-aix5.3 it showing following error
CREATE DATABASE "varathu"
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-00200: controlfile could not be created
ORA-00202: controlfile: '/backup/varathu/control01.ctl'
ORA-27040: skgfrcre: create error, unable to create file
IBM AIX RISC System/6000 Error: 13: Permission denied
View 18 Replies
View Related
Feb 7, 2011
I am trying to create a DB manually.
1) How to create a UNIX services as we use oradim in windows.
2) While trying to use DBCA command it shows the below message.
SET DISPLAY ENVIRONMENT THEN RE-RUN.
My login is already in admin group only.
View 7 Replies
View Related
Feb 5, 2011
While creating a Manual DB creation, syntax as below:
%ORACLE_HOME%DATABASEinitprag.ora which will have a seperate file as below:
ifile=c:pragatpfileinitprag.ora
1) Why we need to divert the pfile into another location?
2) Can we keep the pfile inside the location - %ORACLE_HOME%DATABASE?
View 1 Replies
View Related
Mar 14, 2011
I created manually a database in 10g, after succesfully creating the dB, I created a single user re: LAMS. Now, I noticed that my USERS tablespace is currently at a 99.96% usage:
SQL> @check_space_used.sql
Monday, March 14, 2011 2:46:22 PM SGT
TABLESPACE_NAME TOTALSPACE TOTALBYTES PERCENTUSED
------------------------------ -------------------- -------------------- --------------------
SYSTEM 1073741824 239599616 23
UNDO 268435456 16449536 7
[code]...
View 5 Replies
View Related
Apr 24, 2012
We have a 2 node RAC installation on IBM AIX 5.3 with Oracle Standard Edition. We need to create a manual standby database (becoz Standard Edition does not allow Dataguard confign). Can we do this on a different platform (eg: Linux/Windows). This is to make use of existing servers for the standby environment.
View 1 Replies
View Related
Feb 21, 2013
how to create database manually(without dbca).
View 2 Replies
View Related
Aug 15, 2010
I'm getting a "TNS disconnect" after database creation script creation in DBCA. Haven't figured out what's going on. I'm attempting to create a 2nd database on one linux 64 server. I get all the way through DBCA, but it won't go the final mile. Any thoughts? I've tried setting the port to a different port from the existing LISTENER, creating a LISTENER2 and associating it with the 2nd instance.
View 1 Replies
View Related
Jun 10, 2010
It's been 2 days from now that I'm bugging with this kind of error in my manual dB creation. I used DBCA first but we had a default directory settings, that's why I resorted to create the db manually. The dB was already created and currently has a status of STARTED.. I cannot mount it due to this error:
SQL> startup nomount
ORACLE instance started.
Total System Global Area 247463936 bytes
Fixed Size 2235856 bytes
Variable Size 177840688 bytes
[code]....
View 3 Replies
View Related
Jun 24, 2012
Problem Description: There are five range partitioned tables which are partitioned by date,designed by previous DBA.Four tables are in one tablespace and one more table is in another tablespace.For every three months there are two tablespaces are created autamatically in new names for future dates.There is no scheduled job for this.How they are created?.This is our question.
View 3 Replies
View Related
Jun 14, 2012
will it be possible to create db_link between two operating system authenticated users belongs to different databases?
View 5 Replies
View Related
Jan 20, 2010
What do you think of this 11.2 parameter? It can give some pretty weird results.
SQL> create tablespace ts1 datafile size 10m;
Tablespace created.
SQL> create table t1 (c1 date) tablespace ts1;
Table created.
SQL> drop tablespace ts1;
Tablespace dropped.
SQL> insert into t1 values(sysdate);
insert into t1 values(sysdate)
[code]...
View 5 Replies
View Related
May 13, 2013
if it is possible to create a failover setup without RAC and DG...For example:
I have 11.2.0.2 database (with EBS 12.1.3) on dbnode1...I would like to create another node to failover my primary datbas in case of any failure.
Steps i will follow:
1: creat dbnode2
2: install same os as dbnode1
3: install same oracle as dbnode1
4: share dbnode2
database between dbnode1
and dbnode2
Now, if hardware fails on dbnode1, can i manually failover and start my database on dbnode2?
I know we can do with RAC and DG,BUT without RAC and DG If not possible..
View 4 Replies
View Related
Nov 29, 2011
I need the step by step procedure for the cloning of database in linux environment .
View 2 Replies
View Related
Feb 12, 2013
OS: Solaris
DB: Oracle 11.2.0.1 EE
Not Using ASM or RAC
I have a Production database that is in archivelog mode and a Standby DR server. Both servers (Prod, Standby) have exact same structure and db name/version.
We manually scp archive logs and recover them to a manual standby database via SQL Scripts "cron". (I.E. set autorecovery on; recover standby database;)
We recently got out of sync with our log files and have not been applying them to the standby. As part of Prod Maintenance, these log files were deleted and are not available anymore.
I've tried several ways to "rebuild" our standby database. I have tried to Shutdown prod, backup all the db files and scp them to standby, re-create standby controlfile and startup mount and recover standby. Every time I try to apply a new archive log via recover standby, these are the errors:
ORA-00279: change 211077622 generated at 1/27/2012 12:18:42 needed for thread 1
ORA-00289: suggestion : /oradump/arch/PROD/PROD_arch_1_69486_736618850.arc
ORA-00280: change 211077622 for thread 1 is in sequence #69486
ORA-00308: cannot open archived log '/oradump/arch/PROD/PROD_arch_1_69486_736618850.arc'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/oradevices/PROD/oraPRODsystem1.dbf'
When I check v$log_history, the new logs have not been applied. I've also tried the "Restore from incremental backup via SCN" method with same results. Is there a way to re-create the standby clean and ensure that the log chain that is currently broken gets fixed or reset? I would eventually like to get DataGuard in here, but that's not the case at the moment.
View 5 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
Jan 28, 2013
I have installed oracle database 11gr2 in laptop1 and installed oracle database 11gr2 in laptop2.Both the laptop's are connected to same internet connection through wifi. So my question is can i create a database link between these two databases using this wifi? give some steps in creation of a database link.
View 13 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
May 15, 2012
I am having a template file (only .dbt file) to create the database instance.I Kept it in $ORACLE_HOME/assistant/dbca/template/,after running DBCA it was loaded with details mentioned in it ,but at the second last step when i try to see initialization parameters control file ,datafile and tablespace detail was not mentioned.when it started database creation ,got hanged on 5% completion showing failure in processing system parameters. Is it the right way to create database using DBCA?what should I do to create database using template?
View 1 Replies
View Related
Jan 17, 2003
Creating RAX 9.2.0 on SP2-AIX-4.3.3 64 bit hangs (2 node configuration) tablespacess are on VSD/raw partitions.
View 3 Replies
View Related
