Hi, I have installed Oracle 11g (latest version 11.2.0.1.0) on my system. During the installation it didnt ask me to set username or any password. I'm unable to start sql plus because i dont have the username and password. Can anyone tell me what is the default username and password or what is the default password for SYS or SYSTEM? Thanks, VC

Member Avatar
Member Avatar
+0 forum 46

Hi Every Body i have a server and a numbers of clients and i when i want to open a page on the clients machine it is open in the server insted of the specified client machine. i am using host to open the required page and i am trying to use web.show_document but it is not working. i am using oracle developer 10g Any help please?????? thankyou very much

Member Avatar
Member Avatar
+0 forum 1

Hello Everyone I want to take a backup of the oracle database using c# am using the code below but give this error: System.InvalidOperationException: 'The Process object must have the UseShellExecute property set to false in order to redirect IO streams. any help please????????? System.Diagnostics.Process p = new System.Diagnostics.Process(); string strexp = "exp userid='system/M19871991b@orcl as sysdba' full=yes file='c:\qw.dmp'"; p.StartInfo.FileName = "cmd.exe"; p.StartInfo.UseShellExecute = true; p.StartInfo.RedirectStandardInput = true; p.StartInfo.RedirectStandardOutput = true; p.StartInfo.RedirectStandardError = true; p.EnableRaisingEvents = true; p.StartInfo.CreateNoWindow = true; try { p.Start(); p.StandardInput.WriteLine(strexp); p.StandardInput.WriteLine("exit"); p.WaitForExit(); MessageBox.Show("s"); } catch (Exception ex) { throw ex; }

Member Avatar
Member Avatar
+0 forum 1

Getting an empty drop-down list by the following code. Trying to fetch names from the department table. Using an oracle Database... <label for="department">Department</label> <select class="form-control" name="deptname" id="deptname"> <option selected disabled></option> <?php $dbUser = "..."; $dbPass = "..."; $dbConn = "(DESCRIPTION = (ADDRESS = (PROTOCOL=TCP)(HOST=...)(PORT=1521))(CONNECT_DATA=(SID=...)))"; $conn = oci_connect($dbUser, $dbPass, $dbConn); $sql = oci_parse($conn,"SELECT Department1.NAME FROM Department1"); oci_execute($sql, OCI_DEFAULT); ?> <?php while (oci_fetch($sql)) { ?> echo '<option value="<?php echo oci_result($sql, 'NAME')?>"></option> <?php }?> </select>

Member Avatar
+0 forum 0

hello i have oracle database 10g as my sql server. i didnt use it for over a year and now when i open it the page just closes without any warning or error after entering the username and password. i reinstalled it and the problem is still there. i can't find why it happened and how to solve it. please do help me.

Member Avatar
Member Avatar
+0 forum 1

Hi Please why I got this error(SQL Error: ORA-00907: missing right parenthesis) whats wrong in my code? CREATE TABLE artphoto( photonr NUMBER(10), artnr NUMBER(10) NOT NULL, filtyp VARCHAR2(5) NOT NULL, path VARCHAR2(100) NOT NULL, CONSTRAINT artphoto_photonr_pk PRIMARY KEY(photonr), CONSTRAINT artphoto_artnr_fk FOREIGEN KEY(artnr), REFERENCES art(artnr), CONSTRAINT artphoto_filtyp_ck CHECK(filtyp in ('gif','jpg')) ); Error starting at line 1 in command: CREATE TABLE artphoto( photonr NUMBER(10), artnr NUMBER(10) NOT NULL, filtyp VARCHAR2(3) NOT NULL, path VARCHAR2(200) NOT NULL, CONSTRAINT artphoto_photonr_pk PRIMARY KEY(photonr), CONSTRAINT artphoto_artnr_fk FOREIGEN KEY(artnr), REFERENCES art(artnr), CONSTRAINT artphoto_filtyp_ck CHECK(filtyp in ('gif','jpg')) ) Error at Command Line:8 Column:44 Error report: SQL Error: ORA-00907: …

Member Avatar
Member Avatar
+0 forum 9

hi i used this simple form which are these..but i want to protect password from oracle database if user enter wrong name and password then not login otherwise login <!DOCTYPE HTML> <html> <head><br> <style> .error {color: #FF0000;} </style> </head> <body style="font-family: verdana, sans-serif;";> <hr /> <div style="width: 77%; height: 300px; padding: 30px; border: 5px solid #e3e3e3; background-color: #F8F8F8 ; color: #000; margin: 100px;" align="center"> <br> <h2>Login</h2> <form method="post" action="login.php"> <font size="3">name:<input type="text" name="name" style="padding: 4px;"/><p> password: <input type="password" name="password" style="padding: 4px;"/><p> <input type="submit" value="Login" style="padding: 4px; width: 5em; height: 1.9em;"/></font> </form> </div> </body> </html>

Member Avatar
Member Avatar
+0 forum 1

i have a two menu bar option which are home and my account after login my user and pswd its show home page but when i change home to my account page its show message below and logout Notice: Undefined index: user in folder\myaccount.php Notice: Undefined index: pswd in folder\myaccount.php you are not logged in these both fields are my login page variables user and pswd

Member Avatar
Member Avatar
+0 forum 4

hi everyone hope you are all well... i am login with userid and password and i want to display there username after login from my oracle database how?

Member Avatar
Member Avatar
+0 forum 3

i want to display my image from a folder but its not work what i change in code to work <?php $dir_path = "/xampp/htdocs/image/"; $extensions_array = array('jpg','png','jpeg'); if(is_dir($dir_path)) { $files = scandir($dir_path); for($i = 0; $i < count($files); $i++) { if($files[$i] !='.' && $files[$i] !='..') { // get file name echo "File Name -> $files[$i]<br>"; // get file extension $file = pathinfo($files[$i]); $extension = $file['extension']; echo "File Extension-> $extension<br>"; // check file extension if(in_array($extension, $extensions_array)) { // show image echo "<img src='$dir_path$files[$i]' style='width:100px;height:100px;'><br>"; } } } }

Member Avatar
Member Avatar
+0 forum 1

hi everyone i need help in my query while user login. <?php $username = $_POST["username"]; $password = $_POST["password"]; $con = oci_connect("user","pswrd","db"); if(! $con) { die('Connection Failed'.oci_error()); } $query = "SELECT username, password FROM users WHERE username=$username"; $stmt = oci_parse($conn, $query); $row = oci_fetch_array($stmt, OCI_NUM);; if($row["username"]==$username && $row["password"]==$password) echo"You are a validated user."; else echo"Sorry, your credentials are not valid, Please try again."; ?> i got error which is that oci_fetch_array(): ORA-24374: define not done before fetch or execute

Member Avatar
Member Avatar
+0 forum 5

hi everyone hope you all are in good. i have query while login form in php with oracle database..... i want to simple login with database html code: <p> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> Username:<br /><input type="text" name="username" size="10" /><br /> Password:<br /><input type="password" name="password" size="10" /><br /> <input type="submit" value="Login" /> </form> </p> php code: <?php session_start(); if (! isset($_SESSION['username'])) { if (isset($_POST['username'])) { $username = htmlentities($_POST['username']); $password = htmlentities($_POST['password']); $conn = oci_connect('user', 'pswrd', 'db') or die("Can't connect to database server!"); $query = "SELECT username, password FROM users WHERE username=:username AND password=:password"; $stmt = oci_parse($conn, $query); oci_bind_by_name($stmt, ':username', …

Member Avatar
Member Avatar
+0 forum 1

i want to show calendar in php show in image below connected to oracle database table. ![ywub5.png](/attachments/large/4/10022dd703908aa37616b34022b15f64.png "align-center")

Member Avatar
Member Avatar
+0 forum 2

Hi All, I am working on Oracle 11.2.0.3. and my requirement is, I have a table in Development(Dev) called " Dev_EMP". Have created Synosym for "Dev_EMP" as "SY_DEV_EMP" here is the structure [/code] create table Local_emp ( tran_id varchar2(10), acct_id varchar2(15) ); [/code] 2. Table which I am planning to access from Production is as below. create table c_emp ( tran_id varchar2(10), ex_ind varchar2(20), f_id varchar2(20) emp_stud clob ); [/code] Now the requirement is would like copy "ex_ind","f_id" columns from PROD to DEV table i.e"Dev_EMP" alias "SY_DEV_EMP" and load the data to these columns data from Production table "c_emp" to …

Member Avatar
+0 forum 0

Hi, I am currently working on Oracle 11.2.0.3. Below is my requirement. 1.I would like to scan the database ( Eg. 1 entire schema) and need to find the DB object either Procedure/Funcation which is having DROP statement. ( some of the procedures having " DROP PROCEDURE <PROCEDURE_NAME> " statements. 2. Need to take the list of those objects ( having the DROP statements). (in Excel/CSV) 3. Then need to drop only those objects from the schema. Can any one please advise. Thanks, Vas

Member Avatar
Member Avatar
+0 forum 2

CREATE TABLE BUILDING(bname VarChar2(30) PRIMARY KEY, address VarChar2(30), phone number Number(15)); i write this code in sql command of oracle application express. but there is a error ORA-00907: missing right parenthesis anyone help me please i am new in oracle world

Member Avatar
Member Avatar
+0 forum 3

How to open and view the folder from my computer using plsql?

Member Avatar
Member Avatar
+0 forum 2

I have been butting my head against this problem for the past 4 hours, and I have to tap out. I know I can't be too far from correct I am just not sure what the missing ingredients are. Here is the problem question: Student status: List of all students and their enrollment status Fields: student last name and first name (comma separated), years enrolled, academic advisor last name and first name (comma separated) Sort: years enrolled Input: none Filter: only include currently active students and My code: SELECT student_id,std_l_name, std_f_name, faculty_l_name, faculty_f_name,student_id_fk,enroll_date,MONTHS_BETWEEN(CURRENT_DATE ,enroll_date) V1: FROM STUDENT, FACULTY,ENROLLMENT WHERE FACULTY.faculty_id=STUDENT.faculty_id_fk3 …

Member Avatar
Member Avatar
+0 forum 2

i have this code..,. i dont see what's wrong why its only working on the first record of LOOP of X set serveroutput on size 30000; DECLARE VTEMP NUMBER; VPARENT NUMBER; BEGIN FOR X IN ( SELECT TEMPLATE_ID, TYPE_ID, TYPE_KIND, RECORD_ID FROM RT_RECORDS WHERE TEMPLATE_ID = 106 )LOOP DBMS_OUTPUT.PUT_LINE('TYPE_ID X :' || X.TYPE_ID ); FOR Y IN ( SELECT OBJECT_ID, OBJECT_TYPE CHILD_TYPE, LEVEL, PARENT_ID, RPA_N.GETTYPEID(PARENT_ID)PARENT_TYPE FROM NODES N CONNECT BY PRIOR N.OBJECT_ID = N.PARENT_ID START WITH N.OBJECT_ID = 18464078 ) LOOP DBMS_OUTPUT.PUT_LINE('TYPE_ID :' || X.TYPE_ID || ' PARENT_ID: ' || Y.PARENT_TYPE ); IF X.TYPE_ID = Y.PARENT_TYPE THEN -- CHILD SELECT …

Member Avatar
Member Avatar
+0 forum 1

Hi! I have here data: i don't have any idea on how to insert the details in TABLE2... as you can see, the parent_id is based on TABLE1, TABLE 1 TABLE 2 (INSERTED IN NEW TABLE) LEVEL TYPE_TABLE PARENT_NAME RECORD_ID OBJECT_TYPE RECORD_ID PARENT_ID (RECORD_ID FROM TABLE 1) 1 NODEB EQUIPMENT 1 NODEB 2 NODEB_RADIO_MODULE NODEB 2 NODEB_RADIO_MODULE 2 1 2 NODEB_SYSTEM_MODULE NODEB 3 NODEB_SYSTEM_MODULE 3 1 2 NODEB_RADIO_MODULE NODEB 4 NODEB_RADIO_MODULE 4 1 3 NODEB_IF_CARD NODEB_SYSTEM_MODULE 5 NODEB_IF_CARD 5 3 3 CLOCK_PORT NODEB_SYSTEM_MODULE 6 CLOCK_PORT 6 3 3 ETHERNET_PORT NODEB_SYSTEM_MODULE 7 ETHERNET_PORT 7 3 3 ETHERNET_PORT NODEB_SYSTEM_MODULE 8 ETHERNET_PORT 8 …

Member Avatar
+0 forum 0

i'm trying to find in all tables with data in all columns.. example EMPLOYEE table with ID = 123 COLUMNS DATA ID 1 NAME TEST ADDRESS TESTADDRESS PHONE EMAIL POSITION DEV The output will be ID, NAME, ADDRESS, and POSITION.. so basically all columns with data only.. by the way, i can't rely on NUM_DISTINCT in USER_TAB_COLUMNS..

Member Avatar
+0 forum 0

hi everyone how can I parsing string into token in pl sql? example this is my string "170823-14785" and the parsing I want like this 17 08 23 -1 47 85

Member Avatar
Member Avatar
+0 forum 1

hi everyone i am new programer in oracle,i have save the url of the folders in the SQL server and i want to open or select a folder using the saved url by oracle plsql. I have select the url from the database, but the problem i don't know how to open the folder using this url. I search alot but I find only how to open file not folder. please help me thanks for your listening....

Member Avatar
+0 forum 0

i am a new bee to oracle and database world, i need your help, as i am a student i learnt some commands in class, how to retrieve the tables and its contents in 10g, my question is that, is there any builtin tables in oracle 11g as well if yes then how i enable and view it, also let me know how can i install SQLplus for oracle 11g thanks

Member Avatar
Member Avatar
+0 forum 1

Hello, I rebooted my server and it won't startup due to the below error, now server is not getting up, its throwing the below error and keep trying to connect to Oracle, so I am unable to access the server to free some space if its the issue as per some googling, any advice how to overcome this issue? how can i startup my server in order to diagnose these errors? ERROR: ORA-09817: Write to audit file failed. Linux-x86_64 Error: 28: No space left on device Additional information: 12 ORA-09945: Unable to initialize the audit trail file Linux-x86_64 Error: 28: …

Member Avatar
Member Avatar
+0 forum 11

Hi Dw. Long time ago I think late last year my computer was infected and I had installed a VM from Oracle and had a number of OS(VMs) installed one of them was with Win7 but I don't know what happened one day, when I open the VM it was blank as if its new there is now VM instance that has been installed. When I went on the folder where its keeps these instances I saw that they are still there and when you double click that orange file it opens the VM with the instance. Now the problem …

Member Avatar
Member Avatar
+0 forum 7

/DROP TABLE STATEMENTS/ DROP TABLE BRANCH CASCADE CONSTRAINT PURGE; DROP TABLE SCREEN CASCADE CONSTRAINT PURGE; DROP TABLE SESSIONS CASCADE CONSTRAINT PURGE; DROP TABLE MOVIE CASCADE CONSTRAINT PURGE; /CREATE TABLE STATEMENT/ CREATE TABLE BRANCH( BRANCHID CHAR(2)NOT NULL, BRANCHNAME VARCHAR2(20), BRANCHSUBURB VARCHAR2(15), BRANCHPOSTCODE CHAR(4), CONSTRAINT BRANCH_PK PRIMARY KEY(BRANCHID)); CREATE TABLE SCREEN( SCREENID CHAR(2) NOT NULL, BRANCHID CHAR(2) NOT NULL, SCREENCAPACITY NUMBER(3), CONSTRAINT SCREEN_PK PRIMARY KEY(BRANCHID,SCREENID), CONSTRAINT SCREEN_FK1 FOREIGN KEY(BRANCHID)REFERENCES BRANCH(BRANCHID)); CREATE TABLE MOVIE( MOVIEID CHAR(2) NOT NULL, MOVIENAME VARCHAR(20), MOVIEGENRE VARCHAR(20), MOVIECLASSIFICATION VARCHAR(5), CONSTRAINT MOVIE_PK PRIMARY KEY(MOVIEID)); CREATE TABLE SESSIONS( SESSIONID CHAR(4), BRANCHID CHAR(2)NOT NULL, SCREENID CHAR(2)NOT NULL, MOVIEID CHAR(2)NOT NULL, SESSIONDATE …

Member Avatar
Member Avatar
+0 forum 2

Hi, I want to delete about 60 crore records from few oracle audit tables to free up some space. I am planning to delete them in batches of size 10,000. I dont want to use up lot of space while performing these deletes. Can someone suggest me a way to avoid logs being generated while performing these deletes. Thanks, Aravind

Member Avatar
+0 forum 0

Iam using windows 7 32 bit and Oracle 11g SQL> spool off SQL> host type c:\spool.txt The system cannot find the file specified. help me to solve the above ploblem

Member Avatar
Member Avatar
+0 forum 1

Create Table Non_Game ( P_Id int Not_Null, Item_Num Char(4) Not Null, Description Char(30), On_Hand Decimal(4,0) Category Char(3) Price Decimal(6,2), ))

Member Avatar
Member Avatar
+0 forum 5

The End.