Learn more no protocol specified when running a sudosu app on ubuntu linux. Creating databases in silent mode this article demonstrates how to create a new database using the database configuration assistant dbca in silent mode. In an earlier post we had discussed the installation process of the release 12. Jan 23, 2017 oracle database instance 12c on oracle linux non cdb. Noclassdeffounderror, even you set classpath correct. In this example, im creating a simple oracle listener service called listener using the default port of 1521. This is the first local x display, accessed over tcp. No protocol specified error while running asmca command. The ssh protocol has the ability to securely forward x window system applications over your encrypted ssh connection, so that you can run an. The display to use is normally indicated by the display environment variable, and that variable tends to be set correctly automatically.
Actually, the question is whether this is a playtoy database for your own use, where customizing your hosts file may be a simple way to go to give yourself access, but if this is a production environment and needs to be reachable for support by a production dba team, then a more elegant solution may be warranted. The information in templates includes database options, initialization parameters, and storage attributes for datafiles, tablespaces, control files, and online redo logs. I have installed the oracle db 18c ee from the oracle repository. Mar 19, 20 in this example, im creating a simple oracle listener service called listener using the default port of 1521. I had this problem before with other laptops, but the other solutions worked that time. In addition to creating databases, the dbca can be used to modify or delete them, as well as managing templates and pluggable databases in oracle 12c. If you get the above error, please execute the below command as root.
Experts with gold status have received one of our highestlevel expert awards, which recognize experts for their valuable contributions. Its very useful method especially when you want to prepare standard installation using shell scripts. Feb 20, 20 creating oracle 11g database using database creation assistant dbca oracle database creation. Usually, if display has the wrong value, its because youve been messing with it. Creating an oracle 11g database using dbca non asm posted on may 19, 20 by garth in this example, ive already installed the oracle database 11gr2 software 11. It seems that running dbca with gui will hang at some specific steps under xwindow environments, therefore, we should avoid to step on the traps during creating a database. Before you create a new database by dbca with graphic interface, you.
The database didnt install correctly when i installed the oracle software. Our community of experts have been thoroughly vetted for their expertise and industry experience. The x windows system permit to see on your local computer, software that run on a remote server. If you get the above error, please execute the below command as root and then start the dbca by connecting as oracle.
To start dbca on unix or linux, or at the commandline prompt on the windows operating system, enter the following command. Your program probably does look up the value of the display environment. Creating oracle 11g database using database creation assistant dbca oracle database creation. Install oracle linux 6 64 bitfor comfort set 4g memory for your virtual machine. After an installation with all preinstallations i have the next exception after starting the dbca. I made some small changes to make it easier to debug. Dec 03, 2012 in my experience, to create a new database by dbca with silent mode in a 9i database on linux, you must issue the dbca command under a xwindow environment, otherwise, you will get java.
Dbca then guides you through the steps to create the database. Start the oracle net configuration assistant netca open an xwin. Hi, from my windows workstation i can connect with putty to an aix 6. During oracle database installation, if you choose to create a starter database see step 4, oracle universal installer automatically runs database configuration assistant dbca after software installation is complete.
My oracle support provides customers with access to over a million knowledge articles and a vibrant support community of peers and oracle experts. Passionate about programming, design, databases, architecture and all that comes under the umbrella of software engineering. Software for 12cr1 is available on otn or edelivery. Download software download the oracle software from otn or mos or get a downloaded zip file. In my experience, to create a new database by dbca with silent mode in a 9i database on linux, you must issue the dbca command under a xwindow environment, otherwise, you will get java.
Oct 21, 2016 passionate about programming, design, databases, architecture and all that comes under the umbrella of software engineering. If a listener is already present on the system, the form displays the currently defined listener plus an empty row below it. During oel6 installation i drop user oracle and both group dba and oinstall. This myuser needs to execute a python library that. Templates are used in dbca to create new databases and clone existing databases. His main interests are high availability and disaster recovery solutions for mission critical 24. Dec 27, 2019 oracle database configuration assistant version 10.
Check for this environment variable for oracle users. But the most ironic thing is, if you can read more how to create a 9i database by dbca with silent mode. Silent mode installation allows to configure necessary oracle components without using graphical interface nor any interaction with end user. If no listener has been created on the linux host so far maybe this is the first time you are running dbca the form displaysone single row with an empty name and an empty port number. When i open a session with vncserver and type dbca, either as root or as oracle, i get these errors. This article presents how to install oracle 11g release 2 in silent mode.
No protocol specified cant connect to x11 window server using. Log in to get rid of this advertisement ive found this problem solved everywhere and i tried a lot of suggestions. Let us now look at the creation of an oracle 12c database using the database configuration assistant dbca and briefly discuss what is new as compared to 11gr2. Overview of database configuration assistant dbca oracle. How to create a 9i database by dbca with graphic interface. Stack overflow for teams is a private, secure spot for you and your coworkers to find and share information. Ora01078 can not delete database from dbca on linux. If this is not defined then please define it and logout and login again. Oracle database configuration assistant version 10.
Dbca templates are xml files that contain information required to create a database. Silent mode installation allows to configure necessary oracle components without using graphical interface means no need to user interaction. Creating an oracle 11gr2 database using dbca nonasm. Oracle12c database creation using dbca oracle dba tips. Before trying to make dbca work, try to make xclock work. Remote connections to the database server fail with ora12547 cause. Use xhost command to add the database server to your allowed list.